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]My wife – a good web designer with 6 years of experience with web design, HTML and CSS is looking for a job. Here is some information about her:
We’re physically located in Toronto, Canada, but she has a great experience of working remotely too. So, if you need a web designer or a junior web designer, feel free to contact Tanya.
…
[Read more]Background Knowledge
The Search Plugin for TaskFreak! created by DaDaemon and xdu v0.0.1 (March 26, 2007) was designed to create a simple, quick search capability of the tasks title and description. As well it only searched through he current task view (tasks visible at the time) and tasks that are not completed. For some this was not what was desired and would rather have the Search Plugin search through all tasks weather completed or not and as well search through the comments of tasks along with the title and description. I’ll show you how this is done using Searcher, bchristie and davidlmansfield instructions posted on the TaskFreak! Forums.
Solution – Add the Ability to Search All Tasks
Edit the “index.php” located in …
[Read more]
