[wp-trac] [WordPress Trac] #22074: Very Large Query that Crashes the whole My SQL and site
WordPress Trac
noreply at wordpress.org
Tue Feb 12 18:13:18 UTC 2013
#22074: Very Large Query that Crashes the whole My SQL and site
----------------------------------------+--------------------
Reporter: adest | Owner:
Type: enhancement | Status: new
Priority: normal | Milestone: 3.6
Component: Performance | Version: 3.4.1
Severity: normal | Resolution:
Keywords: has-patch needs-unit-tests |
----------------------------------------+--------------------
Description changed by SergeyBiryukov:
Old description:
> Hi David,
>
> The problem is being caused by an extremely large mysql query. This is
> just a snippet of it. The full query is in /home/profithunters/query. You
> should have your dev look at it.
>
> What user/pass are you using for mysql? You can login as the root mysql
> user by logging into https://profithunters.nmsrv.com/gadmin/ and then
> going to MySQL -> Launch phpmyadmin.
>
> | 370 | 371 |
> | 1697 | profithu_wrdp2 | localhost | profithu_wrdp2 | Query | 78 |
> statistics | SELECT * FROM wp_posts WHERE (post_type = 'page'
> AND post_status = 'publish') AND ( ID <> 3778 AND ID <> 49911 AND ID
> <> 0 AND ID <> 20531 AND ID <> 3776 AND ID <> 3792 AND ID <> 3794
> AND ID <> 3797 AND ID <> 3799 AND ID <> 3801 AND ID <> 3803 AND ID <>
> 3805 AND ID <> 3807 AND ID <> 3811 AND ID <> 5540 AND ID <> 6500 AND
> ID <> 8965 AND ID <> 9363 AND ID <> 10974 AND ID <> 11516 AND ID <>
> 11822 AND ID <> 12903 AND ID <> 12907 AND ID <> 12911 AND ID <> 13928
> AND ID <> 13930 AND ID <> 14188 AND ID <> 14192 AND ID <> 14935 AND
> ID <> 14937 AND ID <> 14939 AND ID <> 14941 AND ID <> 15023 AND ID <>
> 15376 AND ID <> 19768 AND ID <> 20980 AND ID <> 20984 AND ID <> 21353
> AND ID <> 21550 AND ID <> 21554 AND ID <> 21559 AND ID <> 21562 AND
> ID <> 21618 AND ID <> 21623 AND ID <> 21629 AND ID <> 21674 AND ID <>
> 21677 AND ID <> 21682 AND ID <> 21689 AND ID <> 21694 AND ID <> 21703
> AND ID <> 21706 AND ID <> 21707 AND ID <> 21714 AND ID <> 21717 AND
> ID <> 21744 AND ID <> 21834 AND ID <> 21859 AND ID <> 21862 AND ID <>
> 21865 AND ID <> 21873 AND ID <> 21876 AND ID <> 21880 AND ID <> 21884
> AND ID <> 21897 AND ID <> 21900 AND ID <> 21902 AND ID <> 21905 AND
> ID <> 21936 AND ID <> 21938 AND ID <> 21940 AND ID <> 21949 AND ID <>
> 21951 AND ID <> 21958 AND ID <> 21966 AND ID <> 21983 AND ID <> 21986
> AND ID <> 21989 AND ID <> 21995 AND ID <> 22000 AND ID <> 22004 AND
> ID <> 22006 AND ID <> 22010 AND ID <> 22014 AND ID <> 22016 AND ID <>
> 22020 AND ID <> 22024 AND ID <> 22026 AND ID <> 22028 AND ID <> 22030
> AND ID <> 22037 AND ID <> 22040 AND ID <> 22043 AND ID <> 22046 AND
> ID <> 22049 AND ID <> 22058 AND ID <> 22060 AND ID <> 22062 AND ID <>
> 22065 AND ID <> 22068 AND ID <> 22071 AND ID <> 22073 AND ID <> 22075
> AND ID <> 22078 AND ID <> 22085 AND ID <> 22087 AND ID <> 22089 AND
> ID <> 22094 AND ID <> 22125 AND ID <> 22128 AND ID <> 22133 AND ID <>
> 22137 AND ID <> 22141 AND ID <> 22144 AND ID <> 22151 AND ID <> 22153
> AND ID <> 22155 AND ID <> 22157 AND ID <> 22160 AND ID <> 22162 AND
> ID <> 22165 AND ID <> 22168 AND ID <> 22170 AND ID <> 22172 AND ID <>
> 22174 AND ID <> 22176 AND ID <> 22178 AND ID <> 22180 AND ID <> 22184
> AND ID <> 22186 AND ID
New description:
Hi David,
The problem is being caused by an extremely large mysql query. This is
just a snippet of it. The full query is in /home/profithunters/query. You
should have your dev look at it.
What user/pass are you using for mysql? You can login as the root mysql
user by logging into https://profithunters.nmsrv.com/gadmin/ and then
going to MySQL -> Launch phpmyadmin.
{{{
| 370 | 371 |
| 1697 | profithu_wrdp2 | localhost | profithu_wrdp2 | Query | 78 |
statistics | SELECT * FROM wp_posts WHERE (post_type = 'page'
AND post_status = 'publish') AND ( ID <> 3778 AND ID <> 49911 AND ID <>
0 AND ID <> 20531 AND ID <> 3776 AND ID <> 3792 AND ID <> 3794 AND ID
<> 3797 AND ID <> 3799 AND ID <> 3801 AND ID <> 3803 AND ID <> 3805
AND ID <> 3807 AND ID <> 3811 AND ID <> 5540 AND ID <> 6500 AND ID <>
8965 AND ID <> 9363 AND ID <> 10974 AND ID <> 11516 AND ID <> 11822
AND ID <> 12903 AND ID <> 12907 AND ID <> 12911 AND ID <> 13928 AND ID
<> 13930 AND ID <> 14188 AND ID <> 14192 AND ID <> 14935 AND ID <>
14937 AND ID <> 14939 AND ID <> 14941 AND ID <> 15023 AND ID <> 15376
AND ID <> 19768 AND ID <> 20980 AND ID <> 20984 AND ID <> 21353 AND ID
<> 21550 AND ID <> 21554 AND ID <> 21559 AND ID <> 21562 AND ID <>
21618 AND ID <> 21623 AND ID <> 21629 AND ID <> 21674 AND ID <> 21677
AND ID <> 21682 AND ID <> 21689 AND ID <> 21694 AND ID <> 21703 AND ID
<> 21706 AND ID <> 21707 AND ID <> 21714 AND ID <> 21717 AND ID <>
21744 AND ID <> 21834 AND ID <> 21859 AND ID <> 21862 AND ID <> 21865
AND ID <> 21873 AND ID <> 21876 AND ID <> 21880 AND ID <> 21884 AND ID
<> 21897 AND ID <> 21900 AND ID <> 21902 AND ID <> 21905 AND ID <>
21936 AND ID <> 21938 AND ID <> 21940 AND ID <> 21949 AND ID <> 21951
AND ID <> 21958 AND ID <> 21966 AND ID <> 21983 AND ID <> 21986 AND ID
<> 21989 AND ID <> 21995 AND ID <> 22000 AND ID <> 22004 AND ID <>
22006 AND ID <> 22010 AND ID <> 22014 AND ID <> 22016 AND ID <> 22020
AND ID <> 22024 AND ID <> 22026 AND ID <> 22028 AND ID <> 22030 AND ID
<> 22037 AND ID <> 22040 AND ID <> 22043 AND ID <> 22046 AND ID <>
22049 AND ID <> 22058 AND ID <> 22060 AND ID <> 22062 AND ID <> 22065
AND ID <> 22068 AND ID <> 22071 AND ID <> 22073 AND ID <> 22075 AND ID
<> 22078 AND ID <> 22085 AND ID <> 22087 AND ID <> 22089 AND ID <>
22094 AND ID <> 22125 AND ID <> 22128 AND ID <> 22133 AND ID <> 22137
AND ID <> 22141 AND ID <> 22144 AND ID <> 22151 AND ID <> 22153 AND ID
<> 22155 AND ID <> 22157 AND ID <> 22160 AND ID <> 22162 AND ID <>
22165 AND ID <> 22168 AND ID <> 22170 AND ID <> 22172 AND ID <> 22174
AND ID <> 22176 AND ID <> 22178 AND ID <> 22180 AND ID <> 22184 AND ID
<> 22186 AND ID
}}}
--
--
Ticket URL: <http://core.trac.wordpress.org/ticket/22074#comment:13>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software
More information about the wp-trac
mailing list