One may think one may use MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes. In fact however not all the queries are logged. I already mentioned mysql slave queries are not logged to slow query log and it looks like I was wrong […]Read more
I prefer to use Integers for joins whenever possible and today I worked with client which used character keys, in my opinion without a big need. I told them this is suboptimal but was challenged with rightful question about the difference. I did not know so I decided to benchmark. […]Read more
Just found this little handy feature today:
mysql> insert into c select rand()*1000, sha1(rand()) from c;
Query aborted by Ctrl+C
ERROR 1317 (70100): Query execution was interrupted
mysql> insert into c select rand()*1000, sha1(rand()) from c;Query aborted by Ctrl+CERROR 1317 (70100): Query execution was interrupted
So now if you press CTRL-C MySQL Command Line Client will not exit […]Read more
In the previous post I mentioned not all architectures and solutions work for Commodity People, and people seems to agree with me.
Number of vendors would claim they are in Commodity Software or Hardware business but few would probably mention they are doing it for Commodity People, because few people would like to be called […]
Just found this wonderful summary of articles by Jeremy and wanted to give some of my thoughts on the topic.
First lets speak about death of the RAID. I think this is far from the case especially if you consider Software RAID here.
For many workloads you would like to get RAID just […]
This week I already had two serious performance regression cases when upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often see for simple queries due to generally fatter code.
The problem in both cases was MySQL 5.0 broken group commit […]