· 8 years ago · Jun 25, 2018, 07:34 AM
1Report for slow logs: mysqld-slow.log
22.17k queries total, 328 unique
3Sorted by 't_sum'
4Grand Totals: Time 733 s, Lock 0 s, Rows sent 23.61k, Rows Examined 5.06M
5
6
7______________________________________________________________________ 001 ___
8Count : 12 (0.55%)
9Time : 122 s total, 10.166667 s avg, 8 s to 15 s max (16.64%)
10 95% of Time : 107 s total, 9.727273 s avg, 8 s to 13 s max
11Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
12 95% of Lock : 0 total, 0 avg, 0 to 0 max
13Rows sent : 0 avg, 0 to 0 max (0.00%)
14Rows examined : 0 avg, 0 to 0 max (0.00%)
15Database : xenforo
16Users :
17 seriosbrad@localhost : 100.00% (12) of query, 99.72% (2168) of all users
18
19Query abstract:
20UPDATE xf_cron_entry SET next_run = 'S' WHERE entry_id = 'S' AND next_run = 'S';
21
22Query sample:
23UPDATE xf_cron_entry
24 SET next_run = '1329419435'
25 WHERE entry_id = 'cleanUpHourly'
26 AND next_run = '1329415854';
27
28______________________________________________________________________ 002 ___
29Count : 8 (0.37%)
30Time : 117 s total, 14.625 s avg, 8 s to 23 s max (15.96%)
31Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
32Rows sent : 0 avg, 0 to 0 max (0.00%)
33Rows examined : 0 avg, 0 to 0 max (0.00%)
34Database : xenforo
35Users :
36 seriosbrad@localhost : 100.00% (8) of query, 99.72% (2168) of all users
37
38Query abstract:
39INSERT INTO xf_data_registry (data_key, data_value) VALUES ('S', 'S')1 ON duplicate KEY UPDATE data_value = VALUES(data_value)1;
40
41Query sample:
42INSERT INTO xf_data_registry
43 (data_key, data_value)
44 VALUES
45 ('cron', 'i:1329425746;')
46 ON DUPLICATE KEY UPDATE
47 data_value = VALUES(data_value);
48
49______________________________________________________________________ 003 ___
50Count : 6 (0.28%)
51Time : 68 s total, 11.333333 s avg, 8 s to 18 s max (9.28%)
52Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
53Rows sent : 0 avg, 0 to 0 max (0.00%)
54Rows examined : 0 avg, 0 to 0 max (0.00%)
55Database :
56Users :
57 seriosbrad@localhost : 100.00% (6) of query, 99.72% (2168) of all users
58
59Query abstract:
60SET insert_id=N; INSERT INTO xf_thread_read (user_id, thread_id, thread_read_date) VALUES ('S', 'S', 'S')1 ON duplicate KEY UPDATE thread_read_date = VALUES(thread_read_date)1;
61
62Query sample:
63SET insert_id=416;
64INSERT INTO xf_thread_read
65 (user_id, thread_id, thread_read_date)
66 VALUES
67 ('889', '1916', '1329355132')
68 ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date);
69
70______________________________________________________________________ 004 ___
71Count : 5 (0.23%)
72Time : 59 s total, 11.8 s avg, 9 s to 14 s max (8.05%)
73Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
74Rows sent : 0 avg, 0 to 0 max (0.00%)
75Rows examined : 0 avg, 0 to 0 max (0.00%)
76Database : xenforo2
77Users :
78 seriosbrad@localhost : 100.00% (5) of query, 99.72% (2168) of all users
79
80Query abstract:
81INSERT INTO xf_ip (user_id, content_type, content_id, action, ip, log_date) VALUES ('S', 'S', 'S', 'S', 'S', 'S')1;
82
83Query sample:
84INSERT INTO `xf_ip` (`user_id`, `content_type`, `content_id`, `action`, `ip`, `log_date`) VALUES ('934', 'user', '934', 'register', '3459062494', '1329434125');
85
86______________________________________________________________________ 005 ___
87Count : 4 (0.18%)
88Time : 56 s total, 14 s avg, 9 s to 19 s max (7.64%)
89Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
90Rows sent : 0 avg, 0 to 0 max (0.00%)
91Rows examined : 0 avg, 0 to 0 max (0.00%)
92Database :
93Users :
94 seriosbrad@localhost : 100.00% (4) of query, 99.72% (2168) of all users
95
96Query abstract:
97INSERT INTO xf_admin_log (request_date, user_id, ip_address, request_url, request_data) VALUES ('S', 'S', 'S', 'S', 'S')1;
98
99Query sample:
100INSERT INTO `xf_admin_log` (`request_date`, `user_id`, `ip_address`, `request_url`, `request_data`) VALUES ('1329417320', '2', '845405982', 'templates/save-multiple.json', '{\"titleArray\":{\"469\":\"spoiler_template\",\"71\":\"bb_code.css\"},\"styleidArray\":{\"469\":\"4\",\"71\":\"0\"},\"templateArray\":{\"469\":\"<xen:require css=\\\"bb_code.css\\\" \\/>\\r\\n<xen:require js=\\\"js\\/spoiler\\/spoiler.js\\\" \\/>\\r\\n\\r\\n<div class=\\\"bbCodeBlock bbCodeQuote bbCodeSpoiler\\\">\\r\\n <aside>\\r\\n <div class=\\\"attribution type\\\">\\r\\n <div style=\\\"float: right;\\\">\\r\\n (<a href=\\\"#\\\" class=\\\"hideToggle\\\">Open<\\/a>)\\r\\n <\\/div>\\r\\n <b>Hidden Content<\\/b><xen:if is=\\\"{$hide}\\\">: {$hide}<\\/xen:if>\\r\\n <\\/div>\\r\\n <blockquote class=\\\"hideContent\\\">{xen:raw $content}<\\/blockquote>\\r\\n <\\/aside>\\r\\n<\\/div>\"},\"addon_id\":\"Spoiler\",\"style_id\":\"4\",\"template_id\":\"469\",\"title_original\":\"spoiler_template\",\"includeTitles\":{\"1\":\"spoiler_template.css\",\"2\":\"spoiler_template\",\"3\":\"spoiler_template.css\",\"4\":\"bb_code.css\"},\"_TemplateEditorAjax\":\"1\",\"_xfRequestUri\":\"\\/admin.php?templates\\/spoiler_template.468\\/edit&style_id=4\",\"_xfNoRedirect\":\"1\",\"_xfResponseType\":\"json\"}');
101
102______________________________________________________________________ 006 ___
103Count : 4 (0.18%)
104Time : 51 s total, 12.75 s avg, 11 s to 14 s max (6.96%)
105Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
106Rows sent : 0 avg, 0 to 0 max (0.00%)
107Rows examined : 0 avg, 0 to 0 max (0.00%)
108Database : xenforo
109Users :
110 seriosbrad@localhost : 100.00% (4) of query, 99.72% (2168) of all users
111
112Query abstract:
113UPDATE xf_user_alert SET view_date = 'S' WHERE (alerted_user_id = N AND view_date = N);
114
115Query sample:
116UPDATE `xf_user_alert` SET `view_date` = '1329438904' WHERE (alerted_user_id = 889 AND view_date = 0);
117
118______________________________________________________________________ 007 ___
119Count : 3 (0.14%)
120Time : 35 s total, 11.666667 s avg, 9 s to 16 s max (4.77%)
121Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
122Rows sent : 0 avg, 0 to 0 max (0.00%)
123Rows examined : 0 avg, 0 to 0 max (0.00%)
124Database : xenforo
125Users :
126 seriosbrad@localhost : 100.00% (3) of query, 99.72% (2168) of all users
127
128Query abstract:
129INSERT INTO xf_thread_read (user_id, thread_id, thread_read_date) VALUES ('S', 'S', 'S')1 ON duplicate KEY UPDATE thread_read_date = VALUES(thread_read_date)1;
130
131Query sample:
132INSERT INTO xf_thread_read
133 (user_id, thread_id, thread_read_date)
134 VALUES
135 ('171', '1925', '1329431982')
136 ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date);
137
138______________________________________________________________________ 008 ___
139Count : 2 (0.09%)
140Time : 27 s total, 13.5 s avg, 13 s to 14 s max (3.68%)
141Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
142Rows sent : 0 avg, 0 to 0 max (0.00%)
143Rows examined : 0 avg, 0 to 0 max (0.00%)
144Database :
145Users :
146 seriosbrad@localhost : 100.00% (2) of query, 99.72% (2168) of all users
147
148Query abstract:
149UPDATE xf_user SET alerts_unread = 'S' WHERE (user_id = N);
150
151Query sample:
152UPDATE `xf_user` SET `alerts_unread` = '0' WHERE (user_id = 889);
153
154______________________________________________________________________ 009 ___
155Count : 1 (0.05%)
156Time : 25 s total, 25 s avg, 25 s to 25 s max (3.41%)
157Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
158Rows sent : 0 avg, 0 to 0 max (0.00%)
159Rows examined : 0 avg, 0 to 0 max (0.00%)
160Database :
161Users :
162 seriosbrad@localhost : 100.00% (1) of query, 99.72% (2168) of all users
163
164Query abstract:
165CREATE TABLE IF NOT EXISTS ewrmedio_categories ( category_id INT(N) UNSIGNED NOT NULL auto_increment, category_name VARCHAR(N) NOT NULL, category_description text NOT NULL, category_order INT(N) UNSIGNED NOT NULL DEFAULT 'S', category_parent INT(N) UNSIGNED NOT NULL DEFAULT 'S', category_disabled INT(N) UNSIGNED NOT NULL DEFAULT 'S', PRIMARY KEY (category_id), INDEX (category_parent) ) engine = innodb CHARACTER SET utf8 COLLATE utf8_general_ci;
166
167Query sample:
168CREATE TABLE IF NOT EXISTS `EWRmedio_categories` (
169 `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
170 `category_name` varchar(255) NOT NULL,
171 `category_description` text NOT NULL,
172 `category_order` int(10) unsigned NOT NULL DEFAULT '1',
173 `category_parent` int(10) unsigned NOT NULL DEFAULT '0',
174 `category_disabled` int(1) unsigned NOT NULL DEFAULT '0',
175 PRIMARY KEY (`category_id`),
176 INDEX (`category_parent`)
177 ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
178
179______________________________________________________________________ 010 ___
180Count : 2 (0.09%)
181Time : 24 s total, 12 s avg, 11 s to 13 s max (3.27%)
182Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
183Rows sent : 0 avg, 0 to 0 max (0.00%)
184Rows examined : 0 avg, 0 to 0 max (0.00%)
185Database :
186Users :
187 seriosbrad@localhost : 100.00% (2) of query, 99.72% (2168) of all users
188
189Query abstract:
190truncate TABLE xf_admin_template_compiled;
191
192Query sample:
193TRUNCATE TABLE xf_admin_template_compiled;