1
vote
1answer
434 views

Measure query execution time in bash

I need to measure a query total execution time from inside a bash script. Somebody told me to submit something like: mysql --user="someuser" --password="pw" -D "dbname" -e 'your-sql-command;' Is ...
3
votes
3answers
583 views

MySQL CURTIME() is always 00:00:00

I have a MySQL server installed on Solaris 10u8. Until recently, everything was working fine. Then all of a sudden, the current time according to MySQL is always 00:00:00. CURDATE() seems to work fine ...
1
vote
2answers
963 views

How do I make sure that BOTH my server and MYSQL have the same timezone?

Because when I create a time in Python scripts..I want it to match MYSQL's time. How do I make BOTH of them pacific time?
1
vote
3answers
288 views

CPU/Mem/Disk utilization (average) after process has completed

Ubuntu Server 9.10 So there is the time command which will show you the time it took for a specific process/command to run after the command has completed. For example: :~$ time ls real 0m0.020s ...
1
vote
1answer
433 views

How do I change my MYSQL timezone to be permanent Pacific time?

so that when I do now(), it will show the current California time?