[wp-hackers] set/modify the auto-incrementing ID of the wp_postmeta.

SCOTT TAYLOR scott.c.taylor at mac.com
Sat Aug 11 03:42:02 UTC 2012


change the storage engine to InnoDB so you won't have table-level locking

For fun, test some Meta Queries - they are the slowest part of WP

On Aug 10, 2012, at 7:38 PM, Bryan Petty <bryan at ibaku.net> wrote:

> On Fri, Aug 10, 2012 at 5:25 PM, Haluk Karamete <halukkaramete at gmail.com> wrote:
>> Is it possible to internally set/modify the auto-incrementing ID of a
>> mysql table, specifically the wp_postmeta?
> 
> Yes, "ALTER TABLE wp_postmeta AUTO_INCREMENT = ###", however, I would
> still just recommend you backup the database, run your test, and then
> restore from the backup instead. It's easier, probably quicker, and
> works the same way nearly every time no matter what you're testing
> (unless it also involves files on disk).
> 
> Regards,
> Bryan Petty
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers


More information about the wp-hackers mailing list