We use MySQL on most of our projects. One of these projects has a an access pattern unlike any other I’ve worked on. Several million records a day need to be written to a table. These records are then read out once at the end of the day, summarised and then very rarely touched again. [...]
Showing Google Maps with many markers in PHP Sometimes you need to display Google Maps with a large number of markers. However, adding too many markers makes the map page load too slow. This article explains how you can use marker cluster feature of the forms map location plug-in to cluster large numbers of markers [...]
One aspect of my positions with Calpont, MySQL, and other companies I’ve worked for has been to interact with the various analysts who cover the database scene. It’s definitely an interesting part of the job, especially when you get to query some of the experts who have been around a long time and are good [...]
As I wrote about 2 years ago the feature of Innodb to store copy of master’s position in Slave’s Innodb tablespace got broken. There is a lot of discussions at the corresponding bug report while outcome of the fix remained uncertain for me (the bug is market duplicate while the bugs it seems to be [...]
I’m running in this misconception second time in a week or so, so it is time to blog about it. How blobs are stored in Innodb ? This depends on 3 factors. Blob size; Full row size and Innodb row format. But before we look into how BLOBs are really stored lets see what misconception [...]
Recently Jay Pipes published great article about lazy connecting and caching which reminded me my post on this matter is well overdue. Let me start with couple of comments about Jays article. First – caching in files should be used with caution. It may be very efficient especially if number of cached objects is small [...]
Conditional joins in MySQL One way to do a “Conditional Join” in MySQL is by using a “LEFT JOIN”. Create a “LEFT JOIN” for each condition and combine the results into one column using an “IF” statement by the “SELECT” expression Monitoring your MySQL errors Great tutorial on how to monitor your MySQL Server for [...]
Ever since Oracle closed on its acquisition of MySQL, the open-source world has been wondering where the code has gone. Many people searched, fruitlessly, for the formerly available MySQL source code. They might have done better to search for Oracle’s point person on MySQL, Ken Jacobs. On Friday, Jacobs announced his resignation from Oracle to [...]
CakePHP Authsome Authentication for people who hate the AuthComponent.