thinkbot
- Total activity 275
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 67
Comments
Recent activity by thinkbot-
ok the problem was safe-show-databas delete this line from my.cnf and then restart logfiles will be recreated, its ok after restart, run from command line mysqlcheck -A --auto-repair this will ch...
-
mysql generates logs, where it will write whats the problem, so please copy the content of /var/lib/mysql/*.err you can run it like this tail -n 100 /var/lib/mysql/*.err and copy here [COLOR="...
-
please copy the contents of mysql error file tail -n 100 /var/lib/mysql/*.err temporary remove this line myisam_use_mmap probably this variable is not supported in your mysql 5.1
-
Nope, since [!!] InnoDB data size / buffer pool: 882.1M/8.0M This means, there is at least 882 MB of innodb data that can be buffered in RAM memory to speed up the operations It's always a cost ...
-
yes, exactly
-
Your settings are horrible Set: [mysqld] skip-name-resolve myisam_use_mmap=1 max_connections=100 max_user_connections = 50 log-slow-queries=mysql-slow.log long_query_time = 0.1 safe-show-databa...
-
You have 32-bit Linux and system with 4GB RAM For 4GB you should use 64-bit system, [!!] Allocating > 2GB RAM on 32-bit systems can cause system instability [!!] Maximum possible memory usage: 2.7...
-
dont worry about fragmentation, it has almost no impact in your case you will have info about fragmented tables from mysqltuner most of the time when you run it, wherever you run it :) results ar...
-
Adjust those: table_cache = 1 - remove it net_buffer_length = 4096 - remove it add max_allowed_packet = 20M myisam_use_mmap=1 adjust: tmp_table_size = 50M max_heap_table_size = 50M thread_ca...
-
You should also copy "top" command result executed during spike to see which services takes the most cpu Please also post /etc/my.cnf contents and mysqltuner result of mysql Do you have apc or ea...