Hardware upgrade incoming
Monday, November 17. 2008
In a few hours the MobMap server will be unavailable for a short period of time (I hope it's only for 15-30 minutes, might extend to an hour though as I want to use this planned downtime for some software updates) because of an hardware upgrade. Databases like lots of RAM, and the latest content additions in WotLK pushed the size of my database near the current memory limitations of the machine. So in order to keep upload parsing performance at max I have to throw some new hardware at this problem :o)
[edit] The upgrade went well, only about 20 minutes of downtime.
[edit2] And it not only ensures enough space for the database to grow, but it also allowed me to expand my a-little-unusual-but-freakin-fast-RAMdisk-strategy, increasing the queries per second from an average of 2.300 qps to 3.400 qps (yes, that's more than three thousand SQL queries per second on standard consumer-grade hardware - anybody here who wants to claim that MySQL is slow?) with even more space to grow - I'm thinking about putting almost all the tables where data is being written to into RAM now that I have enough of it. Maybe I'll then be able to sustain those 11.000 qps peaks...
[edit3] Oh cool, my query speed monitoring seems to be a bit off. For some reason which I still have to investigate it doesn't count all the queries. MySQL itself says it's running at an average of 8.800 queries per second right now :D Now that's FAST!
[edit] The upgrade went well, only about 20 minutes of downtime.
[edit2] And it not only ensures enough space for the database to grow, but it also allowed me to expand my a-little-unusual-but-freakin-fast-RAMdisk-strategy, increasing the queries per second from an average of 2.300 qps to 3.400 qps (yes, that's more than three thousand SQL queries per second on standard consumer-grade hardware - anybody here who wants to claim that MySQL is slow?) with even more space to grow - I'm thinking about putting almost all the tables where data is being written to into RAM now that I have enough of it. Maybe I'll then be able to sustain those 11.000 qps peaks...
[edit3] Oh cool, my query speed monitoring seems to be a bit off. For some reason which I still have to investigate it doesn't count all the queries. MySQL itself says it's running at an average of 8.800 queries per second right now :D Now that's FAST!
