Engineering threads within a Data Node
A new version of the white paper “Guide to Optimizing Performance of the MySQL Cluster Database” has been released; download it here.
This paper steps you through:
Things are definitely a little quieter here in MariaDB land as many people embark on summer vacations to rest and recharge. However we will be at OSCON 2012. We have a booth in the non-profit/projects pavilion, amazing amounts of schwag, and the famous black vodka that Monty always brings with him. We plan to have a BoF on Thursday evening (come to D135 at 8pm), and we will be at the MySQL BoF on Wednesday evening as well, just for good measure.
Come say hi. Come tell us how you’re using MariaDB. Come tell us what you want from MariaDB. Come tell us why you switched. Or what we can do to make you switch. It should be all round fun.
See …
[Read more]Thanks to the great work from Nizam with excellent advice from Domas, peak IOPS for compressed InnoDB pages is much better with the Facebook patch compared to official MySQL 5.1.52. But once again performance is even better in official MySQL 5.6. See the previous note for more details on the tests. I can get 80,000 to 90,000 page reads per second for compressed InnoDB tables assuming very fast storage. The binaries tested are:
I’m leaving myself some room for bug fixes. It works for us in house. I would love to help others to give it a try. especially those who could benefit from making nearly immediately answered queries to the NIST’s NVD database.
The code in this release cannot by itself track the feed from the feds in real time. The nvd entry loader needs a little bit of love in the area of record merging before this starts working. It’s on my TODO list.
I’m sorry for the outage of git.colliertech.org. I’ll get that back up here shortly. In the meantime, feel free to grab it from this location while the CPAN indexes and processes my submission.
http://www.colliertech.org/federal/NIST/NIST-NVD-1.00.00.tar.bz2
don’t forget to check the cryptographic signature:
…
[Read more]After several months of hard work we are proud to announce a new release of XAMPP for Windows and Linux.
The most important updates are: Apache 2.4.2, MySQL 5.5.25a, PHP 5.4.4, and phpMyAdmin 3.5.1.
After this release we will focus again on the Mac OS X version of XAMPP. Sorry, for the delay, we're simply short on man power.
Get the downloads and more details on the platform specific XAMPP project page.
The first annual Latin America MySQL/NoSQL/Cloud Conference was held in Buenos Aires Argentina from June 26-28. Kudos to Santiago Lertora from Binlogic who had the vision for the conference in his country and made it happen. I look forward to the second annual event.
My first presentation was “Improving Performance with Better Indexes”. This presentation details the six steps to SQL performance analysis, Capture, Identify, Confirm, Analyze, Optimize and Verify. An explanation of MySQL EXPLAIN, and working examples to create indexes and better covering indexes in several examples are provided. A production example of a 13 table join is used to detail how covering indexes and partial column indexes can make a dramatic improvement in performance. …
[Read more]
Effective MySQL: Backup and Recovery
Practical Knowledge for Business Continuity
Includes MySQL 5.5 GA, MySQL 5.6 DMR, and MySQL in the
Cloud
Ronald Bradford
Oracle ACE Director
Effective MySQL: Backup and Recovery by Ronald Bradford
232 Pages
Oracle Press
Ronald Bradford has embarked an am ambitious project to write a series of books on various facets of MySQL. The first in the series Effective MySQL: Optimizing SQL Statements arrived last fall. The second in the series, …
[Read more]Are you speaking, attending or exhibiting at MySQL Connect? Banners, buttons and other resources are at your disposal in our attendee toolkit! Some examples below:
Would you like to help promote the event? Some others you can also use:
Our attendee toolkit gives you access to additional MySQL Connect resources such as sample e-mail copies to help generate awareness for your participation.
And, remember you have about 24 hours left to register with the early bird discount and save US$ 500, don’t miss it! Check out …
[Read more]Since I use MySQL for the statistical analysis on a project, I wanted to optimize the database queries and learned a lot about stuff like number theory, set theory and partial sums. I took my MySQL UDF, I've published two years ago, for this purpose and added new functions for a deeper statistical analysis. The project is around for a while, so it's time to share things with the public to start a discussion of how things could be further optimized. The source and a small documentation can be found on Github:
Since I use MySQL for the statistical analysis on a project, I wanted to optimize the database queries and learned a lot about stuff like number theory, set theory and partial sums. I took my MySQL UDF, I've published two years ago, for this purpose and added new functions for a deeper statistical analysis. The project is around for a while, so it's time to share things with the public to start a discussion of how things could be further optimized. The source and a small documentation can be found on Github:
