[wp-hackers] set/modify the auto-incrementing ID of the wp_postmeta.
Dion Hulse (dd32)
wordpress at dd32.id.au
Sat Aug 11 07:04:41 UTC 2012
If you're executing the script via a web server, chances are you're
running into a max_execution time or similar timeouts in the server
the most common method to resolve this is to run the script on the
command line, and use set_time_limit(0); (unlimited).
On 11 August 2012 16:48, Haluk Karamete <halukkaramete at gmail.com> wrote:
> Well, I started putting the records in. It puts a 1000 postmeta record
> per second. But it times out every other 800K or so. By the time, it
> finishes, it will time out at least a 100 times! What do you guys do
> in a situation like this. how do you make sure that the PHP script
> does not time out or when it times out, it retriggers itself? What
> technique do you guys use so that you do not find your self giving the
> script a go 100 times manually every 30 min or so?
> This is what I got before the WP she-bang gets loaded.
> set_time_limit (3600);
> But that does not seem to get honored.
> On Fri, Aug 10, 2012 at 8:42 PM, SCOTT TAYLOR <scott.c.taylor at mac.com> wrote:
>> 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).
>>> Bryan Petty
>>> wp-hackers mailing list
>>> wp-hackers at lists.automattic.com
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers