MySQL consume all my CPU |
Hi, I have a production website since two years ago.
Bachecubano.com is a classiffieds website with a new and a improved functionalities to bring more power to the Buy & Sell in Cuba and Miami. But in the last month I study some SEO thecniques that explode the visits to the website and then become the "Can't connect to the DB" error due to overloaded connections. ¿Hoy do I fix this? It seem to be a lot of users navigating the site. This is the config database: $db['mocha'] = array( 'dsn' => '', 'hostname' => 'localhost', 'username' => 'bache', 'password' => 'dtyjtyj', 'database' => 'bache6', 'dbdriver' => 'mysqli', 'dbprefix' => '', 'pconnect' => TRUE, 'db_debug' => TRUE, 'cache_on' => FALSE, 'cachedir' => APPPATH . 'cache', 'char_set' => 'utf8', 'dbcollat' => 'utf8_general_ci', 'swap_pre' => '', 'encrypt' => FALSE, 'compress' => FALSE, 'stricton' => FALSE, 'failover' => array(), 'save_queries' => FALSE ); What I doing wrong? I have a VPS with 4Gb RAM and 4 cores. Sometoimes in the project I made some Joins, but I cant believe that 100 concurrent users consume all this. This is the "top command in console" 31814 mysql 20 0 714m 201m 9124 S 49.5 9.6 248:10.89 mysqld 31814 mysql 20 0 714m 200m 9124 S 26.9 9.5 249:13.02 mysqld
PHP Developer. Codeigniter Fan. Family Lover.
The default connection limit is 151 (100 in early versions).
https://dev.mysql.com/doc/refman/5.5/en/...tions.html
Thanks!, the issue was related with a bad INDEX configuration in a deep query. Solved!
Thaks!
PHP Developer. Codeigniter Fan. Family Lover.
Im glad it was solved.
I had a similiar problem and the solution was to enable and then investigate the Slow Query Log. http://dev.mysql.com/doc/refman/5.7/en/s...y-log.html Obviously not a help here - but could possibly help someone else.
Yes, it helps. I still checking that file every two days. Thanks!
PHP Developer. Codeigniter Fan. Family Lover.
|
Welcome Guest, Not a member yet? Register Sign In |