Score:0

MYSQL use too much disk (read / write)

us flag

I have big problem with my server. I am using Ubuntu linux version 22.04. The problem is in the write / read disk (light for the disk is all the time ON) when I have turn on apache (PHP) and MYSQL. Here is the picture (CPU process):

https://i.stack.imgur.com/kzv7h.jpg

My setting in mysqlc.cnf are

character-set-server = utf8mb4
collation-server = utf8mb4_slovenian_ci

user        = mysql
bind-address        = 127.0.0.1
mysqlx-bind-address = 127.0.0.1
key_buffer_size     = 44M
max_connections = 300
max_allowed_packet = 32M
myisam-recover-options  = BACKUP
log_error = /var/log/mysql/error.log
max_binlog_size   = 100M
Nikita Kipriyanov avatar
za flag
Assume "HDD led is always lit", so what? What's the problem with it? Why are you concerned?
Romeo Ninov avatar
in flag
The I/O is dosen kilobytes per second which is **VERY** small!
Jure avatar
us flag
Thenk you for the answer... But I don't understand whay if I have turn off the apache then the disk is quiet (nothing to write). When I turn apache ON the disk all the time write something, but I don't know what. Led indicator for the disk is ON alot. And when the LED is ON I have a problem to connect them (request time out). Computer is bussy...
Nikita Kipriyanov avatar
za flag
**This** is what you had to write into the question. Not the "HDD LED is on" but "after Apache start the request is timed out". Well, when you [update the question](https://serverfault.com/posts/1142908/edit) with that info, attach relevant Apache error log entries too. And, what's its configuration, at least, non-default parts (that you changed)?
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.