Mysql usage at the same time evry day
i have strange problem, my server evry day around the 5Pm process a lot of Mysql request that cause a high load around 20-40, all the mysql request come from all the sites that are using mysql, this is really strange what can be the cause? is there any Cron for mysql?
Mytop Report:
MySQL on localhost (4.0.18-standard) up 0+00:01:43 [16:54:48]
Queries: 1.7k qps: 17 Slow: 2.0 Se/In/Up/De(%): 69/03/08/01
qps now: 15 Slow qps: 0.0 Threads: 19 ( 14/ 4) 75/01/04/00
Cache Hits: 435.0 Hits/s: 4.2 Hits now: 3.8 Ratio: 35.9% Ratio now: 32.8%
Key Efficiency: 93.6% Bps in/out: 2.2k/27.2k Now in/out: 2.7k/42.6k
Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
26 root localhost test 0 Query show full processlist
125 interfan localhost interfan_i 0 Query SELECT bb2_moderators.userid, username FROM bb2_moderators LEFT JOIN bb2_users USING (userid)
132 juichin_a localhost juichin_ne 0 Sleep
68 twdit_pnu localhost twdit_pnuk 0 Query SELECT SUM(nuke_poll_data.pn_optioncount) AS sum FROM nuke_poll_data WHERE nuke_poll_data.pn_p
133 logikawe_ localhost logikawe_s 0 Sleep
83 altoa1_pn localhost altoa1_pnu 0 Query SELECT nuke_stories_cat.pn_catid as catid, nuke_stories_cat.pn_title as title FROM nuke_storie
85 twdit_pnu localhost twdit_pnuk 0 Query SELECT nuke_modules.pn_name, nuke_modules.pn_type, nuke_modules.pn_directory, nuke_modules.pn_
88 root localhost mysql 0 Query select User from db where Db='twdit\_stats'
112 cdradio_b localhost cdradio_db 0 Query SELECT * FROM thumbnail_files ORDER BY RAND() LIMIT 1
119 interfan localhost interfan_i 0 Query SELECT smiliepath, smilietitle, smiliecode FROM bb2_smilies ORDER BY smilieorder ASC
120 legambi_x localhost legambi_xo 0 Query INSERT INTO xoops_session (sess_id, sess_updated, sess_ip, sess_data) VALUES ('0cd60803da28247
53 twdit_pnu localhost twdit_pnuk 1 Sleep
70 twdit_pnu localhost twdit_pnuk 1 Sleep
114 motolagg_ localhost motolagg_f 5 Query SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JO
129 motolagg_ localhost motolagg_f 5 Query SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JO
100 motolagg_ localhost motolagg_f 6 Query SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JO
118 interfan localhost interfan_i 6 Query SELECT searchid FROM bb2_searchs WHERE postids=',273321,273322,273323,273324,273325,273326,273
93 interfan localhost interfan_i 23 Query SELECT searchid FROM bb2_searchs WHERE postids=',273321,273322,273323,273324,273325,273326,273
47 virtualc_ localhost virtualc_d 43 Sleep
Key Reads/Key Read Requests = 0.018931 (Cache hit = 99.981069%)
Key Writes/Key Write Requests = 0.583584
Connections/second = 1.648 (/hour = 5933.945)
KB received/second = 4.948 (/hour = 17812.844)
KB sent/second = 37.135 (/hour = 133684.404)
Temporary Tables Created/second = 0.902 (/hour = 3247.706)
Opened Tables/second = 2.174 (/hour = 7827.523)
Slow Queries/second = 0.018 (/hour = 66.055)
% of slow queries = 0.057%
Queries/second = 32.239 (/hour = 116058.716)
MySQL Query Cache hits = 3778/8033(47%)
