The output from SHOW INNODB STATUS isn’t very pretty or easy to use. Seriously, other than Heikki who thinks in 16k block sizes? A few lines of bash magic fixes this problem. Now I can quickly see buffer pool stats in the following format: buffer pool size: 27999076352 bytes (27G) used: 16563568640 bytes (16G) (59.00%) [...]
Categories: mysql
I want a new command in MySQL/InnoDB to freeze all filesystem activity in InnoDB… until I unfreeze it? Why? I want mysqlhotcopy semantics for InnoDB. Right now you can run FLUSH TABLES WITH READ LOCK and then xfs_freeze but it’s not very efficient or easy to code, and it’s pretty fragile. INNODB FREEZE should not [...]
Categories: mysql
Oddly enough the announcement of the constituent replicator coincides with some MySQL replication problems we’ve been feeling over the last couple of weeks. … so here are some more thoughts and feature suggestions: – get this in Drizzle. From what I understand they ripped out replication since the code wasn’t as elegant as the Drizzle [...]
Categories: mysql
For the last few weeks we’ve been running with the Split-LRU patch and 2.6.25. So far so good…. our boxes don’t seem to page as much anymore and we’re no longer suffering from swap insanity – which essentially fixes the Linux swap problem. However, it now seems that we’ve been hit by two additional swap [...]
Categories: linux
Looks like Cuil might be hitting websites too hard with their crawler: “I don’t know what spawned it, but when Cuil attempts to index a site, it does so by completely hammering it with traffic,” the tipster wrote. “So much, that it completely brings the site down. We’re 24 hours into this “index” of the [...]