MySQL – Simple ways to avoid filesort
It is bit panic to see ‘Using filesort‘ from the extra field when one runs a explain of select query on MySQL server. At times it is bit annoy why[...]
Monthly Archive: November 2007
iPhone Stocks Ticker – Markets Closed
Since couple of weeks I had a weired issue with the iPhone. The stocks gadget or application powered by Yahoo! Finance always shows “Markets Closed” for almost all the day[...]
Confused MySQL Server
Today I saw a case where MySQL server is writing its binlog entries to the error log file ‘mysqld.err’ instead of writing it to regular binlog. This is happening with[...]
MySQL 5.1 – Broken Read-Only Server
I had a interesting problem from Yahoo! mail team that they were not able to start the 5.1 server at all on couple of their replication setup boxes. They tried[...]
LOAD DATA INFILE – performance case study
I often noticed that people complain about the LOAD DATA performance when loading the table with large number of rows of data. Even today I saw a case where the[...]
MySQL – Large File Support
Today I had an interesting issue from one of the internal property within Yahoo!, where they were not able to start the MySQL server after the server has been upgraded[...]