MySQL – Creating stored procedures

Published on Author gryzliLeave a comment

Stored Procedures in MySQL are the typical primer for great ideas and bad implementation. Even that I have stored procedures, because of their performance penalties, recently I had to write one. The procedure itself was very simple, but there were some catchy stages I would like to describe in case I need to write such… Continue reading MySQL – Creating stored procedures

SQL Queries – Cheat Sheat

Published on Author gryzliLeave a comment

Here I will write down some frequently used SQL examples , which I happen to search for again and again.   SELECT records from date column before or after a given DAYS Select all records from a table “some_table” from MORE THAN¬†30 DAYS

          Check mysql users CPU usage

Continue reading SQL Queries – Cheat Sheat

MySQL – ERROR 1273 (HY000): Unknown collation ‘#253’ in table ‘some-table’ definition

Published on Author gryzliLeave a comment

Some background… Recently we’ve made some migrations from Percona MySQL Server 5.1 to MySQL 5.5.   It seems that Percona MySQL Server, have additional collations, which if used will cause problems after migrating to pure MySQL. In my case the problematic collation was: utf8_general50_ci ¬†–> ¬†Corresponding to id #253 in MySQL collations After the migration,… Continue reading MySQL – ERROR 1273 (HY000): Unknown collation ‘#253’ in table ‘some-table’ definition

Magento Performance Optimized Server

Published on Author gryzliLeave a comment

I’ve read some articles on magento performance tuning and server optimization for best result. Here I will try to summarize most of the important stuff I’ve read.   Server Software Magento best practices advice on using the following configuration: Nginx + MySQL + php-fpm (FastCGI) + APC / OpCache + (Varnish) It’s better to use… Continue reading Magento Performance Optimized Server