By JortK on March 22, 2010
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. [...]
Posted in MySQL | Tagged MySQL
By JortK on March 8, 2010
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 [...]
Posted in MySQL, php | Tagged google, maps, markers, MySQL, php, sql, tricks, tutorials
By JortK on February 25, 2010
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 [...]
Posted in MySQL | Tagged datawarehouse, MySQL
By JortK on February 19, 2010
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 [...]
Posted in MySQL | Tagged innodb, MySQL, performance
By JortK on February 11, 2010
Posted in MySQL | Tagged MySQL
By JortK on February 11, 2010
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 [...]
Posted in MySQL | Tagged blob, innodb, MySQL, storage
By JortK on February 10, 2010
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 [...]
Posted in MySQL | Tagged caching, MySQL, tips, tricks
By JortK on February 9, 2010
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 [...]
Posted in MySQL | Tagged benchmark, cast, error, join, monitor, MySQL, query, tutorial
By JortK on February 8, 2010
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 [...]
Posted in MySQL | Tagged MySQL, oracle
By JortK on January 27, 2010
CakePHP Authsome Authentication for people who hate the AuthComponent.
Posted in MySQL, php | Tagged cakephp, database, design pattern, development, factory method, framework, MySQL, objects, oop, php, pivot, variables