Login | Register
Help: Searching, Tag Searching, Edit Tags
Votes:
You must be logged in with a MySQL account to vote on Planet MySQL entries. More information on PlanetMySQL voting.
Layout:
Showing entries 1 to 30 of 25647 | Next 30 Older Entries |
Percona is glad to announce the release of Percona Server 5.1.61-13.2 on February 10th, 2012 (Downloads are available from Percona Server 5.1.61-13.2 downloads and from the Percona Software Repositories).
Based on MySQL 5.1.61, including all the bug fixes in it, Percona Server 5.1.61-13.2 is now the current stable release in the 5.1 series. All of Percona ‘s software is open-source and free, all the details of the release can be found in the 5.1.61-13.2 milestone at Launchpad.
The full release notes can be
[Read more...]Percona is glad to announce the release of Percona XtraBackup 1.6.5 on 10 February, 2012 (Downloads are available here and from the Percona Software Repositories).
This release is purely composed of bug fixes and is the current stable release of Percona XtraBackup.
There are some important bug fixes around incremental backups, parallel backups and backups on databases with the system tablespace being multiple files. The full release notes and details are available here: www.percona.com/doc/percona-xtrabackup/release-notes/1.6/1.6.5.html
After completing my recent ‘downloads‘ page (similar to my ‘changelogs‘, ‘documentation‘, and ‘server variables‘ pages), it occurred to me that I should add a ‘bugs‘ page as well.
So, I’ve added a bug page, which has links to the main bug listing/reporting pages for MySQL, MariaDB (Aria), Drizzle, Percona Server (XtraDB), Xtrabackup, Sphinx, MONyog, and SQLyog (thus far).
Bug Page:
www.chriscalender.com/?page_id=876
Hope this helps.
(And feel free to drop me a line if you have any suggestions.)
A couple of users of our very popular MySQL Configuration Wizard have submitted feedback such as “I’d love to input my existing server settings and get suggestions on how to improve it.”
This sounds like it would be great, doesn’t it? We’ve considered doing this, and even partially implemented it. But during our pre-release testing, we found a lot of potentially serious problems with the idea. It turns out to be very subtle — perhaps too subtle to be done with any computer program, no matter how smart, because there might be a lot of assumptions it’s forced to make, which could turn out to be dangerous. Every approach we considered carried a high risk of de-optimizing a server so it performs worse than before.
So in the end, although our tool
[Read more...]I just wanted to share my steps for building MariaDB 5.3 on Windows. (Note, this is not much different than the instructions Wlad posted here).
But, things are not always so smooth, and of course I ran into a couple small issues, so I wanted to share my outputs plus those issues and their solutions (once again many thanks go to Wlad!) for those out there who might encounter the same.
Here are the steps to build:
cd C:\mariadb-5.3
mkdir bld
cd bld
cmake .. -G "Visual Studio 9 2008"
cmake --build . --config relwithdebinfo --target package
* By making a sub-dir named ‘bld’ and cd’ing into it, you’ll keep
I have been attempting to be better about letting folks in the general MySQL world know when the videos from the Boston MySQL User Group are up. We have a great group, with anywhere from 20-50 attendees each month, and the speakers are always great, even when the group asks some tough questions.* Thanks to the generous donation of time that Richard Laskey puts in editing the videos, there are 2 videos I can share with you:
Ivan Zoratti of SkySQL presented MySQL HA Reloaded at the December MySQL Boston Users Group. Slides are online at www.slideshare.net/izoratti/ha-reloaded-11261643
Tim Callaghan of Tokutek presented Fractal Tree Indexes -- Theoretical Overview and Customer Use Cases at the January
[Read more...]Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th at the Santa Clara, CA convention center. Early bird pricing ends March 12th, 2012.
Use code PL-pod and save 10% off the early bird prices!. Check out the tutorial and session schedule!
SkySQL and MariaDB Solutions Day on Friday, April 13th, 2012 in Santa Clara, CA.
read more
Good books on databases are rare. So permit me to step out of my normal MySQL-centric role and review a new book that is very good and covers a lot of generic relational database territory while also teaching the basics of Oracle 11g. I would estimate that 10% of the book is 11g and the rest would be valuable to new DBAs of other database systems. Besides, seeing how other databases perform some tasks differently may spur you to improve your own.
OCA Oracle Database 11g: SQL Fundamentals I: A real-world Certification Guide
Author: Steve Reis
Database books are hard to write. Databases are not warm, easy to understand and the many concepts can require a student on the subject to concentrate on many obtuse factors all at one time. Presenting the material in a clear and concise fashion
[Read more...]An annual tradition of the upcoming MySQL user conference is the awards ceremony. Last year we introduced the opportunity for everyone in the community to nominate candidates and this was a big success. Now is the time to start nominating deserving winners for the awards for 2012, in the 3 categories named below.
The winners will be selected by a community panel (see below) and winners will be announced on Wednesday, April 11th at the Santa Clara Convention Center, as part of the evening Community Reception.
Please send in your suggestions for deserving winners
to: mysql.awards@gmail.com
no later than: 23:59 Sunday February 29th (Pacific time)
read more
I was searching around and was pleasantly surprised when I ran across this new MySQL Troubleshooting book by Sveta Smirnova:
“MySQL Troubleshooting – What To Do When Queries Don’t Work”
shop.oreilly.com/product/0636920021964.do
Having worked with Sveta in Support for years, I’m certain this book is chock-full of great troubleshooting techniques and advices (and you can get a good idea from the “Table of Contents” listed on the above page).
I’m always happy to see new MySQL-related books.
Congratulations, Sveta!
explain select a from test order by b;
+----+-------------+-------+-------+---------------+------+---------+------+---------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+-------+---------------+------+---------+------+---------+-------------+
| 1 | SIMPLE | test | index | NULL | b | 5 | NULL | 3263769 | Using index |
+----+-------------+-------+-------+---------------+------+---------+------+---------+-------------+
explain select a,c from test order by b;[Read more...]
+----+-------------+-------+------+---------------+------+---------+------+---------+----------------+
| id |
At yesterdays MySQL Tech Tour in Dallas, a gentleman asked how to not only partition data but also store the indexes on other disks as a way of reducing I/O contention on drives.That struck a chord with me and I was soon looking up the information in the MySQL manual. I remembered there was a way to do this with MySQL 5.6 but I am sure the small screen of my cell phone and the detail level of the documentation did not convery the information as well as I had wished.
The example I tried to show was from the subpartition section of the MySQL manual. If you read 12.1.17 for the CREATE TABLE syntax, you will see how to add DATA DIRECTORY and INDEX DIRECTORY definitions to a partition. I guess the example I remembered got stuck in my brain cache (such as it
[Read more...]