MySQL going crazy! Help!

Portal Home > Knowledgebase > Articles Database > MySQL going crazy! Help!

Posted by digitalpioneer, 03-30-2009, 05:21 PM
For some reason my database usage goes up, up, up and then it crashes and restarts itself. It typically does not stay up longer than 15 minutes. The "question" count surpasses 1,000,00 by then, and the number of connections if up to 50,000 and average queries per second remains around 2,000. This just started happening when I switched to a bigger server. How can I correct this problem? Server Specs: OS: Debian 5.0 32bitQuad 2.66ghz Harpertown4GB RAM2x73GB SAS 15K /w RAID1 (hardware) Here is what mysqladmin -u root -p version says Here is part of my my.cnf file: And here is what MySQL Tuner spits out: Last edited by digitalpioneer; 03-30-2009 at 05:32 PM.
Posted by UNIXy, 03-30-2009, 05:49 PM
What do you mean by mysql restarts itself? Perhaps you mean another monitoring process restarts it when it finds out it crashed? I'm suspecting either a) one of the memory modules is bad so as soon as mysql hits it crashes b) you're running out of memory and swap and that OOM kills mysql since it's a beefy target. Do you have historical data of how the machine behaves? See this writeup: http://www.webhostingtalk.com/showthread.php?t=729846 Regards
Posted by digitalpioneer, 03-30-2009, 05:56 PM
By restarts I mean when I look at the uptime of MySQL, it's back to a low number, like 2-5 minutes... It never goes above 15minutes. Also, how do I test if the ram is good and working?
Posted by UNIXy, 03-30-2009, 06:03 PM
Have you checked the error log file? It's usually located in /var/lib/mysql/ and it takes the form of hostname.err where hostname is your server's hostname. One way to test memory is to run memtest86 for 32bit CPUs. It runs from a CD but the server has to be configured to boot off the CDROM. This is something your provider would have to do. Also, if you can post the output of the command dmesg along with the content of the above error log file. Regards
Posted by GOT, 03-30-2009, 06:17 PM
2000+ qps is a HUGE number. You probably have some kind of looping code problem. Also, make sure that mysql is firewalled and its not coming from an external source. You should install and run mytop to see what queries are getting run.
Posted by digitalpioneer, 03-30-2009, 07:15 PM
There is no *.err file in that directory, nor is there any error log file in /var/log/mysql/. I checked all of the contents of the files in /var/lib/mysql/ and there was no log of errors anywhere. Contents of dmesg: GOT, I am installing mytop and will let you know what I get. The MySQL is also secured.
Posted by UNIXy, 03-30-2009, 07:33 PM
Can you turn that on? This should give you all the slow queries. Does the folder /var/log/mysql exist and is writeable by the mysql user? Regards
Posted by digitalpioneer, 03-30-2009, 07:39 PM
I had it on, and it logged a few slow queries, which weren't the cause of the problem. I think the problem is a infinite loop like GOT stated. The number of queries executed grows like crazy. In 10 minutes it had executed over 2M queries. The site isn't nearly big enough to do this. How do I check for infinite loops, especially queries to pin-point its source?
Posted by GOT, 03-30-2009, 07:50 PM
Running mytop will show you in real-time the quesries being run and on what database. Beyond identifying the database, you'd need to talk with a coder to work on the code issues. mytop: http://jeremy.zawodny.com/mysql/mytop/
Posted by digitalpioneer, 03-30-2009, 07:55 PM
I have enabled MySQL logging for 3 seconds, and this is what it logged: [CODE] /usr/sbin/mysqld, Version: 5.0.51a-24-log ((Debian)). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 090330 18:43:05 1 Connect mh_db1@localhost on 1 Init DB mh_db1 1 Init DB mh_db1 1 Query select `key`,data from `datacache` 1 Init DB mh_db1 1 Query select tag,replacement,paramcount from bbcode 1 Init DB mh_db1 1 Query select * from smilie order by representation desc 1 Init DB mh_db1 1 Init DB mh_db1 1 Init DB mh_db1 1 Init DB mh_db1 1 Init DB mh_db1 1 Init DB mh_db1 1 Init DB mh_db1 1 Query select last_seen_loc from session where ipaddress = '78.94.164.54' limit 1 1 Init DB mh_db1 1 Query select id,templatelist from style where id in(-1,-1) order by id desc 1 Init DB mh_db1 1 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 2 Connect mh_db1@localhost on 2 Init DB mh_db1 2 Init DB mh_db1 2 Query select `key`,data from `datacache` 2 Init DB mh_db1 2 Query select tag,replacement,paramcount from bbcode 2 Init DB mh_db1 2 Query select * from smilie order by representation desc 2 Init DB mh_db1 2 Init DB mh_db1 2 Init DB mh_db1 2 Init DB mh_db1 2 Init DB mh_db1 2 Init DB mh_db1 2 Query select last_seen_loc from session where ipaddress = '76.171.71.215' limit 1 2 Init DB mh_db1 1 Init DB mh_db1 2 Query select id,templatelist from style where id in(-1,-1) order by id desc 1 Init DB mh_db1 1 Init DB mh_db1 2 Init DB mh_db1 2 Query select templatename,template from template where id in (1,2,3,58,167,218) 1 Init DB mh_db1 1 Init DB mh_db1 1 Init DB mh_db1 1 Init DB mh_db1 2 Init DB mh_db1 1 Init DB mh_db1 2 Init DB mh_db1 1 Init DB mh_db1 2 Init DB mh_db1 1 Init DB mh_db1 2 Init DB mh_db1 2 Init DB mh_db1 2 Init DB mh_db1 1 Init DB mh_db1 1 Init DB mh_db1 1 Init DB mh_db1 1 Init DB mh_db1 1 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238154492' limit 1 2 Quit 1 Init DB mh_db1 1 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238154893' limit 1 3 Connect mh_db1@localhost on 3 Init DB mh_db1 3 Init DB mh_db1 3 Query select `key`,data from `datacache` 1 Init DB mh_db1 3 Init DB mh_db1 3 Query select tag,replacement,paramcount from bbcode 1 Init DB mh_db1 1 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('78.94.164.54','81584f1d0668784154df10e182ac1f64','0','0','1238456585','mga_VIEWER/,select/,Petit Roid 3/013') 3 Init DB mh_db1 3 Query select * from smilie order by representation desc 3 Init DB mh_db1 3 Init DB mh_db1 3 Init DB mh_db1 3 Init DB mh_db1 3 Init DB mh_db1 3 Init DB mh_db1 3 Query select last_seen_loc from session where ipaddress = '64.128.139.82' limit 1 4 Connect mh_db1@localhost on 3 Init DB mh_db1 4 Init DB mh_db1 3 Query select id,templatelist from style where id in(-1,-1) order by id desc 3 Init DB mh_db1 3 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 3 Init DB mh_db1 3 Init DB mh_db1 3 Init DB mh_db1 4 Init DB mh_db1 4 Query select `key`,data from `datacache` 3 Init DB mh_db1 3 Init DB mh_db1 3 Init DB mh_db1 3 Init DB mh_db1 3 Init DB mh_db1 3 Init DB mh_db1 3 Init DB mh_db1 4 Init DB mh_db1 4 Query select tag,replacement,paramcount from bbcode 4 Init DB mh_db1 4 Query select * from smilie order by representation desc 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 3 Init DB mh_db1 4 Init DB mh_db1 3 Init DB mh_db1 4 Query select last_seen_loc from session where ipaddress = '24.79.101.10' limit 1 3 Init DB mh_db1 4 Init DB mh_db1 4 Query select id,templatelist from style where id in(-1,-1) order by id desc 3 Init DB mh_db1 3 Query select genre from mga_genre where seriesid = '1236433944' 4 Init DB mh_db1 4 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 3 Init DB mh_db1 3 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1236433944' limit 1 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 3 Init DB mh_db1 3 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1236433946' limit 1 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 4 Init DB mh_db1 4 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1215295854' limit 1 1 Quit 4 Init DB mh_db1 4 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1215296162' limit 1 3 Init DB mh_db1 3 Init DB mh_db1 3 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('64.128.139.82','6ee674996a7dd7e003cc6bf60e32c9be','0','0','1238456585','mga_VIEWER/,select/,Tonari no Minano Sensei/000') 4 Init DB mh_db1 4 Init DB mh_db1 4 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('24.79.101.10','0a27c306ed61070f755467747d9fb74f','0','0','1238456585','mga_VIEWER/,select/,Berserk/Two/249') 5 Connect mh_db1@localhost on 6 Connect mh_db1@localhost on 6 Init DB mh_db1 5 Init DB mh_db1 5 Init DB mh_db1 6 Init DB mh_db1 5 Query select `key`,data from `datacache` 6 Query select `key`,data from `datacache` 3 Quit 5 Init DB mh_db1 5 Query select tag,replacement,paramcount from bbcode 5 Init DB mh_db1 5 Query select * from smilie order by representation desc 6 Init DB mh_db1 6 Query select tag,replacement,paramcount from bbcode 6 Init DB mh_db1 5 Init DB mh_db1 6 Query select * from smilie order by representation desc 5 Init DB mh_db1 5 Init DB mh_db1 5 Init DB mh_db1 5 Init DB mh_db1 5 Init DB mh_db1 6 Init DB mh_db1 6 Init DB mh_db1 5 Init DB mh_db1 6 Init DB mh_db1 5 Query select last_seen_loc from session where ipaddress = '142.179.21.69' limit 1 6 Init DB mh_db1 6 Init DB mh_db1 6 Init DB mh_db1 5 Init DB mh_db1 5 Query select id,templatelist from style where id in(-1,-1) order by id desc 6 Init DB mh_db1 6 Query select last_seen_loc from session where ipaddress = '71.246.104.126' limit 1 5 Init DB mh_db1 5 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 5 Init DB mh_db1 6 Init DB mh_db1 6 Query select id,templatelist from style where id in(-1,-1) order by id desc 5 Init DB mh_db1 5 Init DB mh_db1 6 Init DB mh_db1 6 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 5 Init DB mh_db1 5 Init DB mh_db1 6 Init DB mh_db1 5 Init DB mh_db1 6 Init DB mh_db1 5 Init DB mh_db1 6 Init DB mh_db1 5 Init DB mh_db1 6 Init DB mh_db1 5 Init DB mh_db1 6 Init DB mh_db1 5 Init DB mh_db1 6 Init DB mh_db1 6 Init DB mh_db1 6 Init DB mh_db1 6 Init DB mh_db1 6 Init DB mh_db1 5 Init DB mh_db1 5 Init DB mh_db1 5 Init DB mh_db1 4 Quit 6 Init DB mh_db1 6 Init DB mh_db1 6 Init DB mh_db1 5 Init DB mh_db1 5 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1190265606' limit 1 6 Init DB mh_db1 6 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238152598' limit 1 5 Init DB mh_db1 5 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1212387254' limit 1 6 Init DB mh_db1 6 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238152774' limit 1 5 Init DB mh_db1 5 Init DB mh_db1 5 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('142.179.21.69','75013dc4ebebd53c387919aeb1375633','0','0','1238456585','mga_VIEWER/,select/,Tenjo Tenge/074') 6 Init DB mh_db1 6 Init DB mh_db1 6 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('71.246.104.126','ce3b1af5e2db17045959a64d8f006f1b','0','0','1238456585','mga_VIEWER/,select/,Seka x Seka/006') 5 Quit 7 Connect mh_db1@localhost on 7 Init DB mh_db1 7 Init DB mh_db1 7 Query select `key`,data from `datacache` 7 Init DB mh_db1 7 Query select tag,replacement,paramcount from bbcode 7 Init DB mh_db1 7 Query select * from smilie order by representation desc 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Query select last_seen_loc from session where ipaddress = '72.51.234.100' limit 1 7 Init DB mh_db1 7 Query select id,templatelist from style where id in(-1,-1) order by id desc 7 Init DB mh_db1 7 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Init DB mh_db1 7 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238074236' limit 1 7 Init DB mh_db1 7 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238074331' limit 1 7 Init DB mh_db1 7 Init DB mh_db1 7 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('72.51.234.100','f614f226ef3282dea770c5cf16922b46','0','0','1238456585','mga_VIEWER/,select/,School Girl/005') 8 Connect mh_db1@localhost on 8 Init DB mh_db1 8 Init DB mh_db1 8 Query select `key`,data from `datacache` 8 Init DB mh_db1 8 Query select tag,replacement,paramcount from bbcode 8 Init DB mh_db1 8 Query select * from smilie order by representation desc 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Query select last_seen_loc from session where ipaddress = '96.255.191.70' limit 1 8 Init DB mh_db1 8 Query select id,templatelist from style where id in(-1,-1) order by id desc 8 Init DB mh_db1 8 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Init DB mh_db1 8 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238152598' limit 1 8 Init DB mh_db1 8 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238152757' limit 1 7 Quit 8 Init DB mh_db1 8 Init DB mh_db1 8 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('96.255.191.70','9ae8a5f2ac806d6321b6e528f51fc741','0','0','1238456585','mga_VIEWER/,select/,Seka x Seka/001') 8 Quit 9 Connect mh_db1@localhost on 9 Init DB mh_db1 9 Init DB mh_db1 9 Query select `key`,data from `datacache` 9 Init DB mh_db1 9 Query select tag,replacement,paramcount from bbcode 9 Init DB mh_db1 9 Query select * from smilie order by representation desc 9 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 9 Query select last_seen_loc from session where ipaddress = '69.138.6.72' limit 1 9 Init DB mh_db1 9 Query select id,templatelist from style where id in(-1,-1) order by id desc 10 Connect mh_db1@localhost on 9 Init DB mh_db1 10 Init DB mh_db1 9 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 9 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 10 Init DB mh_db1 9 Init DB mh_db1 10 Query select `key`,data from `datacache` 9 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 10 Init DB mh_db1 10 Query select tag,replacement,paramcount from bbcode 10 Init DB mh_db1 10 Query select * from smilie order by representation desc 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 9 Init DB mh_db1 9 Init DB mh_db1 10 Init DB mh_db1 9 Init DB mh_db1 10 Init DB mh_db1 10 Query select last_seen_loc from session where ipaddress = '99.236.129.144' limit 1 10 Init DB mh_db1 10 Query select id,templatelist from style where id in(-1,-1) order by id desc 10 Init DB mh_db1 10 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 10 Init DB mh_db1 9 Init DB mh_db1 9 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1215303522' limit 1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 9 Init DB mh_db1 9 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1215303549' limit 1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 10 Init DB mh_db1 10 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1190260871' limit 1 10 Init DB mh_db1 10 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1212370135' limit 1 9 Init DB mh_db1 9 Init DB mh_db1 9 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('69.138.6.72','093e1fd1b64f3ed9c25e449309bb8325','0','0','1238456585','mga_VIEWER/,select/,Until Death Do Us Part/013') 11 Connect mh_db1@localhost on 11 Init DB mh_db1 11 Init DB mh_db1 11 Query select `key`,data from `datacache` 11 Init DB mh_db1 11 Query select tag,replacement,paramcount from bbcode 11 Init DB mh_db1 11 Query select * from smilie order by representation desc 11 Init DB mh_db1 10 Init DB mh_db1 11 Init DB mh_db1 10 Init DB mh_db1 11 Init DB mh_db1 10 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('99.236.129.144','72e60df1bd3209002584984e7201e8fa','0','0','1238456585','mga_VIEWER/,select/,666 Satan/074') 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Query select last_seen_loc from session where ipaddress = '72.207.102.183' limit 1 11 Init DB mh_db1 11 Query select id,templatelist from style where id in(-1,-1) order by id desc 11 Init DB mh_db1 11 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Init DB mh_db1 11 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1232552370' limit 1 11 Init DB mh_db1 11 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1232553379' limit 1 9 Quit 11 Init DB mh_db1 11 Init DB mh_db1 11 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('72.207.102.183','e5c918bda7cf5c462a889888627301d8','0','0','1238456585','mga_VIEWER/,select/,Take on Me/003') 10 Quit 11 Quit 12 Connect mh_db1@localhost on 12 Init DB mh_db1 13 Connect mh_db1@localhost on 13 Init DB mh_db1 12 Init DB mh_db1 12 Query select `key`,data from `datacache` 13 Init DB mh_db1 13 Query select `key`,data from `datacache` 12 Init DB mh_db1 12 Query select tag,replacement,paramcount from bbcode 12 Init DB mh_db1 12 Query select * from smilie order by representation desc 12 Init DB mh_db1 12 Init DB mh_db1 13 Init DB mh_db1 12 Init DB mh_db1 13 Query select tag,replacement,paramcount from bbcode 12 Init DB mh_db1 12 Init DB mh_db1 13 Init DB mh_db1 13 Query select * from smilie order by representation desc 12 Init DB mh_db1 12 Init DB mh_db1 12 Query select last_seen_loc from session where ipaddress = '86.153.92.231' limit 1 13 Init DB mh_db1 13 Init DB mh_db1 12 Init DB mh_db1 13 Init DB mh_db1 12 Query select id,templatelist from style where id in(-1,-1) order by id desc 13 Init DB mh_db1 13 Init DB mh_db1 12 Init DB mh_db1 12 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 13 Init DB mh_db1 12 Init DB mh_db1 13 Init DB mh_db1 12 Init DB mh_db1 13 Query select last_seen_loc from session where ipaddress = '79.47.4.27' limit 1 12 Init DB mh_db1 12 Init DB mh_db1 13 Init DB mh_db1 13 Query select id,templatelist from style where id in(-1,-1) order by id desc 12 Init DB mh_db1 12 Init DB mh_db1 12 Init DB mh_db1 13 Init DB mh_db1 13 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 12 Init DB mh_db1 13 Init DB mh_db1 12 Init DB mh_db1 13 Init DB mh_db1 12 Init DB mh_db1 13 Init DB mh_db1 13 Init DB mh_db1 13 Init DB mh_db1 13 Init DB mh_db1 13 Init DB mh_db1 13 Init DB mh_db1 13 Init DB mh_db1 13 Init DB mh_db1 12 Init DB mh_db1 12 Init DB mh_db1 12 Init DB mh_db1 13 Init DB mh_db1 13 Init DB mh_db1 13 Init DB mh_db1 12 Init DB mh_db1 12 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238074236' limit 1 12 Init DB mh_db1 12 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238074312' limit 1 13 Init DB mh_db1 13 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238154492' limit 1 13 Init DB mh_db1 13 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238154583' limit 1 12 Init DB mh_db1 12 Init DB mh_db1 12 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('86.153.92.231','a9b9d9191489c71966189c01822005bb','0','0','1238456585','mga_VIEWER/,select/,School Girl/002') 13 Init DB mh_db1 13 Init DB mh_db1 13 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('79.47.4.27','0a86a577f18d4d0cd8bbf96e0c4ed35e','0','0','1238456585','mga_VIEWER/,select/,Petit Roid 3/007') 12 Quit 13 Quit 14 Connect mh_db1@localhost on 14 Init DB mh_db1 14 Init DB mh_db1 14 Query select `key`,data from `datacache` 14 Init DB mh_db1 14 Query select tag,replacement,paramcount from bbcode 14 Init DB mh_db1 14 Query select * from smilie order by representation desc 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Query select x.userid,x.password,x.usergroupid,x.username,x.email,x.lastactivity as last_seen, x.pmunread as pms,y.width as ava_w,y.height as ava_h,y.dateline from f_user as x left join f_customavatar as y on(x.userid = y.userid) where x.userid = '11503' limit 1 14 Init DB mh_db1 14 Query select last_seen_loc from session where ipaddress = '77.45.17.123' limit 1 14 Init DB mh_db1 14 Query select id,templatelist from style where id in(-1,-1) order by id desc 14 Init DB mh_db1 14 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Init DB mh_db1 14 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238154492' limit 1 14 Init DB mh_db1 14 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238154516' limit 1 15 Connect mh_db1@localhost on 15 Init DB mh_db1 15 Init DB mh_db1 15 Query select `key`,data from `datacache` 15 Init DB mh_db1 15 Query select tag,replacement,paramcount from bbcode 15 Init DB mh_db1 15 Query select * from smilie order by representation desc 14 Init DB mh_db1 15 Init DB mh_db1 14 Init DB mh_db1 15 Init DB mh_db1 14 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('77.45.17.123','6605d0aa9c25f14a3c5a337ce13a08c1','1','11503','1238456585','mga_VIEWER/,select/,Petit Roid 3/001') 15 Init DB mh_db1 15 Init DB mh_db1 14 Init DB mh_db1 15 Init DB mh_db1 14 Query update f_user set lastactivity = '1238456585' where userid = '11503' limit 1 15 Init DB mh_db1 15 Init DB mh_db1 15 Query select last_seen_loc from session where ipaddress = '190.139.59.21' limit 1 15 Init DB mh_db1 15 Query select id,templatelist from style where id in(-1,-1) order by id desc 15 Init DB mh_db1 15 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Init DB mh_db1 15 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1190269876' limit 1 15 Init DB mh_db1 15 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1212374822' limit 1 15 Init DB mh_db1 15 Init DB mh_db1 15 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('190.139.59.21','f6a76716abedb608cda6e240cb7ddd52','0','0','1238456585','mga_VIEWER/,select/,Break Shot/010') 15 Quit 16 Connect mh_db1@localhost on 16 Init DB mh_db1 16 Init DB mh_db1 16 Query select `key`,data from `datacache` 16 Init DB mh_db1 16 Query select tag,replacement,paramcount from bbcode 16 Init DB mh_db1 16 Query select * from smilie order by representation desc 16 Init DB mh_db1 16 Init DB mh_db1 16 Init DB mh_db1 16 Init DB mh_db1 16 Init DB mh_db1 17 Connect mh_db1@localhost on 17 Init DB mh_db1 16 Init DB mh_db1 16 Init DB mh_db1 16 Query select last_seen_loc from session where ipaddress = '24.19.0.54' limit 1 16 Init DB mh_db1 16 Query select id,templatelist from style where id in(-1,-1) order by id desc 17 Init DB mh_db1 17 Query select `key`,data from `datacache` 16 Init DB mh_db1 16 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 16 Init DB mh_db1 16 Init DB mh_db1 16 Init DB mh_db1 16 Init DB mh_db1 16 Init DB mh_db1 17 Init DB mh_db1 17 Query select tag,replacement,paramcount from bbcode 16 Init DB mh_db1 16 Init DB mh_db1 16 Init DB mh_db1 17 Init DB mh_db1 17 Query select * from smilie order by representation desc 16 Init DB mh_db1 16 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Query select last_seen_loc from session where ipaddress = '98.224.229.253' limit 1 17 Init DB mh_db1 17 Query select id,templatelist from style where id in(-1,-1) order by id desc 16 Init DB mh_db1 16 Init DB mh_db1 16 Init DB mh_db1 17 Init DB mh_db1 17 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 16 Init DB mh_db1 17 Init DB mh_db1 16 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238152598' limit 1 17 Init DB mh_db1 16 Init DB mh_db1 16 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238152733' limit 1 17 Init DB mh_db1 18 Connect mh_db1@localhost on 17 Init DB mh_db1 18 Init DB mh_db1 17 Init DB mh_db1 18 Init DB mh_db1 18 Query select `key`,data from `datacache` 17 Init DB mh_db1 17 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1190262993' limit 1 18 Init DB mh_db1 18 Query select tag,replacement,paramcount from bbcode 16 Init DB mh_db1 17 Init DB mh_db1 17 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1215285590' limit 1 16 Init DB mh_db1 16 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('24.19.0.54','b87c9a70a753526adede334a7fdb6330','0','0','1238456585','mga_VIEWER/,select/,Seka x Seka/007') 18 Init DB mh_db1 18 Query select * from smilie order by representation desc 18 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 18 Query select last_seen_loc from session where ipaddress = '68.149.253.137' limit 1 18 Init DB mh_db1 18 Query select id,templatelist from style where id in(-1,-1) order by id desc 18 Init DB mh_db1 18 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 18 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 17 Init DB mh_db1 17 Init DB mh_db1 18 Init DB mh_db1 17 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('98.224.229.253','1667c878e7fa2d83e3b0f78cdfd90ccb','0','0','1238456585','mga_VIEWER/,select/,Eyeshield 21/235') 19 Connect mh_db1@localhost on 18 Init DB mh_db1 19 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 19 Init DB mh_db1 19 Query select `key`,data from `datacache` 19 Init DB mh_db1 19 Query select tag,replacement,paramcount from bbcode 19 Init DB mh_db1 19 Query select * from smilie order by representation desc 18 Init DB mh_db1 18 Init DB mh_db1 18 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 18 Init DB mh_db1 18 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1232905031' limit 1 19 Init DB mh_db1 19 Query select last_seen_loc from session where ipaddress = '66.78.113.169' limit 1 19 Init DB mh_db1 19 Query select id,templatelist from style where id in(-1,-1) order by id desc 18 Init DB mh_db1 19 Init DB mh_db1 18 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1232926239' limit 1 19 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 16 Quit 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Init DB mh_db1 19 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1232552370' limit 1 18 Init DB mh_db1 18 Init DB mh_db1 18 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('68.149.253.137','4c927fdf054b763d676e176e671ede63','0','0','1238456585','mga_VIEWER/,select/,Love Selection/008') 19 Init DB mh_db1 19 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1232553379' limit 1 17 Quit 19 Init DB mh_db1 19 Init DB mh_db1 19 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('66.78.113.169','8d57f08a5faad9a5a894b97cc3bf046c','0','0','1238456585','mga_VIEWER/,select/,Take on Me/003') 18 Quit 19 Quit 20 Connect mh_db1@localhost on 20 Init DB mh_db1 20 Init DB mh_db1 20 Query select `key`,data from `datacache` 20 Init DB mh_db1 20 Query select tag,replacement,paramcount from bbcode 20 Init DB mh_db1 20 Query select * from smilie order by representation desc 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Query select last_seen_loc from session where ipaddress = '66.209.105.226' limit 1 20 Init DB mh_db1 20 Query select id,templatelist from style where id in(-1,-1) order by id desc 20 Init DB mh_db1 20 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 21 Connect mh_db1@localhost on 21 Init DB mh_db1 20 Init DB mh_db1 20 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238059596' limit 1 21 Init DB mh_db1 21 Query select `key`,data from `datacache` 20 Init DB mh_db1 20 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238059651' limit 1 21 Init DB mh_db1 21 Query select tag,replacement,paramcount from bbcode 21 Init DB mh_db1 21 Query select * from smilie order by representation desc 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Query select last_seen_loc from session where ipaddress = '72.19.86.29' limit 1 21 Init DB mh_db1 21 Query select id,templatelist from style where id in(-1,-1) order by id desc 21 Init DB mh_db1 21 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 20 Init DB mh_db1 20 Init DB mh_db1 20 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('66.209.105.226','94e9e6b3072997f506ab7ceaa1b0d6dd','0','0','1238456585','mga_VIEWER/,select/,Half Cocked/003') 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Init DB mh_db1 21 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1190271984' limit 1 21 Init DB mh_db1 21 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1232734967' limit 1 21 Init DB mh_db1 21 Init DB mh_db1 21 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('72.19.86.29','681bdf2cd5463379b5f8de629d69d69f','0','0','1238456585','mga_VIEWER/,select/,Futari Ecchi/094') 20 Quit 22 Connect mh_db1@localhost on 22 Init DB mh_db1 22 Init DB mh_db1 22 Query select `key`,data from `datacache` 22 Init DB mh_db1 22 Query select tag,replacement,paramcount from bbcode 22 Init DB mh_db1 22 Query select * from smilie order by representation desc 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Query select x.userid,x.password,x.usergroupid,x.username,x.email,x.lastactivity as last_seen, x.pmunread as pms,y.width as ava_w,y.height as ava_h,y.dateline from f_user as x left join f_customavatar as y on(x.userid = y.userid) where x.userid = '13045' limit 1 22 Init DB mh_db1 22 Query select last_seen_loc from session where ipaddress = '84.97.193.169' limit 1 22 Init DB mh_db1 22 Query select id,templatelist from style where id in(-1,-1) order by id desc 22 Init DB mh_db1 22 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 21 Quit 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Init DB mh_db1 22 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1190263180' limit 1 22 Init DB mh_db1 22 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1212379163' limit 1 22 Init DB mh_db1 22 Init DB mh_db1 22 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('84.97.193.169','a3c93e00e6110241451ff14ea2e0fdb6','1','13045','1238456585','mga_VIEWER/,select/,Gantz/213') 22 Init DB mh_db1 22 Query update f_user set lastactivity = '1238456585' where userid = '13045' limit 1 22 Quit 23 Connect mh_db1@localhost on 23 Init DB mh_db1 23 Init DB mh_db1 23 Query select `key`,data from `datacache` 23 Init DB mh_db1 23 Query select tag,replacement,paramcount from bbcode 23 Init DB mh_db1 23 Query select * from smilie order by representation desc 24 Connect mh_db1@localhost on 24 Init DB mh_db1 23 Init DB mh_db1 23 Init DB mh_db1 23 Init DB mh_db1 23 Init DB mh_db1 23 Init DB mh_db1 23 Init DB mh_db1 23 Init DB mh_db1 24 Init DB mh_db1 23 Query select last_seen_loc from session where ipaddress = '70.178.24.38' limit 1 24 Query select `key`,data from `datacache` 23 Init DB mh_db1 23 Query select id,templatelist from style where id in(-1,-1) order by id desc 23 Init DB mh_db1 23 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 24 Init DB mh_db1 24 Query select tag,replacement,paramcount from bbcode 23 Init DB mh_db1 23 Init DB mh_db1 23 Init DB mh_db1 24 Init DB mh_db1 24 Query select * from smilie order by representation desc 23 Init DB mh_db1 23 Init DB mh_db1 23 Init DB mh_db1 23 Init DB mh_db1 23 Init DB mh_db1 24 Init DB mh_db1 23 Init DB mh_db1 24 Init DB mh_db1 23 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Query select userid,host from f_session where sessionhash = 'f72f71c5aa5c6c0315ee07dc3ad710a8' limit 1 24 Init DB mh_db1 24 Query select last_seen_loc from session where ipaddress = '71.191.200.196' limit 1 24 Init DB mh_db1 24 Query select id,templatelist from style where id in(-1,-1) order by id desc 24 Init DB mh_db1 24 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 23 Init DB mh_db1 23 Init DB mh_db1 24 Init DB mh_db1 23 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 23 Init DB mh_db1 24 Init DB mh_db1 23 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238154492' limit 1 23 Init DB mh_db1 23 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238154551' limit 1 24 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 25 Connect mh_db1@localhost on 25 Init DB mh_db1 24 Init DB mh_db1 25 Init DB mh_db1 24 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1215285775' limit 1 25 Query select `key`,data from `datacache` 24 Init DB mh_db1 24 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1215285841' limit 1 25 Init DB mh_db1 25 Query select tag,replacement,paramcount from bbcode 25 Init DB mh_db1 25 Query select * from smilie order by representation desc 25 Init DB mh_db1 23 Init DB mh_db1 25 Init DB mh_db1 23 Init DB mh_db1 25 Init DB mh_db1 23 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('70.178.24.38','e4365e417f66a49703642cb32e6c19e9','0','0','1238456585','mga_VIEWER/,select/,Petit Roid 3/003') 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Query select last_seen_loc from session where ipaddress = '189.230.43.128' limit 1 25 Init DB mh_db1 25 Query select id,templatelist from style where id in(-1,-1) order by id desc 25 Init DB mh_db1 25 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 24 Init DB mh_db1 24 Init DB mh_db1 24 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('71.191.200.196','a042ee39bca6897034c6c1143f4ff232','0','0','1238456585','mga_VIEWER/,select/,Sekirei/066') 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Init DB mh_db1 25 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1190272051' limit 1 25 Init DB mh_db1 25 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1215292126' limit 1 23 Quit 25 Init DB mh_db1 25 Init DB mh_db1 25 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('189.230.43.128','6ba2c51e19bf6a077bcfcb24ae520ece','0','0','1238456585','mga_VIEWER/,select/,GTO/123') 24 Quit 26 Connect mh_db1@localhost on 26 Init DB mh_db1 26 Init DB mh_db1 26 Query select `key`,data from `datacache` 26 Init DB mh_db1 26 Query select tag,replacement,paramcount from bbcode 26 Init DB mh_db1 26 Query select * from smilie order by representation desc 26 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 25 Quit 26 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 26 Query select last_seen_loc from session where ipaddress = '173.68.178.36' limit 1 26 Init DB mh_db1 26 Query select id,templatelist from style where id in(-1,-1) order by id desc 26 Init DB mh_db1 26 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 26 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 27 Connect mh_db1@localhost on 26 Init DB mh_db1 27 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 27 Init DB mh_db1 27 Query select `key`,data from `datacache` 26 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 26 Init DB mh_db1 26 Query select * from mga_category where representation = 'Arigatou/002' and blacklisted = 0 limit 1 27 Init DB mh_db1 27 Query select tag,replacement,paramcount from bbcode 26 Init DB mh_db1 26 Query select body from mga_scanlator where seriesid = '1212372155' limit 1 28 Connect mh_db1@localhost on 28 Init DB mh_db1 27 Init DB mh_db1 27 Query select * from smilie order by representation desc 27 Init DB mh_db1 28 Init DB mh_db1 27 Init DB mh_db1 28 Init DB mh_db1 27 Init DB mh_db1 28 Init DB mh_db1 27 Init DB mh_db1 26 Init DB mh_db1 28 Init DB mh_db1 26 Query select id,representation from mga_category where parent = '1190267629' and blacklisted = 0 order by representation asc 28 Init DB mh_db1 28 Init DB mh_db1 28 Init DB mh_db1 28 Query select last_seen_loc from session where ipaddress = '76.171.71.215' limit 1 28 Init DB mh_db1 28 Init DB mh_db1 28 Query select * from poll where active = '1' order by rand() limit 1 27 Init DB mh_db1 28 Init DB mh_db1 28 Query SELECT option_voted_for, user FROM `poll_vote` WHERE poll = '19' LIMIT 7724 27 Init DB mh_db1 27 Init DB mh_db1 27 Query select last_seen_loc from session where ipaddress = '94.29.36.117' limit 1 26 Init DB mh_db1 26 Query select id,representation,type,chaptitle from mga_category where parent = '1212372155' and blacklisted = 0 order by representation desc 27 Init DB mh_db1 27 Query select id,templatelist from style where id in(-1,-1) order by id desc 27 Init DB mh_db1 26 Init DB mh_db1 27 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 26 Query select id,file_name from mga_scan where parent = '1212372155' order by file_name asc 27 Init DB mh_db1 27 Init DB mh_db1 27 Init DB mh_db1 27 Init DB mh_db1 27 Init DB mh_db1 27 Init DB mh_db1 27 Init DB mh_db1 27 Init DB mh_db1 27 Init DB mh_db1 27 Init DB mh_db1 29 Connect mh_db1@localhost on 29 Init DB mh_db1 29 Init DB mh_db1 29 Query select `key`,data from `datacache` 27 Init DB mh_db1 27 Init DB mh_db1 27 Init DB mh_db1 29 Init DB mh_db1 29 Query select tag,replacement,paramcount from bbcode 29 Init DB mh_db1 29 Query select * from smilie order by representation desc 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Query select last_seen_loc from session where ipaddress = '207.112.4.67' limit 1 27 Init DB mh_db1 27 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238069703' limit 1 30 Connect mh_db1@localhost on 29 Init DB mh_db1 30 Init DB mh_db1 29 Query select id,templatelist from style where id in(-1,-1) order by id desc 29 Init DB mh_db1 26 Init DB mh_db1 29 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 26 Query select url from server where id = '5' limit 1 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 30 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 30 Query select `key`,data from `datacache` 26 Init DB mh_db1 26 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1190267629' limit 1 30 Init DB mh_db1 30 Query select tag,replacement,paramcount from bbcode 30 Init DB mh_db1 29 Init DB mh_db1 30 Query select * from smilie order by representation desc 29 Init DB mh_db1 29 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 29 Init DB mh_db1 29 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1190266830' limit 1 30 Init DB mh_db1 30 Query select last_seen_loc from session where ipaddress = '99.8.87.229' limit 1 29 Init DB mh_db1 29 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1212370761' limit 1 30 Init DB mh_db1 30 Query select id,templatelist from style where id in(-1,-1) order by id desc 30 Init DB mh_db1 30 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 30 Init DB mh_db1 27 Init DB mh_db1 30 Init DB mh_db1 26 Init DB mh_db1 26 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1212372155' limit 1 30 Init DB mh_db1 30 Init DB mh_db1 29 Init DB mh_db1 29 Init DB mh_db1 29 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('207.112.4.67','320b21b8afa363f574090001fcdd777e','0','0','1238456585','mga_VIEWER/,select/,Ai Yori Aoshi/008') 30 Init DB mh_db1 30 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238059596' limit 1 31 Connect mh_db1@localhost on 31 Init DB mh_db1 27 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238069720' limit 1 30 Init DB mh_db1 30 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238059652' limit 1 31 Init DB mh_db1 31 Query select `key`,data from `datacache` 26 Init DB mh_db1 26 Init DB mh_db1 26 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('173.68.178.36','e32d0af159773e1ee5eacf18c93ab5ae','0','0','1238456585','mga_VIEWER/,select/,Arigatou/002') 30 Init DB mh_db1 30 Init DB mh_db1 27 Init DB mh_db1 30 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('99.8.87.229','89cfbee0794e2c3629cd6b2d7246c4f8','0','0','1238456585','mga_VIEWER/,select/,Half Cocked/004') 27 Init DB mh_db1 27 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('94.29.36.117','c004239b9e6b2df85804c54014c1cb34','0','0','1238456585','mga_VIEWER/,select/,Heat: Ring of Destiny/002') 29 Quit 26 Quit 32 Connect mh_db1@localhost on 32 Init DB mh_db1 32 Init DB mh_db1 32 Query select `key`,data from `datacache` 32 Init DB mh_db1 32 Query select tag,replacement,paramcount from bbcode 30 Quit 32 Init DB mh_db1 31 Init DB mh_db1 32 Query select * from smilie order by representation desc 31 Query select tag,replacement,paramcount from bbcode 31 Init DB mh_db1 31 Query select * from smilie order by representation desc 27 Quit 32 Init DB mh_db1 32 Init DB mh_db1 32 Init DB mh_db1 32 Init DB mh_db1 32 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 32 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 32 Init DB mh_db1 32 Query select last_seen_loc from session where ipaddress = '200.121.221.253' limit 1 31 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 31 Query select x.userid,x.password,x.usergroupid,x.username,x.email,x.lastactivity as last_seen, x.pmunread as pms,y.width as ava_w,y.height as ava_h,y.dateline from f_user as x left join f_customavatar as y on(x.userid = y.userid) where x.userid = '12648' limit 1 32 Init DB mh_db1 32 Query select id,templatelist from style where id in(-1,-1) order by id desc 32 Init DB mh_db1 32 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 32 Init DB mh_db1 32 Init DB mh_db1 32 Init DB mh_db1 32 Init DB mh_db1 32 Init DB mh_db1 32 Init DB mh_db1 32 Init DB mh_db1 6 Quit 32 Init DB mh_db1 32 Init DB mh_db1 32 Init DB mh_db1 31 Init DB mh_db1 31 Query select last_seen_loc from session where ipaddress = '173.68.164.78' limit 1 31 Init DB mh_db1 31 Query select id,templatelist from style where id in(-1,-1) order by id desc 31 Init DB mh_db1 31 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 31 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 32 Init DB mh_db1 31 Init DB mh_db1 32 Init DB mh_db1 32 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 32 Init DB mh_db1 32 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238247800' limit 1 32 Init DB mh_db1 32 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238247799' limit 1 31 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 31 Init DB mh_db1 31 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238072071' limit 1 31 Init DB mh_db1 31 Query update mga_category set views_today = ( views_today + 1), views_ever = ( views_ever + 1) where id = '1238072138' limit 1 32 Init DB mh_db1 32 Init DB mh_db1 32 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('200.121.221.253','f426325fd628fa1fd7db958d2f6a83e9','0','0','1238456585','mga_VIEWER/,select/,OshieAi/OneShot') 31 Init DB mh_db1 31 Init DB mh_db1 31 Query replace into session (ipaddress,sessionhash,rank,user,last_seen,last_seen_loc) values ('173.68.164.78','4b90cca67273088402b1da3279400f62','1','12648','1238456585','mga_VIEWER/,select/,After School Sex Slave Club/004') 31 Init DB mh_db1 31 Query update f_user set lastactivity = '1238456585' where userid = '12648' limit 1 33 Connect mh_db1@localhost on 33 Init DB mh_db1 33 Init DB mh_db1 33 Query select `key`,data from `datacache` 32 Quit 33 Init DB mh_db1 33 Query select tag,replacement,paramcount from bbcode 33 Init DB mh_db1 33 Query select * from smilie order by representation desc 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Query select last_seen_loc from session where ipaddress = '71.172.234.8' limit 1 31 Quit 33 Init DB mh_db1 33 Query select id,templatelist from style where id in(-1,-1) order by id desc 33 Init DB mh_db1 33 Query select templatename,template from template where id in (1,2,3,58,167,181,182,218,252,253) 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Init DB mh_db1 33 Init Last edited by digitalpioneer; 03-30-2009 at 07:58 PM.
Posted by GOT, 03-30-2009, 09:10 PM
I do think mytop would be much more useful to you.
Posted by digitalpioneer, 03-30-2009, 09:17 PM
It dosn't help me much since I can't understand it. Here's what I'm getting:
Posted by GOT, 03-30-2009, 09:23 PM
Well, there is some important info in there, and also some important info getting cut off. For one qps: 1867 Slow: 0.0 The fact that there are no slow queires is a good thing. However, 1800+qps is going to kill the server. You should expand your ssh window so you have more columns because off to the right is lists what queries are being run on a certain process. The output you sent is not terribly legible either since there aren't many linebreaks in it. Once you have the sql that is being repeated over and over again, you give that to whomeever is in charge of the website. Or, if you are running a shared environment, you shut down the site that is using the database that is causing all the queries to run.
Posted by digitalpioneer, 03-30-2009, 09:28 PM
Sorry about that, I did not see the horrible copy/past. Here's a screenshot: http://img15.imageshack.us/img15/2059/rrrrrru.gif I would like to add that I hardly see any "query" type. Most of the stuff I see is "sleep" type. Last edited by digitalpioneer; 03-30-2009 at 09:31 PM.
Posted by GOT, 03-30-2009, 10:00 PM
It suprising that you do not see more query types with that high of a qps rate. You can, as an alternative, run from ssh mysqladmin processlist|grep Query Orm if you want the whole list, simply mysqladmin processlist but the key is finding out WHO is generating that many qps and once that, why.
Posted by digitalpioneer, 03-30-2009, 10:04 PM
I've ran mysqladmin -u root -p processlist|grep Query and all I get is 1-2 queries... I dont see 2000 queries, like it says I am getting every second. By the way, GOT, are you on MSN? I've added jon@greenolivetree.net, not sure if that's you.
Posted by GOT, 03-30-2009, 10:14 PM
I'll hop on chat, but that is not normal, its just a litte slow tonight. We can back up a little. Do you already know what site is causing the problem? How many domains do you have on there? Is this a cpanel server or something else?
Posted by digitalpioneer, 03-30-2009, 10:18 PM
Yes I know which site is causing the problem. There is only one website hosted on the server, and its forums (vBulletin). There is no cPanel, and the server is at SoftLayer.
Posted by GOT, 03-30-2009, 10:25 PM
That high of a rate, and it could be an attack if that is not a normal rate. Looking at netstat to see if there is any one IP connecting too many times would be helpful, and, again, making sure a proper firewall is installed would be very important. Also making sure vbulletin is up to date is important as well.
Posted by digitalpioneer, 03-30-2009, 10:34 PM
There dosn't seem to be an attack. The highest number of connections from an IP is 15. Command used: netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n. The forum is up-to-date.
Posted by GOT, 03-30-2009, 10:37 PM
And how many users on at one time generally? When did it spike up? I've also seen modules/mods that are poorly written cause qps to spike up.