lampstax Posted September 29, 2008 Share Posted September 29, 2008 Recently the MySQL server got a spike in traffic, and bogged down the entire site. The DBA guys at the colo was able to ran some test and determine that it was the `tags` that was causing the spikes. He helped us optimize and re-index some stuff and the problem seems to go away .. for now atleast. It might just be one of those things where its a matter of time before the problem resurface. My question is .. what command did he run to determine that it was the `tags` table that was causing the issue ? I ran `SHOW PROCESSLIST` and i saw no queries at that time hitting the `tags` table. We're not keeping a slow queries log .. so how would he determine this ? Just curious. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/126354-admin-stuff-on-mysql/ Share on other sites More sharing options...
Barand Posted September 29, 2008 Share Posted September 29, 2008 Have you considered asking "The DBA guys at the colo"? Quote Link to comment https://forums.phpfreaks.com/topic/126354-admin-stuff-on-mysql/#findComment-653477 Share on other sites More sharing options...
lampstax Posted September 29, 2008 Author Share Posted September 29, 2008 I asked the person I that was assigned to us but he didn't seem like he wanted to share his insider secrets or mysql black magic. Or maybe they just want to be paid for fixing the problem again when it arise later on. Who knows. Quote Link to comment https://forums.phpfreaks.com/topic/126354-admin-stuff-on-mysql/#findComment-653489 Share on other sites More sharing options...
Maq Posted September 30, 2008 Share Posted September 30, 2008 Do you keep any kind of history log? Quote Link to comment https://forums.phpfreaks.com/topic/126354-admin-stuff-on-mysql/#findComment-653519 Share on other sites More sharing options...
awpti Posted September 30, 2008 Share Posted September 30, 2008 A good DBA doesn't need logs to determine what is and is not going to run slowly. More than likely it was simple intuition. Quote Link to comment https://forums.phpfreaks.com/topic/126354-admin-stuff-on-mysql/#findComment-653590 Share on other sites More sharing options...
Maq Posted September 30, 2008 Share Posted September 30, 2008 A good DBA doesn't need logs to determine what is and is not going to run slowly. I agree but I wasn't referring to the DBA, I was referring to lampstax. Maybe he could look over the logs and find out what's going on. Quote Link to comment https://forums.phpfreaks.com/topic/126354-admin-stuff-on-mysql/#findComment-653769 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.