Now that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the InnoDB log file size (innodb_log_file_size) setting? In general, there are two settings that simply can’t be left at their historical defaults for a production installation. MySQL 5.5 increased the default buffer pool size to something [...] [...more]
Over last few years I’ve been suggesting more people to disable Query Cache than to enable it. It can cause contention problems as well as stalls and due to coarse invalidation is not as efficient as it could be. These are however mostly due to neglect Query Cache received over almost 10 years, with very [...] [...more]
Over last few years I’ve been suggesting more people to disable Query Cache than to enable it. It can cause contention problems as well as stalls and due to coarse invalidation is not as efficient as it could be. These are however mostly due to neglect Query Cache received over almost 10 years, with very [...] [...more]
Should the Command Line Be Deep-Sixed? In what’s surely a testament to Linux’s increasingly mainstream-ready graphical user interfaces, it seems to be par for the course that every once in a while someone will suggest that there’s no longer any need for the command line. Last week, it happened again. “Is it finally time to [...] [...more]
Novell Calls Should Be Bought Given Odds of Breakup, MKM Says Investors should buy bullish Novell Inc. options to profit from a potential breakup of the maker of Linux operating-system software, which is exploring a sale of its assets, MKM Partners LP said. Read more on BusinessWeek [...more]