<div>
sorry, you can't - unless you want to hack the code to use an rpc call to the server
</div>


sorry, you can't - unless you want to hack the code to use an rpc call to the server

<div>
mmm, well that's seriously dissapointing.
</div>


mmm, well that's seriously dissapointing.

<div>
That worked a treat, once I got 5.0.37 installed, I tried installing the latest 5.0.45 but InnoDB got sglan 11 every time on startup - had to go back to 5.0.37.
</div>


That worked a treat, once I got 5.0.37 installed, I tried installing the latest 5.0.45 but InnoDB got sglan 11 every time on startup - had to go back to 5.0.37.

<div>
<div class="content wysiwyg-content">
I have a multi-step MySQL stored procedure that takes a little while to run, and I would like to find out which statements need optimizing. Is there a way to find the current time in mill or microseconds in MySQL so I can output some simple profiling info.<br />
<br />
Thanks,<br />
d.
</div>
</div>


I have a multi-step MySQL stored procedure that takes a little while to run, and I would like to find out which statements need optimizing. Is there a way to find the current time in mill or microseconds in MySQL so I can output some simple profiling info.

Thanks,
d.

How to retrieve the current time in fractions of a second in MySQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.