[wp-hackers] Preparing a site for high traffic

[William Canino]

> I attached a list of the queries to the original e-mail.

This mailing list doesn't accept attachments, William, so we here
don't get them. If you need to, I suggest you upload them on
pastebin.ca or another similar site.

That SQL query you gave will be slow if the posts table is missing the
type_status_date index:

ALTER TABLE `rb_posts` ADD INDEX `type_status_date` (`post_type`,
`post_status`(1), `post_date`, `ID`);

It will also run faster with the post_date index:

ALTER TABLE `rb_posts` ADD INDEX `post_date` (`post_date`);

try these and see if the problem goes away.



1/9 William P. Davis <will at copress.org>:
> I attached a list of the queries to the original e-mail. There are some core
> queries that are taking seconds to complete if they're not cached, for
> example:
>
> SELECT SQL_CALC_FOUND_ROWS rb_posts.* FROM rb_posts WHERE 1=1 AND
> rb_posts.post_type = 'post' AND (rb_posts.post_status = 'publish' OR
> rb_posts.post_status = 'private') ORDER BY rb_posts.post_date DESC LIMIT 0,
> 10
>
> which took 1.12 seconds to execute. Has anyone else had similar problems
> with large WordPress sites?
>
> William P. Davis
> will at copress.org
> 207.660.5342 (cell)
> www.copress.org
>
>
> On Jan 9, 2010, at 11:37 PM, Shane A. Froebel wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> William,
>>
>> Only thing I can think of is this:
>> http://codex.wordpress.org/Editing_wp-config.php#Save_queries_for_analysis
>>
>> Your Friend, Shane
>> http://bugssite.org/
>>
>> On 1/9/2010 11:20 PM, William P. Davis wrote:
>>>
>>> Sorry, it wasn't an ad, I was trying to troubleshoot why some of the
>>> core queries in WP were taking so long.
>>>
>>> William P. Davis
>>> will at copress.org
>>> 207.660.5342 (cell)
>>> www.copress.org
>>> -----------------------
>>> 24-hour support: (888) 722-6773
>>>
>>> On Jan 9, 2010, at 11:16 PM, Shane A. Froebel wrote:
>>>
>>> William,
>>>
>>> Please do not post ads here on the development site. Please use
>>> jobs.wordpress.org and post up something. This list is for development
>>> purposes.
>>>
>>> Your Friend, Shane
>>> http://bugssite.org/
>>>
>>> On 1/9/2010 11:13 PM, William P. Davis wrote:
>>>>>>
>>>>>> <snip>
>>>>>>
>>>>>> William P. Davis
>>>>>> will at copress.org
>>>>>> 207.660.5342 (cell)
>>>>>> www.copress.org
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> wp-hackers mailing list
>>>>>> wp-hackers at lists.automattic.com
>>>>>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>>
>> _______________________________________________
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>>
>>> _______________________________________________
>>> wp-hackers mailing list
>>> wp-hackers at lists.automattic.com
>>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.10 (MingW32)
>>
>> iQIcBAEBAgAGBQJLSVmEAAoJEC7/vS6gbNwFayUP/i/ko+9xichujoC3uC68R7V8
>> hrGCXgBHGTA6ljwmNxXVdtTQw5op8AmtghbHDyQ+/kN4ygDz9P9pt5JwBCeieBC0
>> loZ1jHQoqr/3VuY6vkRSuGKelem7t8DKODcfQqQH63n7HtT0iSU5aw5T8qEC7gEF
>> aHWpufTJuxYfOBQAf+UqMHhTZVyQD//SCBoJjEXTEle/FknV1yllm/sACcaF5fle
>> rm3RQTgCVUdC7tTzlqRQZeyUwqrtn0SXPK4tPxeG2j3mDiL6ntOenNmjihcse/rA
>> RGqVe3GMsLrZRQiUca5ftH5RyMxAq7Oilhi3c/d5bFMtwnEUPwlUu/Ao3f/Ts2ds
>> 7/nqDRh91B3G7jqfW/EPazT7ymppL0LyCHKq1fmKRYnXv7X0XqLXYp+19iaJE9Xx
>> ZfzYWbjcmY/MdR6aiFvDCKOni7iwYkEFPpXcpDKNcJWq2LAvj07dzC8UK7diWZxH
>> INn6wuUdPcIdELuw52mOK+wDzZL7B1elpHoI99cbc70LJ+zD2z7irkv1tJ/px+qR
>> SGVdo9sNOeARGeofwU72w4OVdY/GcUWSUYf/lEEz4S8dj/Cj74B55nrmgdh94Rhr
>> r7D9M51klNMD7ixFugEYnGEhmSblgVssHZgUFGPyYUnIfe53RT0yV42U8Hnp+EpH
>> /32NFHp8HsiSsi21QYW5
>> =7wSe
>> -----END PGP SIGNATURE-----
>> _______________________________________________
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>