Comments on: Self throttling MySQL queries https://shlomi-noach.github.io/blog/mysql/self-throttling-mysql-queries Blog by Shlomi Noach Wed, 07 Mar 2012 05:16:57 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/self-throttling-mysql-queries/comment-page-1#comment-74244 Wed, 07 Mar 2012 05:16:57 +0000 https://shlomi-noach.github.io/blog/?p=4294#comment-74244 @Rick,
for DELETEs I provide with oak-chunk-update, as part of the openark-kit.

I’m also going to integrate this into QueryScript.

]]> By: Rick James https://shlomi-noach.github.io/blog/mysql/self-throttling-mysql-queries/comment-page-1#comment-74137 Tue, 06 Mar 2012 21:15:01 +0000 https://shlomi-noach.github.io/blog/?p=4294#comment-74137 Hmmm… I may want to incorporate you technique in my web page on how to do big deletes:
http://mysql.rjweb.org/doc.php/deletebig

You discussed SELECT, but in applying this to write operations, be aware issues with SYSDATE() in a replication situation:
http://bugs.mysql.com/bug.php?id=15101
(I have not tested.)

As for MICROSECONDs, most people have to wait for SYSDATE() (or whatever) to provide microseconds. The manual (even for 5.0) claims that SYSDATE() “Returns … YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context”, but it does not work on 5.1.

]]> By: Contest for Glory: write a self throttling MySQL query | code.openark.org https://shlomi-noach.github.io/blog/mysql/self-throttling-mysql-queries/comment-page-1#comment-60257 Thu, 24 Nov 2011 18:28:44 +0000 https://shlomi-noach.github.io/blog/?p=4294#comment-60257 […] Self throttling MySQL queries […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/self-throttling-mysql-queries/comment-page-1#comment-57296 Tue, 01 Nov 2011 08:31:34 +0000 https://shlomi-noach.github.io/blog/?p=4294#comment-57296 @sbester,

Technically, you can use:
TIMESTAMPDIFF(MICROSECOND, start, end)/1000000.0
The syntax is accepted in MySQL.

In MariaDB this should actually work (I never tried).

You will get a letter of condolences for not winning the Glory award.

]]> By: sbester https://shlomi-noach.github.io/blog/mysql/self-throttling-mysql-queries/comment-page-1#comment-57295 Tue, 01 Nov 2011 08:22:43 +0000 https://shlomi-noach.github.io/blog/?p=4294#comment-57295 i got stuck on the potential sub-second requirement quite a bit.. only way i thought it possible was getting it from the uuid() but it got too messy and i gave up 🙂

]]>