For many people this will be old news, but I guess It thought I should put up something official. At the end of September, I left MySQL/Sun/Oracle – that wasn’t an easy decision, mostly because I loved my job. It’s difficult to stop doing something that you enjoy so thoroughly and, over the years, have been so involved in. I did more than just get involved in the docs, I helped out with advice for different departments, worked on areas like DTrace, and of course helped write the documentation and enhanced many of the tools that enabled us to build such brilliant documentation. I managed to work with some amazing people, most of all the rest of my team who worked so hard to produce the manuals and content. The impetus to leave came from an opportunity to work with another excellent team on a different database, namely CouchDB. CouchDB reminds me of my early database work working on freeform text databases, with a nice open and easy structure, …
[Read more]For many people this will be old news, but I guess It thought I should put up something official.
At the end of September, I left MySQL/Sun/Oracle – that wasn’t an easy decision, mostly because I loved my job. It’s difficult to stop doing something that you enjoy so thoroughly and, over the years, have been so involved in. I did more than just get involved in the docs, I helped out with advice for different departments, worked on areas like DTrace, and of course helped write the documentation and enhanced many of the tools that enabled us to build such brilliant documentation. I managed to work with some amazing people, most of all the rest of my team who worked so hard to produce the manuals and content.
The impetus to leave came from an opportunity to work with another excellent team on a different database, namely CouchDB. CouchDB reminds me of my early database work working on freeform text databases, with a nice open and …
[Read more]Another piece of good news for MySQL 5.5 – the output of SHOW ENGINE INNODB STATUS has now been increased from 64kB, to 1MB. For those running with systems that have thousands of running transactions, or large lock outputs, it should take quite a bit more to force truncation now.
We also added a new status variable to track when truncation happens as well – innodb_truncated_status_writes, so you can detect this should you have automated monitoring depending on this output.
Leading up to my previous post, I had been doing some work to start the integration of PERFORMANCE_SCHEMA data with MySQL Enterprise Monitor, including some new graphs based on some of the data that I talked about in the above post..
A picture tells a thousand words:
This is only scratching the surface - more to come, watch this space!
Share and Enjoy:
[Read more]| We all (at least majority of us) use some sort of maps to reach from one destination, say home, to another destination, say a shopping mall or a convention center. But once you've reached the mall then you switch to a different set of tools to navigate that is typically either a paper flyer or sign boards within the mall. Micello.com fills that gaps by providing maps for any indoor locations like airport, shopping malls, convention centers, retail centers, and college campus. |
Their application is built using "scalable stack" of GlassFish
and MySQL, uses RESTful Web services, and has given them a 99.9%
uptime in the past few months - no wonder its used to create
indoor maps for 50 malls in Singapore. Listen …
| We all (at least majority of us) use some sort of maps to reach from one destination, say home, to another destination, say a shopping mall or a convention center. But once you've reached the mall then you switch to a different set of tools to navigate that is typically either a paper flyer or sign boards within the mall. Micello.com fills that gaps by providing maps for any indoor locations like airport, shopping malls, convention centers, retail centers, and college campus. |
Their application is built using "scalable stack" of GlassFish
and MySQL, uses RESTful Web services, and has given them a 99.9%
uptime in the past few months - no wonder its used to create
indoor maps for 50 malls in Singapore. Listen …
| We all (at least majority of us) use some sort of maps to reach from one destination, say home, to another destination, say a shopping mall or a convention center. But once you've reached the mall then you switch to a different set of tools to navigate that is typically either a paper flyer or sign boards within the mall. Micello.com fills that gaps by providing maps for any indoor locations like airport, shopping malls, convention centers, retail centers, and college campus. |
Their application is built using "scalable stack" of GlassFish
and MySQL, uses RESTful Web services, and has given them a 99.9%
uptime in the past few months - no wonder its used to create
indoor maps for 50 malls in Singapore. Listen …
While not as well known as the Google or Facebook patches the TiVo mysql patch includes some changes that make monitoring and query optimization a bit easier than mainline MySQL. The modified tarball, available at http://www.tivo.com/mysql/ contains a modified mysqld_safe, mysqldump, and improvements to the row statistics show commands that came from google.
mysqld_safe modifications
–fallback-ledir
The –ledir option tells mysqld_safe which directory contains the
mysqld file that it should use. TiVo has added the
–fallback-ledir option which will switch the ledir should mysqld
crash. This makes it possible to run a new mysqld binary then
fallback to the stock one should the new one crash. This feature
has never been called to duty in production but it makes me sleep
better.
–crash-script
This is a new option to mysqld_safe which will execute a script …
If you want to know more about MySQL and MariaDB plugins read below. Our (Andrew Hutchings and mine) book MySQL 5.1 Plugins Development was just published by Packt. As far as I know it’s the first and the only book completely dedicated to MySQL Plugin API. It covers all existing in 5.1 plugin types, from Daemon to Storage Engines, and does not shun from explaining less known or poorly understood features of the plugin API. It describes newer plugin API extensions too – such as authentication plugins and recent CREATE TABLE extension. Also …
[Read more]
There are plenty of bad things in the world. But I guess there is nothing that has such a drastic and dangerous impact on my life that software patents. If patents are good thing in other industries can be discussed, but in the software industry its a clear cut thing: they hurt innovation, they hurt small businesses and they scare the shit out of me. And if you are a software developer, they should scare the shit out of you too! Now Oracle decided as the first big company that is not just a patent troll to actually sue a company over software patents. heck maybe others have sued before, but lets stop this behavior right here right now. We must send a clear message. We must send a clear message to Oracle that they better stop. And we must send a clear message to any other company holding software patents that they better not think of suing. I …
[Read more]