Jun 01, 2007 09:32
but I have found new excitement in massive databases.
Now if only I can convince people that ps -auxww won't tell you why Java/Tomcat is running at 140%, only that it is running at 140%.
> select count(ACCOUNT_ID) from ACCOUNT \G
*************************** 1. row ***************************
count(ACCOUNT_ID): 10683139
1 row in set (7.56 sec)
> select count(*) from SCREENINGS \G
*************************** 1. row ***************************
count(*): 61905220
That's not a bad amount at all.
mysql