Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: 4.7.3 - any changes required for MySQL 8.0 compatibility?
That’s crazy enough to work. Love it!
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
Re: 4.7.3 - any changes required for MySQL 8.0 compatibility?
Some (crude) tests:
for ($i = 12000; $i <= 12099; $i++) {
$name = 'managing-editor' . $i;
create_user($name, "{$name}@example.com", $name, "Managing Editor #{$i}", 2);
sleep(1);
}CPU load ticks along at 8-12% (~10% average), real: 1m47.767s, user: 0m6.747s, sys:0m0.040s.
Then, as above with a 2 second sleep…
CPU load ticks along 2-12% in a up-down zigzag motion, real: 3m28.037s, user: 0m6.762s, sys: 0m0.028s.
…and just for fun, as above with a 0 second sleep…
CPU pegged at 100%, real: 0m6.905s, user: 0m6.505s, sys: 0m0.032s.
I’ll experiment with usleep() and see if I can find a balance between performance and time taken.
Visually, three tests. Leftmost is 1 second, middle is 2 seconds and rightmost is 0 seconds.
Offline
Re: 4.7.3 - any changes required for MySQL 8.0 compatibility?
And going wildly off-topic, if I’m generating users and passwords that slowly and I have CPU cycles to spare, I’m tempted to compile a list of hundreds of first names, initials and last names to give each user a ‘real’ name instead of “Managing Editor #437”.
Offline