admin on January 23rd, 2009

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

Continue reading about MySQL performance - concepts

admin on November 27th, 2008

JSMIN, The JavaScript Minifier.
This clever little tool will reformat your javascript to reduce its size by approx. 50%. This means that it speeds up the downlod time and removes comments and random spaces etc. This should all mean that page rendering including javascript processing should be a lot faster - not to metion reducing the [...]

Continue reading about Shrink your javascript - speed up your site

admin on September 28th, 2008

Variables that affect MyIsam/innodb performance:
http://www.mysqlperformanceblog.com/2006/06/08/mysql-server-variables-sql-layer-or-storage-engine-specific/

Continue reading about Mysql performance

admin on September 28th, 2008

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