3
votes
3answers
2k views

NGINX + PHP-FPM + MYSQL - High CPU, Low RAM

All of a sudden our server started to act really weird, extremely high CPU usage and low RAM usage. I've never seen this before and I'm not sure what to do. I feel like if I could get the system to ...
11
votes
1answer
17k views

What value of thread_cache_size should I use?

I'm using Asp.Net together with MySQL. In the .Net connection string, I have set Max Pool Size to 150. If I run the following I get these values: SHOW GLOBAL STATUS LIKE 'max_used_connections'; ...
2
votes
1answer
938 views

MySQL com_select?

I'm looking to tune my query cache a bit. According to 7.6.3.4. Query Cache Status and Maintenance in the manual: The Com_select value is given by this formula: Qcache_inserts + ...
13
votes
3answers
28k views

MySQL lowering wait_timeout value to lower number of open connections

I run a rather busy site, and during peek hours I see over 10.000 open connections to my database server on my webserver when a run a netstat command. 99% of the connections are in the TIME_WAIT ...
3
votes
2answers
1k views

Picking the right innodb_buffer_pool_size

I have a 24GB machine running MySQL (only InnoDB tables). My innodb data set is 11.5GB big, and i have set my innodb_buffer_pool_size to 14GB to allow some growth. So the entire innodb data set is ...
1
vote
1answer
254 views

fine tuning of my.cnf for InnoDB tables fails with setting of: `innodb_log_file_size=256`

I read some fine tuning recommendations on the mysqlperfomanceblog and tryed to adapt them. I added to my.cnf: innodb_buffer_pool_size = 1000M innodb_log_file_size = 256M After ...
2
votes
2answers
128 views

MySQL query times for tuning are different every time

I am tuning SQL query time for my slow query but every time I get different times so I can't evaluate my optimize solution. For example, I run query select * from abc where abc.status in (x,y,z) and ...
1
vote
3answers
332 views

Config MySQL to maximum speed and memory

I have a server, 8 cores, 12 GB RAM. This server is only used to run MySQL. So, help me config /etc/my.cnf to maximum speed, memory for MySQL.
0
votes
1answer
452 views

Setting MySQL table_cache variable

Greetings, I've set the table_cache variable in /etc/mysql/my.cnf on Ubuntu to 512, but the reported value is only 64. How can I fix this? Thanks
6
votes
5answers
6k views

How to fine-tune our MySQL server?

MySQL is not my thing, yet I need to fine-tune one of our servers. Here are the requirements/specs: The MySQL server has only one significant database We only have one "type" of application ...