Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.14.

In particular:

• Thanks to Justin Swanhart for pointing out an issue with statistics on partitioned tables - bug #69179. While we marked Justin’s bug as a duplicate, Justin continued to provide commentary on an earlier bug opened, and we appreciate his feedback.
• Justin Swanhart also noticed a change in behaviour in MySQL 5.6 with an assertion raised in InnoDB - bug #70007. We’ve since reverted to the previous behaviour.
• Thanks to Zhai Weixiang, who noticed that InnoDB code intended to only run in debug versions of …

I’m pleased to announce that speakers from Oracle will join the lineup at the Percona Live London 2013 MySQL conference which is November 11 & 12. Percona Live London 2013 features 4 keynotes, 30 breakout sessions, and 7 tutorials by leading MySQL users and technology providers. The full conference schedule is now on the Percona Live London MySQL conference website.

Continuing the collaboration that started with the Percona Live MySQL Conference & Expo 2013 last April, we welcome Tomas Ulin, VP of …

October 1, 2013 By Severalnines

Database vendors regularly issue critical patch updates to address software bugs or known vulnerabilities, but for a variety of reasons, organizations are often unable to install them in a timely manner, if at all. Evidence suggests that companies are actually getting worse at patching databases, with an increased number violating compliance standards and governance policies1.

Patching that require database downtime would be of extreme concern in a 24*7 environment, however most cluster upgrades can be performed online. ClusterControl performs a rolling upgrade of the cluster, upgrading and restarting one node at a time. The logical upgrade steps might slightly differ between the different cluster types. 

Upgrading your Database

In this post, …

MySQL DBAs know that integrating MySQL and a big data solution can be challenging. That’s why I invite you to join me this Wednesday (Oct. 2) at 10 a.m. Pacific time for a free webinar in which I’ll walk you through how to implement a successful big data strategy with Apache Hadoop and MySQL. This webinar is specifically tailored for MySQL DBAs and developers (or any person with a previous MySQL experience) who wants to know about how to use Apache Hadoop together with MySQL for Big Data.

The webinar is titled, “Implementing MySQL and Hadoop for Big Data,” and you can register here.

Storing Big Data in MySQL alone can be challenging:

• Single MySQL instance may not …

The 3rd season of MySQL Marinate begins October 1st! Join the meetup group and RSVP at season 3 to join! You can do the work on MySQL, or if you prefer, MariaDB or Percona.

If you do not have the book yet, you can still do the first week by using the online material from Browse Contents on the OReilly book page for Learning MySQL. There is homework for week 1, see the master list for all the information.

If you would like to learn MySQL from the ground up, consider joining us. This is for beginners If you have no experience with MySQL, or if you are a developer that wants to learn …

#DBHangOps 10/02/13 -- MySQL Utilities from Chuck Bell!

Thanks to everyone who came. Definitely check out the recording below!

Heyo everybody!

Coming up this Wednesday, October 2nd, 2013 at 12:00pm pacific (19:00 GMT) is another exciting #DBHangOps. Join the google hangout to discuss:

• MySQL Utilities from Chuck Bell!

As always, check out the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog post to get a link for the google hangout on Wednesday!

Looking forward to to the discussion with all of ya!

Show Notes:

Check out Chuck Bell's slide deck:

Also be sure to check out Chuck's notes below to help you along!

Fabric Blogs

Here are some links to blogs, etc. on …

What’s up all, here every person is sharing these experience, therefore it’s nice to read this weblog, and I used to go to
see this website every day.

Table space fragmentation has generally 2 origins :

• File System fragmentation : the data file is spread physically on many non contiguous locations on the disk.
• Internal Fragmentation : the data and index pages have “holes” : this happens when  rows are deleted or updated, especially at random.

As a result, performance is affected by table space fragmentation. Data typically takes more space on disk and in memory. The disk is more busy than it should.

File System fragmentation can be detected using the filefrag command on Linux (and similar on different OS). When using MyISAM, MYI files are usually very fragmented on the FS, much more than the MYD files.

ls -al frag
total 883304
drwx------  2 aadant common      4096 Sep 30 18:41 .
drwxr-xr-x 17 aadant common      4096 Sep 30 18:59 ..
-rw-rw----  1 aadant common …

Here are examples comparing MySQL 5.6 against PostgreSQL 9.3 Core Distribution, where MySQL seems to comply with "standard SQL" more closely than PostgreSQL does. The examples are also true for MariaDB 10.0 so whenever I say "MySQL" I mean "MySQL and/or MariaDB". When I say "more closely" I do not mean that MySQL is completely compliant, or that PostgreSQL is completely non-compliant.

Identifiers

Example:

CREATE TABLE          ŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽ (s1 INT); /* 32-character name */
SELECT COUNT(*) FROM information_schema.tables
  WHERE table_name = 'ŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽ';
SELECT COUNT(*) FROM information_schema.tables
  WHERE table_name LIKE LOWER('Ž%');

Result:
PostgreSQL says count(*) is 0. MySQL says it's 1.
Reason:
(1) PostgreSQL maximum identifier length is 63 bytes; MySQL maximum identifier length is 64 …

MySQL Hot Backup Solution: Percona Xtrabackup.

http://krishcon.com/blogs/20131231/Xtrabackup-Setup-Hot-backup-solution-mysql

Tags: Percona Xtrabackuphot backupbackupCategory: MariaDBBackupMySQL