![]() |
MySQL using so much CPU Hello, Since last night i am having high Cpu usage from MySQL. I have enabled logging Slow queries. From log i can see this: # Query_time: 4 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 select at.attachmentid,at.filename,at.postid from forumattachment at where at.attachmentid IN (IF((SELECT ORD(SUBSTR(username,4,1)) FROM forumuser WHERE userid=10666)>103,BENCHMARK(2560000,md5(12345678)) ,1))#); All logs contain: select at.attachmentid,at.filename,at.postid from forumattachment at where Please advise, D |
الساعة الآن 03:10 PM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir