Here’s an interesting slide deck from Jay at MySQL, which shows some very simple concepts to take into account when looking at MySQL performance.
http://www.slideshare.net/techdude/how-to-kill-mysql-performance?src=related_normal&rel=366335
This is how to update a field in Mysql where you just want to change the value e.g. for testing etc.
UPDATE resources
SET name=(
REPLACE (name,
‘TestFile’,
‘OldTestFile’));
This will set any field in the column ‘name’ in the table resources to OldTestFile* from TestFile* if it has TestFile as part of its record. e.g. TestFile1.pdf will end up [...]
MySQL :: MySQL 5.0 Reference Manual :: 18 INFORMATION_SCHEMA Tables.
Useful link for metadata about mysql databases. Equivalent to the V$ tables in Oracle.
Continue reading about MySQL :: MySQL 5.0 Reference Manual :: 18 INFORMATION_SCHEMA Tables
Variables that affect MyIsam/innodb performance:
http://www.mysqlperformanceblog.com/2006/06/08/mysql-server-variables-sql-layer-or-storage-engine-specific/
Unfortunately, not updated since 2003.
http://cocoamysql.sourceforge.net/
but free - and effective!
There’s also navicat, but it costs…
Mysql report generates reports on mysql variables, status for performance/management.
Basically, it provides an easy-to-read report of the
SHOW /*!50002 GLOBAL */ STATUS;
command in mysql (which is what you have to do to guarantee return of ‘global’ rather than session variables as they changed the default with some version. <sigh>
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html
Download here:
http://hackmysql.com/mysqlreport
Continue reading about Mysql report - reports on mysql itself