Proceedings of the International Conference on Sustainable Green Tourism Applied Science - Engineering Applied Science 2025 (ICOSTAS-EAS 2025)

<Previous Article In Volume
Next Article In Volume>

Development of an IoT-Based Temperature and Humidity Monitoring System with MySQL Query Optimization for Efficient Data Storage and Access

Authors
Dewa Ayu Indah Cahya Dewi1, *, I Ketut Swardika1, Putri Alit Widyastuti Santiary1
1Electrical Engineering Department, Politeknik Negeri Bali, Bali, Indonesia
*Corresponding author. Email: ayuindahcahyadewi@pnb.ac.id
Corresponding Author
Dewa Ayu Indah Cahya Dewi
Available Online 31 October 2025.
DOI
10.2991/978-94-6463-878-3_6How to use a DOI?
Keywords
Indexing; Internet of Things (IoT); MySQL; Partitioning; Web
Abstract

Environmental monitoring systems are crucial in smart and sustainable infrastructure, particularly in industrial settings where temperature and humidity must be continuously monitored in real-time. This research presents the design and implementation of an Internet of Things (IoT)-based monitoring system that utilizes the ESP32 microcontroller paired with a DHT22 sensor to collect temperature and humidity data. The collected data are transmitted to a MySQL database server through the HTTP protocol and visualized on a responsive web-based dashboard. As the volume of sensor data grows over time, efficient data management becomes critical. To address performance issues such as slow query response and delayed dashboard loading, the system incorporates two key database optimization strategies: indexing and horizontal partitioning based on timestamps. These optimizations significantly enhance the speed of SQL query execution and reduce page load latency. The findings suggest that integrating IoT with structured database optimization offers a scalable and efficient solution for real-time environmental monitoring in smart industry applications.

Copyright
© 2025 The Author(s)
Open Access
Open Access This chapter is licensed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (http://creativecommons.org/licenses/by-nc/4.0/), which permits any noncommercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if changes were made.

Download article (PDF)

<Previous Article In Volume
Next Article In Volume>
Volume Title
Proceedings of the International Conference on Sustainable Green Tourism Applied Science - Engineering Applied Science 2025 (ICOSTAS-EAS 2025)
Series
Advances in Engineering Research
Publication Date
31 October 2025
ISBN
978-94-6463-878-3
ISSN
2352-5401
DOI
10.2991/978-94-6463-878-3_6How to use a DOI?
Copyright
© 2025 The Author(s)
Open Access
Open Access This chapter is licensed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (http://creativecommons.org/licenses/by-nc/4.0/), which permits any noncommercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if changes were made.

Cite this article

risenwbib
TY  - CONF
AU  - Dewa Ayu Indah Cahya Dewi
AU  - I Ketut Swardika
AU  - Putri Alit Widyastuti Santiary
PY  - 2025
DA  - 2025/10/31
TI  - Development of an IoT-Based Temperature and Humidity Monitoring System with MySQL Query Optimization for Efficient Data Storage and Access
BT  - Proceedings of the International Conference on Sustainable Green Tourism Applied Science - Engineering Applied Science 2025 (ICOSTAS-EAS 2025)
PB  - Atlantis Press
SP  - 39
EP  - 48
SN  - 2352-5401
UR  - https://doi.org/10.2991/978-94-6463-878-3_6
DO  - 10.2991/978-94-6463-878-3_6
ID  - Dewi2025
ER  -