Skip navigation.

Harold's Home

   Home
  
XML version of this site

PHP Scripts

Index
CLI fun
Mail on 404
HB-NS (NewsScript)

Downloads

Applescripts
APOD to Desktop
Dreamweaver Extensions

Stuff

Writings
Other stuff
Central Grinder

OOOk Default:

VJ stuff
VJ Tools
Bananas
Strippers
Sample Movies

News

Fascinating (but useless) statistics
This is for the server I mostly use at work:
This MySQL server has been running for 32 days, 23 hours, 47 minutes and 39 seconds.
Since its startup, 2,069,359 queries have been sent to the server.

The server hosts 7 sites where databaseaccess is used sparingly.

This is for the server this site is on (shared hosting environment with who knows how many sites):
This MySQL server has been running for 9 days, 0 hours, 19 minutes and 11 seconds.
Since its startup, 15,952,625 queries have been sent to the server.


Like the title says: fascinating but useless. Share your own useless statistics and click on "Show MySQL runtime information" in phpMyAdmin which will show output like above.

If your version of phpMyAdmin lacks this function execute a SQL query that says: "SHOW STATUS". The relevant fields to look for are Questions for the amount of queries and Uptime for the uptime in seconds.

Small update: to quickly convert from seconds to a readable date issue the following command in your Terminal (Perl should be installed):
perl -e 'printf "%d days, %d hours, %d minutes and %d seconds", ( gmtime 701251 ) [7,2,1,0]', where 701251 is the number of seconds.
It will spit back a readable time: 8 days, 2 hours, 47 minutes and 31 seconds.

Show all items | Read all items

About, copyright, privacy and accessibility | Mail