Stuff…

This looks like a useful mysql tuning script:

http://blog.mysqltuner.com/

Otherwise the mysql.com pages are good for tuning:

http://dev.mysql.com/doc/refman/5.0/en/optimization.html
http://dev.mysql.com/doc/refman/5.1/en/optimization.html

[Read more →]

Had a problem with Magento stores not loading and the following errors were being presented when going to the site.
Error:
SQLSTATE[HY000]: General error: 145 Table ‘./magento/log_visitor_info’ is marked as crashed and should be repaired
Trace:
#0 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `lo…’, Array)
#3 /var/www/vhosts/magento/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(281): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `lo…’, Array)
#4 /var/www/vhosts/magento/httpdocs/lib/Zend/Db/Adapter/Abstract.php(535): Varien_Db_Adapter_Pdo_Mysql->query(‘INSERT INTO `lo…’, Array)
#5 /var/www/vhosts/magento/httpdocs/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(125): Zend_Db_Adapter_Abstract->insert(‘log_visitor_inf…’, Array)
#6 [...]

[Read more →]

URL:

http://www.nikmakris.com/2005/mar/29.html
http://www.xaprb.com/blog/2006/04/14/bad-character-data-in-mysql/ – “How to find and fix invalid character data in MySQL”

update [table_name] set [field_name] = replace([field_name],’[string_to_find]‘,’[string_to_replace]‘);

[Read more →]