Daily Archives: July 18, 2011

MySQL’s Missing SHUTDOWN Statement

Databases are more easily managed if all operations and logging are available to DBAs and scripts at the SQL client command line. So an additional improvement to MySQL would be to add a SQL command like Oracle’s SHUTDOWN. This shouldn’t … Continue reading

Posted in MySQL, Open Source, Oracle, Tech | Leave a comment

Perl DBD::mysql Administrative Functions

I was flipping through O’Reilly’s High Performance MySQL and noticed something handy on page 519 … $dbh->func(‘shutdown’,’admin’); You can call 4 mysql_* C API functions from within Perl scripts using DBD::mysql, that are also exposed in mysqladmin: $ perldoc DBD::mysql … Continue reading

Posted in MySQL, Open Source, Perl, Tech, Toys | Leave a comment