Tabulas got moved to a separate database server (it's no longer shared with anybody). Unlike the old DB server, this one has 2GB RAM (up from 512MB) and uses SATA hard drives (instead of EIDE) so iowait should be low. I've been surfing through Tabulas, and it seems LOADS faster. The server's been up for roughly six hours now and it hasn't even GROANED in speed yet. Some fun statistics from mySQL:

  • Bytes sent per hour: 250MB
  • Queries per second: 101.48
  • Open tables: 141
  • Opened tables: 165
  • Key reads: 76314
  • Key read requests: 24601631

I've gotten to be relatively mediocre at modifying my.cnf (mySQL configuration file which handles the memory management), so the configuration is pretty optimal right now. The key reads/key read request ratio isn't quite optimal yet, but it's something I can work on.

mySQL's query caching (yes, I *just* upgraded to mySQL 4.0) seems to be working nicely as well.

w00t.

Currently listening to: Destiny's Child - Bootylicious
Posted by roy on March 13, 2006 at 01:09 AM in Tabulas | 7 Comments

Related Entries

Want to comment with Tabulas?. Please login.

Comment posted on March 13th, 2006 at 07:14 PM
Nicely done, Roy!

Now, about your avatar...
Comment posted on March 13th, 2006 at 07:25 PM
Haha. your icon and my new icon make me laugh.
Comment posted on March 14th, 2006 at 06:54 PM
lol... yours scared me! Either it has gas, or it's one freakin' happy goat!
Comment posted on March 13th, 2006 at 06:48 PM
Thanks Roy -- it seems to be zipping along great. ;-)
Comment posted on March 13th, 2006 at 02:30 PM
I understand the words, but not the meaning of those words...
Comment posted on March 13th, 2006 at 09:25 AM
That's all well and good, but where's your next Tabulas manifesto?
Comment posted on March 13th, 2006 at 06:41 PM
I'm going to hold off on it for a few more days (coincide with Tabulas' birthday on March 16th, and the pre-pre-release of the new Taublas control panel).