May 23, 2012

Post: The perils of InnoDB with Debian and startup scripts

…=O_DIRECT. We could also tune the OS, but in my experience that’s not as effective when… be needed. And that’s where the Debian startup script breaks down entirely, because it doesn’t follow…find yourself fighting with it. You can just put “exit 0;” at the top. The solution I chose in this case? mysql

Post: MySQL Consulting - Being on your own

MySQL Consultant. I however found out I would need to spend pretty much all the time traveling, which could notMySQL knowledge. MySQL themselves are searching for them, Google is searching for them, Yahoo is also on lookout not to mention many startupsMySQL patches and do some general script

Post: MySQL Crash Recovery

MySQL Shutdown is unexpected and there could be various inconsistences. And this is not only problem as we’ll see. MySQLscript which moves out all MyISAM tables out of MySQLnot store index cardinality in tables, instead it computes them on first table access after startup

Post: SHOW INNODB STATUS walk through

…previously could find in SHOW INNODB STATUS, there are however few which were not available …to have, if you’re writing scripts to look at SHOW INNODB … each of connections for MySQL there will be ether not started state if … number of rows operation since system startup as well as average values. This…