At 12:01 -0400 9/19/02, Jamie Beu wrote: >Whenever I run a command from the MySQL prompt, The command executes and >outputs the time to process the command. >However, if I put the same command in a script file, and run it in batch >mode from the shell prompt (or even use SOURCE from the mysql prompt), >I do not get the same timing info.
That's because when mysql runs in batch mode, it disables a lot of the interactive mode output. Run it with the -vvv option and you'll get the information you're looking for. > >I want to run some benchmark tests, but I need precision greater than 1 sec >(the automatic timing output from MySQL is to the hundredth of a second, >which will suffice). > >Please help. I am not using PHP at all - just sourcing MySQL query scripts. > >Jamie Beu >Lockheed-Martin Information Systems >Software Engineer >CTIA >(407) 306-2484 > >"The true soldier fights not because he hates what is in > front of him, but because he loves what is behind him." >G. K. Chesterton - Illustrated London News, 1/14/11 > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
