1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
| donnees@LNX64BDD:~$ mysqldumpslow /var/log/mysql/mysql-slow.log -s t -t 5 -i agefiph > slow.txt
Reading mysql slow query log from /var/log/mysql/mysql-slow.log
donnees@LNX64BDD:~$ less slow.txt
Count: 8 Time=445.83s (3566s) Lock=0.00s (0s) Rows=1.0 (8), agefiph[agefiph]@[10.222.114.195]
SELECT
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
,ezcontentobject_link AS t0,ezcontentobject_link AS t1,ezcontentobject_link AS t2,ezcontentobject_link AS t3,ezcontentobject_link AS t4,ezcontentobject_link AS t5
WHERE ezcontentobject_tree.path_string like 'S' and
ezcontentobject_tree.contentobject_id = t0.from_contentobject_id AND ezcontentobject_tree.contentobject_version = t0.from_contentobject_version AND ezcontentobject_tree.contentobject_id=t1.from_contentobject_id AND ezcontentobject_tree.contentobject_version=t1.from_contentobject_version AND ezcontentobject_tree.contentobject_id=t2.from_contentobject_id AND ezcontentobject_tree.contentobject_version=t2.from_contentobject_version AND ezcontentobject_tree.contentobject_id=t3.from_contentobject_id AND ezcontentobject_tree.contentobject_version=t3.from_contentobject_version AND ezcontentobject_tree.contentobject_id=t4.from_contentobject_id AND ezcontentobject_tree.contentobject_version=t4.from_contentobject_version AND ezcontentobject_tree.contentobject_id=t5.from_contentobject_id AND ezcontentobject_tree.contentobject_version=t5.from_contentobject_version AND (t0.contentclassattribute_id=N AND t0.to_contentobject_id=N OR t1.contentclassattribute_id=N AND t1.to_contentobject_id=N OR t2.contentclassattribute_id=N AND t2.to_contentobject_id=N OR t3.contentclassattribute_id=N AND t3.to_contentobject_id=N OR t4.contentclassattribute_id=N AND t4.to_contentobject_id=N OR t5.contentclassattribute_id=N AND t5.to_contentobject_id=N) AND
ezcontentobject_tree.node_id = ezcontentobject_tree.main_node_id AND
ezcontentobject.contentclass_id IN ( N ) AND
ezcontentclass.version=N AND
ezcontentobject_tree.node_id != N AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > N AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & N )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & N ) )
<
( ezcontentobject_name.language_id & N )
+ ( ( ezcontentobject_name.language_id & N ) )
)
AND ezcontentobject_tree.is_invisible = N
AND
ezcontentobject.language_mask & N > N
Count: 8 Time=256.24s (2049s) Lock=0.00s (0s) Rows=1.5 (12), agefiph[agefiph]@[10.222.114.195]
SELECT DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
,ezcontentobject_link AS t0,ezcontentobject_link AS t1,ezcontentobject_link AS t2,ezcontentobject_link AS t3,ezcontentobject_link AS t4,ezcontentobject_link AS t5
WHERE
ezcontentobject_tree.path_string like 'S' and
ezcontentobject_tree.contentobject_id = t0.from_contentobject_id AND ezcontentobject_tree.contentobject_version = t0.from_contentobject_version AND ezcontentobject_tree.contentobject_id=t1.from_contentobject_id AND ezcontentobject_tree.contentobject_version=t1.from_contentobject_version AND ezcontentobject_tree.contentobject_id=t2.from_contentobject_id AND ezcontentobject_tree.contentobject_version=t2.from_contentobject_version AND ezcontentobject_tree.contentobject_id=t3.from_contentobject_id AND ezcontentobject_tree.contentobject_version=t3.from_contentobject_version AND ezcontentobject_tree.contentobject_id=t4.from_contentobject_id AND ezcontentobject_tree.contentobject_version=t4.from_contentobject_version AND ezcontentobject_tree.contentobject_id=t5.from_contentobject_id AND ezcontentobject_tree.contentobject_version=t5.from_contentobject_version AND (t0.contentclassattribute_id=N AND t0.to_contentobject_id=N OR t1.contentclassattribute_id=N AND t1.to_contentobject_id=N OR t2.contentclassattribute_id=N AND t2.to_contentobject_id=N OR t3.contentclassattribute_id=N AND t3.to_contentobject_id=N OR t4.contentclassattribute_id=N AND t4.to_contentobject_id=N OR t5.contentclassattribute_id=N AND t5.to_contentobject_id=N) AND
ezcontentclass.version=N AND
ezcontentobject_tree.node_id != N AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.node_id = ezcontentobject_tree.main_node_id AND
ezcontentobject.contentclass_id IN ( N ) AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > N AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & N )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & N ) )
<
( ezcontentobject_name.language_id & N )
+ ( ( ezcontentobject_name.language_id & N ) )
)
AND ezcontentobject_tree.is_invisible = N
AND
ezcontentobject.language_mask & N > N
ORDER BY ezcontentobject.published DESC
LIMIT N, N
Count: 6 Time=37.68s (226s) Lock=0.00s (0s) Rows=0.0 (0), agefiph[agefiph]@[10.222.114.195]
INSERT INTO ezsearch_tmp_0 SELECT DISTINCT ezsearch_object_word_link.contentobject_id, ezsearch_object_word_link.published
FROM ezcontentobject,
ezsearch_object_word_link
,
ezcontentclass,
ezcontentobject_tree
WHERE
ezsearch_object_word_link.contentclass_id IN ( N ) AND
ezcontentobject.id=ezsearch_object_word_link.contentobject_id and
ezcontentobject.contentclass_id = ezcontentclass.id and
ezcontentclass.version = 'S' and
ezcontentobject.id = ezcontentobject_tree.contentobject_id and
ezcontentobject_tree.node_id = ezcontentobject_tree.main_node_id
AND ezcontentobject_tree.is_invisible = N
Count: 1 Time=148.01s (148s) Lock=0.00s (0s) Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost
select count(*) into @discard from `information_schema`.`PARTITIONS`
Count: 1 Time=66.86s (66s) Lock=0.00s (0s) Rows=49.0 (49), debian-sys-maint[debian-sys-maint]@localhost
select concat('S',
TABLE_SCHEMA, 'S', TABLE_NAME, 'S')
from information_schema.TABLES where ENGINE='S' |
Partager