Optimizing MySQL Databases for Large-Scale PHP Web Applications
Keywords:
Large-Scale Web Applications, Database Performance, Query Optimization.Abstract
This research delves into the optimization of MySQL databases for large-scale PHP web applications. Database performance is crucial for the overall efficiency of web applications, especially as they scale. The study aims to investigate strategies for optimizing MySQL databases in conjunction with PHP to handle the challenges posed by large-scale usage. Through benchmarking, query optimization, and scalability testing, the research seeks to provide practical insights into enhancing the performance and responsiveness of PHP web applications operating on sizable MySQL databases.
References
Arifin, N. Y., Suri, G. P., Veza, O., & Setyabudhi, A. L. (2021). Dashboard Penentuan Penerima Kartu Indonesia Sehat (KIS) Pada Kelurahan Binuang Kampung Dalam Dengan Metode Simple Additive Weighting. JURSIMA, 9(1), 1-9.
Veza, O., Setyabudhi, A. L., Arifin, N. Y., & Agustini, S. (2023). Simulation Modeling System in Determining the Amount of Oil Inventory. Journal of Computer Networks, Architecture and High Performance Computing, 5(1), 110-119.
Setyabudhi, A. L., & Veza, O. (2022). Analysis of the Effectiveness of the Implementation of Online Learning at the Beginning of the Covid-19 Pandemic. Technical and Vocational Education International Journal (TAVEIJ), 2(2), 1-7.
Veza, O., Larisang, L., Setyabudhi, A. L., Arifin, N. Y., Syofiawan, D., & Martino, H. G. (2024). Analysis and Design of Web-based Internal Office Memo (IOM) Management System. Indonesian Journal of Computer Science, 13(1).
Veza, O., & Setyabudhi, A. L. (2022). Perancangan Pelatihan Algoritma Dasar dan Setup Access Point Untuk Siswa SMK/SMA. Jurnal Pengabdian Masyarakat Mandiri (JPMM), 1(01), 21-23.
Arifin, N. Y., & Veza, O. (2019). Dashboard sistem aplikasi pengelolaan obat. Engineering and Technology International Journal, 1(01), 59-65.
Arifin, N. Y., Saro, D., & Adam, R. (2020). Dashboard Monitoring Kinerja Aparatur Sipil Negara Pada Dinas Pengelolaan Pajak Provinsi Kepulauan Riau. Elkom: Jurnal Elektronika dan Komputer, 13(2), 70-86.
Setyabudhi, A. L. (2017). Perancangan Sistem Informasi Pengolahan Data Absensi dan Pengambilan Surat Cuti Kerja Berbasis Web. Jr: Jurnal Responsive Teknik Informatika, 1(01), 11-22.
Setyabudhi, A. L. (2017). Perancangan Sistem Informasi Pengolahan Data Absensi dan Pengambilan Surat Cuti Kerja Berbasis Web. Jr: Jurnal Responsive Teknik Informatika, 1(01), 11-22.
Arifin, N. Y., Kom, S., Kom, M., Tyas, S. S., Sulistiani, H., Kom, M., ... & Kom, M. (2022). Analisa Perancangan Sistem Informasi. Cendikia Mulia Mandiri.
Veza, O., & Arifin, N. Y. (2023). TRAINING TO ENHANCE COMPETENCY IN USING GRAPHIC DESIGN APPLICATIONS AS INTERACTIVE MEDIA: A CASE STUDY OF STUDENTS AT THE FACULTY OF ENGINEERING, IBNU SINA UNIVERSITY. Jurnal Pengabdian Masyarakat Mandiri (JPMM), 1(02), 102-107.
Kurdi, M. S., Arifin, N. Y., & Mohammad, W. (2023). Character Formation of Muslim Children Through Indigenous Education in Stone Floor Elementary Schools. Journal Emerging Technologies in Education, 1(6), 354-365.
Demmanggasa, Y., Sabilaturrizqi, M., Kasnawati, K., Mardikawati, B., Ramli, A., & Arifin, N. Y. (2023). Digitalisasi pendidikan: akselerasi literasi digital pelajar melalui eksplorasi teknologi pendidikan. Community Development Journal: Jurnal Pengabdian Masyarakat, 4(5), 11158-11167.
Legito, L., Riau, N. P., Putro, A. N. S., Mardiani, E., Arifin, N. Y., Sepriano, S., & Erkamim, M. (2023). Penerapan Algoritma K-Nearest Neighbor untuk Analisis Sentimen Terhadap Isu Khilafah dan Radikalisme di Indonesia: Implementation K-Nearest Neighbor Algorithm for Sentiment Analysis on Khilafah and Radicalism Issues in Indonesia. MALCOM: Indonesian Journal of Machine Learning and Computer Science, 3(2), 324-330.
Ruqoyah, R., Afriani, Y., Fahleti, W. H., Arifin, N. Y., Zarvianti, A. A., & Ramadhan, A. R. (2023). Analisa Pendapat Masyarakat terhadap Pemanfaatan Aplikasi Pinjaman Online. Jurnal Pendidikan Tambusai, 7(3), 22820-22825.
Arifin, N. Y., Suri, G. P., Veza, O., & Setyabudhi, A. L. (2021). Dashboard Penentuan Penerima Kartu Indonesia Sehat (KIS) Pada Kelurahan Binuang Kampung Dalam Dengan Metode Simple Additive Weighting. JURSIMA, 9(1), 1-9.
Veza, O., Setyabudhi, A. L., Arifin, N. Y., & Agustini, S. (2023). Simulation Modeling System in Determining the Amount of Oil Inventory. Journal of Computer Networks, Architecture and High Performance Computing, 5(1), 110-119.
Setyabudhi, A. L., & Veza, O. (2022). Analysis of the Effectiveness of the Implementation of Online Learning at the Beginning of the Covid-19 Pandemic. Technical and Vocational Education International Journal (TAVEIJ), 2(2), 1-7.
Veza, O., & Setyabudhi, A. L. (2022). Perancangan Pelatihan Algoritma Dasar dan Setup Access Point Untuk Siswa SMK/SMA. Jurnal Pengabdian Masyarakat Mandiri (JPMM), 1(01), 21-23.
Arifin, N. Y., & Veza, O. (2019). Dashboard sistem aplikasi pengelolaan obat. Engineering and Technology International Journal, 1(01), 59-65.
Arifin, N. Y., Saro, D., & Adam, R. (2020). Dashboard Monitoring Kinerja Aparatur Sipil Negara Pada Dinas Pengelolaan Pajak Provinsi Kepulauan Riau. Elkom: Jurnal Elektronika dan Komputer, 13(2), 70-86.
Setyabudhi, A. L. (2017). Perancangan Sistem Informasi Pengolahan Data Absensi dan Pengambilan Surat Cuti Kerja Berbasis Web. Jr: Jurnal Responsive Teknik Informatika, 1(01), 11-22.
Setyabudhi, A. L. (2017). Perancangan Sistem Informasi Pengolahan Data Absensi dan Pengambilan Surat Cuti Kerja Berbasis Web. Jr: Jurnal Responsive Teknik Informatika, 1(01), 11-22.
Veza, O., & Arifin, N. Y. (2023). Implementation of TK Ibnu Sina Batam's Company Profile Using Visitor-Based User Experience Method. Engineering and Technology International Journal, 5(02), 181-189.
Suri, G. P., & Arifin, N. Y. (2022). Pelatihan Pengolahan Data Aplikasi SPSS Pada Siswa SMK Ibnu Sina Batam. Media Pengabdian Kepada Masyarakat (MPKM), 1(01), 29-32.
Arifin, N. Y., & Prayogi, A. (2022). Perancangan Dashboard Sistem Informasi File Elektronik Pengarsipan BPKB Direktorat Lalulintas Polda Kepri. JR: Jurnal Responsive Teknik Informatika, 6(01), 61-70.
Arifin, N. Y. (2022). Document Management System in Ibnu Sina Middle School Administration. Engineering and Technology International Journal, 4(01), 38-44.
Arifin, N. Y., Suri, G. P., Veza, O., & Setyabudhi, A. L. (2021). Dashboard Penentuan Penerima Kartu Indonesia Sehat (KIS) Pada Kelurahan Binuang Kampung Dalam Dengan Metode Simple Additive Weighting. JURSIMA, 9(1), 1-9.
Veza, O., Setyabudhi, A. L., Arifin, N. Y., & Agustini, S. (2023). Simulation Modeling System in Determining the Amount of Oil Inventory. Journal of Computer Networks, Architecture and High Performance Computing, 5(1), 110-119.
Setyabudhi, A. L., & Veza, O. (2022). Analysis of the Effectiveness of the Implementation of Online Learning at the Beginning of the Covid-19 Pandemic. Technical and Vocational Education International Journal (TAVEIJ), 2(2), 1-7.
Veza, O., & Setyabudhi, A. L. (2022). Perancangan Pelatihan Algoritma Dasar dan Setup Access Point Untuk Siswa SMK/SMA. Jurnal Pengabdian Masyarakat Mandiri (JPMM), 1(01), 21-23.
Arifin, N. Y., & Veza, O. (2019). Dashboard sistem aplikasi pengelolaan obat. Engineering and Technology International Journal, 1(01), 59-65.
Arifin, N. Y., Saro, D., & Adam, R. (2020). Dashboard Monitoring Kinerja Aparatur Sipil Negara Pada Dinas Pengelolaan Pajak Provinsi Kepulauan Riau. Elkom: Jurnal Elektronika dan Komputer, 13(2), 70-86.
Setyabudhi, A. L. (2017). Perancangan Sistem Informasi Pengolahan Data Absensi dan Pengambilan Surat Cuti Kerja Berbasis Web. Jr: Jurnal Responsive Teknik Informatika, 1(01), 11-22.
Setyabudhi, A. L. (2017). Perancangan Sistem Informasi Pengolahan Data Absensi dan Pengambilan Surat Cuti Kerja Berbasis Web. Jr: Jurnal Responsive Teknik Informatika, 1(01), 11-22.
