-
-
Save heartsandlaserbeams/d3e158087dc5a261a01f to your computer and use it in GitHub Desktop.
rlt error log
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
RECENT MYSQL SLOW QUERIES | |
SUM(if(SM.opened_time > 0, 1, 0)) AS 'count_opened' | |
FROM wp_enewsletter_newsletters A | |
LEFT JOIN wp_enewsletter_send S ON (A.newsletter_id = S.newsletter_id) | |
LEFT JOIN wp_enewsletter_send_members SM ON (S.send_id = SM.send_id) GROUP | |
BY A.newsletter_id ORDER BY create_date desc LIMIT 1 /* From | |
[roadlesstraveledstore.com/wp-admin/update-core.php] in [/nas/wp/www/cluster- | |
1429/rltstore/wp-content/plugins/e-newsletter/email-newsletter- | |
files/class.functions.php:931] */; | |
# Time: 130903 12:12:01 | |
# User@Host: rltstore[rltstore] @ localhost [127.0.0.1] | |
# Thread_id: 4205895 Schema: wp_rltstore Last_errno: 0 Killed: 0 | |
# Query_time: 43.283981 Lock_time: 0.000128 Rows_sent: 1 Rows_examined: 3280222 | |
Rows_affected: 0 Rows_read: 1 | |
# Bytes_sent: 1239 Tmp_tables: 1 Tmp_disk_tables: 1 Tmp_table_sizes: 383152 | |
SET timestamp=1378210321; | |
SELECT A.*, S.start_time AS 'last_sent_time' , | |
SUM(if(SM.status = 'bounced', 1, 0)) AS 'count_bounced', | |
SUM(if(SM.status = 'sent', 1, 0)) AS 'count_sent', | |
SUM(if(SM.opened_time > 0, 1, 0)) AS 'count_opened' | |
FROM wp_enewsletter_newsletters A | |
LEFT JOIN wp_enewsletter_send S ON (A.newsletter_id = S.newsletter_id) | |
LEFT JOIN wp_enewsletter_send_members SM ON (S.send_id = SM.send_id) GROUP | |
BY A.newsletter_id ORDER BY create_date desc LIMIT 1 /* From | |
[roadlesstraveledstore.com/wp-admin/themes.php?broken=true] in [/nas/wp/www/cluster- | |
1429/rltstore/wp-content/plugins/e-newsletter/email-newsletter- | |
files/class.functions.php:931] */; | |
# Time: 130903 12:13:19 | |
# User@Host: rltstore[rltstore] @ localhost [127.0.0.1] | |
# Thread_id: 4205937 Schema: wp_rltstore Last_errno: 0 Killed: 0 | |
# Query_time: 44.118811 Lock_time: 0.000086 Rows_sent: 1 Rows_examined: 3280222 | |
Rows_affected: 0 Rows_read: 1 | |
# Bytes_sent: 1239 Tmp_tables: 1 Tmp_disk_tables: 1 Tmp_table_sizes: 383152 | |
SET timestamp=1378210399; | |
SELECT A.*, S.start_time AS 'last_sent_time' , | |
SUM(if(SM.status = 'bounced', 1, 0)) AS 'count_bounced', | |
SUM(if(SM.status = 'sent', 1, 0)) AS 'count_sent', | |
SUM(if(SM.opened_time > 0, 1, 0)) AS 'count_opened' | |
FROM wp_enewsletter_newsletters A | |
LEFT JOIN wp_enewsletter_send S ON (A.newsletter_id = S.newsletter_id) | |
LEFT JOIN wp_enewsletter_send_members SM ON (S.send_id = SM.send_id) GROUP | |
BY A.newsletter_id ORDER BY create_date desc LIMIT 1 /* From | |
[roadlesstraveledstore.com/wp-admin/themes.php? | |
action=activate&template=thesis_184&stylesheet=thesis_184&_wpnonce=796dd1f7b1] in | |
[/nas/wp/www/cluster-1429/rltstore/wp-content/plugins/e-newsletter/email-newsletter- | |
files/class.functions.php:931] */; | |
# Time: 130903 12:14:03 | |
# User@Host: rltstore[rltstore] @ localhost [127.0.0.1] | |
# Thread_id: 4205972 Schema: wp_rltstore Last_errno: 1160 Killed: 1053 | |
# Query_time: 43.254931 Lock_time: 0.000093 Rows_sent: 0 Rows_examined: 0 | |
Rows_affected: 0 Rows_read: 0 | |
# Bytes_sent: 0 Tmp_tables: 1 Tmp_disk_tables: 1 Tmp_table_sizes: 0 | |
SET timestamp=1378210443; | |
SELECT A.*, S.start_time AS 'last_sent_time' , | |
SUM(if(SM.status = 'bounced', 1, 0)) AS 'count_bounced', | |
SUM(if(SM.status = 'sent', 1, 0)) AS 'count_sent', | |
SUM(if(SM.opened_time > 0, 1, 0)) AS 'count_opened' | |
FROM wp_enewsletter_newsletters A | |
LEFT JOIN wp_enewsletter_send S ON (A.newsletter_id = S.newsletter_id) | |
LEFT JOIN wp_enewsletter_send_members SM ON (S.send_id = SM.send_id) GROUP | |
BY A.newsletter_id ORDER BY create_date desc LIMIT 1 /* From | |
[roadlesstraveledstore.com/wp-admin/admin.php?page=thesis-options&upgraded=true] in | |
[/nas/wp/www/cluster-1429/rltstore/wp-content/plugins/e-newsletter/email-newsletter- | |
files/class.functions.php:931] */; | |
# Time: 130903 12:27:31 | |
# User@Host: ilovemamatest[ilovemamatest] @ localhost [127.0.0.1] | |
# Thread_id: 4206477 Schema: snapshot_ilovemamatest Last_errno: 0 Killed: 0 | |
# Query_time: 2.134600 Lock_time: 0.000067 Rows_sent: 1 Rows_examined: 30258 | |
Rows_affected: 0 Rows_read: 1 | |
# Bytes_sent: 487 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 | |
# InnoDB_trx_id: 1BB6A451 | |
use snapshot_ilovemamatest; | |
SET timestamp=1378211251; | |
SELECT COUNT(NULLIF(`meta_value` LIKE '%"administrator"%', false)), COUNT(NULLIF | |
(`meta_value` LIKE '%"editor"%', false)), COUNT(NULLIF(`meta_value` LIKE '%"author"%', | |
false)), COUNT(NULLIF(`meta_value` LIKE '%"contributor"%', false)), COUNT(NULLIF | |
(`meta_value` LIKE '%"subscriber"%', false)), COUNT(*) FROM wp_usermeta WHERE meta_key = | |
'wp_capabilities' /* From [ilovemamatest.staging.wpengine.com/wp-cron.php? | |
doing_wp_cron=1378211248.8092730045318603515625] in | |
[/nas/wp/www/staging/ilovemamatest/wp-cron.php:92] */; | |
# Time: 130903 12:29:03 | |
# User@Host: ilovemamatest[ilovemamatest] @ localhost [127.0.0.1] | |
# Thread_id: 4206477 Schema: snapshot_ilovemamatest Last_errno: 0 Killed: 0 | |
# Query_time: 2.573252 Lock_time: 0.000117 Rows_sent: 202 Rows_examined: 519985 | |
Rows_affected: 0 Rows_read: 202 | |
# Bytes_sent: 2111 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 129040 | |
# InnoDB_trx_id: 1BB6F971 | |
SET timestamp=1378211343; | |
SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = | |
wp_postmeta.post_id) WHERE 1=1 AND wp_posts.post_type = 'gb_purchase' AND | |
(wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft') AND ( | |
(wp_postmeta.meta_key = '_deal_id' AND CAST(wp_postmeta.meta_value AS CHAR) = '1724') ) | |
GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC /* From | |
[ilovemamatest.staging.wpengine.com/wp-cron.php? | |
doing_wp_cron=1378211248.8092730045318603515625] in | |
[/nas/wp/www/staging/ilovemamatest/wp-content/plugins/group- | |
buying/models/groupBuyingPostType.class.php:473] */; | |
# Time: 130903 14:15:03 | |
# User@Host: rltstore[rltstore] @ localhost [127.0.0.1] | |
# Thread_id: 4211552 Schema: wp_rltstore Last_errno: 1160 Killed: 1053 | |
# Query_time: 34.681510 Lock_time: 0.000086 Rows_sent: 0 Rows_examined: 0 | |
Rows_affected: 0 Rows_read: 0 | |
# Bytes_sent: 0 Tmp_tables: 1 Tmp_disk_tables: 1 Tmp_table_sizes: 0 | |
use wp_rltstore; | |
SET timestamp=1378217703; | |
SELECT A.*, S.start_time AS 'last_sent_time' , | |
SUM(if(SM.status = 'bounced', 1, 0)) AS 'count_bounced', | |
SUM(if(SM.status = 'sent', 1, 0)) AS 'count_sent', | |
SUM(if(SM.opened_time > 0, 1, 0)) AS 'count_opened' | |
FROM wp_enewsletter_newsletters A | |
LEFT JOIN wp_enewsletter_send S ON (A.newsletter_id = S.newsletter_id) | |
LEFT JOIN wp_enewsletter_send_members SM ON (S.send_id = SM.send_id) GROUP | |
BY A.newsletter_id ORDER BY create_date desc LIMIT 1 /* From | |
[roadlesstraveledstore.com/wp-admin/] in [/nas/wp/www/cluster-1429/rltstore/wp- | |
content/plugins/e-newsletter/email-newsletter-files/class.functions.php:931] */; | |
# Time: 130903 14:16:27 | |
# User@Host: rltstore[rltstore] @ localhost [127.0.0.1] | |
# Thread_id: 4211642 Schema: wp_rltstore Last_errno: 0 Killed: 0 | |
# Query_time: 46.554866 Lock_time: 0.000084 Rows_sent: 1 Rows_examined: 3280222 | |
Rows_affected: 0 Rows_read: 1 | |
# Bytes_sent: 1239 Tmp_tables: 1 Tmp_disk_tables: 1 Tmp_table_sizes: 383152 | |
SET timestamp=1378217787; | |
SELECT A.*, S.start_time AS 'last_sent_time' , | |
SUM(if(SM.status = 'bounced', 1, 0)) AS 'count_bounced', | |
SUM(if(SM.status = 'sent', 1, 0)) AS 'count_sent', | |
SUM(if(SM.opened_time > 0, 1, 0)) AS 'count_opened' | |
FROM wp_enewsletter_newsletters A | |
LEFT JOIN wp_enewsletter_send S ON (A.newsletter_id = S.newsletter_id) | |
LEFT JOIN wp_enewsletter_send_members SM ON (S.send_id = SM.send_id) GROUP | |
BY A.newsletter_id ORDER BY create_date desc LIMIT 1 /* From | |
[roadlesstraveledstore.com/wp-admin/edit.php] in [/nas/wp/www/cluster-1429/rltstore/wp- | |
content/plugins/e-newsletter/email-newsletter-files/class.functions.php:931] */; | |
# Time: 130903 14:17:53 | |
# User@Host: rltstore[rltstore] @ localhost [127.0.0.1] | |
# Thread_id: 4211722 Schema: wp_rltstore Last_errno: 0 Killed: 0 | |
# Query_time: 43.605793 Lock_time: 0.000112 Rows_sent: 1 Rows_examined: 3280222 | |
Rows_affected: 0 Rows_read: 1 | |
# Bytes_sent: 1239 Tmp_tables: 1 Tmp_disk_tables: 1 Tmp_table_sizes: 383152 | |
SET timestamp=1378217873; | |
SELECT A.*, S.start_time AS 'last_sent_time' , | |
SUM(if(SM.status = 'bounced', 1, 0)) AS 'count_bounced', | |
SUM(if(SM.status = 'sent', 1, 0)) AS 'count_sent', | |
SUM(if(SM.opened_time > 0, 1, 0)) AS 'count_opened' | |
FROM wp_enewsletter_newsletters A | |
LEFT JOIN wp_enewsletter_send S ON (A.newsletter_id = S.newsletter_id) | |
LEFT JOIN wp_enewsletter_send_members SM ON (S.send_id = SM.send_id) GROUP BY | |
A.newsletter_id ORDER BY create_date desc LIMIT 1 /* From [roadlesstraveledstore.com/wp- | |
admin/edit.php?post_type=tribe_events] in [/nas/wp/www/cluster-1429/rltstore/wp- | |
content/plugins/e-newsletter/email-newsletter-files/class.functions.php:931] */; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment