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, great that you have munin monitoring It would be great if you could update mysql to 5.6 or to Percona 5.6 Then we could increase table_open_cache and add table_open_cache_instances, couse in 5...
-
1. user1_seconde select barre_date = now(), argent = argent +2, tbpointbarreperiode = tbpointbarreperiode +2 from membres where email ='anonymous@free.fr' please check if you have idnex for emai...
-
you can post the first 5 slowest # Profile # Rank Query ID Response time Calls R/Call V/M Item # ==== ================== ================ ===== ======= ===== =========== # 1 0x...
-
"Cpu(s): 0.0%us, 0.6%sy, 2.0%ni, 12.4%id, 85.0%wa, 0.0%hi, 0.0%si, 0.0%st" That's your problem, high I/O usage, becouse of small MyISAM and Innodb buffers so instead of reading from RAM, ser...
-
add there in the end myisam_use_mmap=1 max_connections = 200 max_user_connections = 75 join_buffer_size=2M sort_buffer_size=256K table_open_cache = 8000 table_definition_cache = 6000 max_allowe...
-
No need to increase my.cnf values any more, it's good
-
database hiphop this query SELECT wp_posts.ID, post_title, post_name, post_date, COUNT(wp_comments.comment_post_ID) AS 'comment_total' FROM wp_posts LEFT JOIN wp_comments ON wp_posts.ID = wp_comm...
-
use sftp or scp to copy the file to PC, filezilla supports it
-
yep, now open /root/install/slow.txt and copy content here
-
you previosuly installed pt-query-digest in /root/install cou first cd /root/install then ./pt-query-digest /var/lib/mysql/mysql-slow.log > slow.txt