Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34031 10 Older Entries
3 handy tools to remove problematic MySQL processes
+0 Vote Up -0Vote Down

DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL server that would impact performance. Long-running queries can be the result of many factors. Fortunately, Percona Server contains some handy tools to remove problematic MySQL processes. I will highlight all of the tools via some examples in this post.

pt-kill:
There have been some good posts on this blog about the pt-kill tool, like this one by Arunjith Aravindan titled “ …

  [Read more...]
OurSQL Episode 205: How to Learn About MySQL
+0 Vote Up -0Vote Down

PodcastsLearning

In this episode, we discuss resources available for learning more about MySQL and its forks.

MySQL Cluster 7.4 is GA!
Employee +2 Vote Up -0Vote Down

The General Availability of MySQL Cluster 7.4 has just been announced by Oracle.

The MySQL team at Oracle are excited to announce the General Availability of MySQL Cluster 7.4, ready for production workloads.

MySQL Cluster 7.4.4 can be downloaded from mysql.com and the …

  [Read more...]
Connector/Python 2.1.1 Alpha released with C Extension
Employee +1 Vote Up -0Vote Down

MySQL Connector/Python 2.1.1 took a while to release and that was because we had to add some more packages which contains the optional C Extension. Note that this is still Alpha and we want you guys to report any problems and requests.

The Connector/Python C Extension was added because in certain situations, for example reading a huge result set, can take a long time with pure Python. That’s why we choose to interface with …

  [Read more...]
Worrying about the ‘InnoDB: detected cycle in LRU for buffer pool (…)’ message?
+1 Vote Up -0Vote Down

If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or later you’ll see the following lines on the server’s error log and chances are you’ll be worried about them:

InnoDB: detected cycle in LRU for buffer pool 5, skipping to next buffer pool.
InnoDB: detected cycle in LRU for buffer pool 3, skipping to next buffer pool.
InnoDB: detected cycle in LRU for buffer pool 7, skipping to next buffer pool.

Worry not as this is mostly harmless. It’s becoming a February tradition for me (Fernando) to face a question about this subject (ok, …

  [Read more...]
See Connection Latency with VividCortex
+0 Vote Up -0Vote Down

Recently, one of our customers reached out to us about a problem they were having trouble diagnosing - they noticed that every once in a while, it took their MySQL server a few seconds to initialize a client connection. They had figured out that the issue was a missing hosts entry for one of their clients, but VividCortex didn’t have any measurements to show this issue to them.

We always enjoy getting customer feedback, and in this case we saw a clear need for something that VividCortex was missing. To address this shortcoming, we’ve recently added the ability to see the connection latency for newly established connections against your …

  [Read more...]
MySQL Cluster 7.4 GA: 200 Million QPS, Active-Active Geographic Replication and more
+3 Vote Up -0Vote Down

The MySQL team at Oracle are excited to announce the General Availability of MySQL Cluster 7.4, in other words - it's now ready for production workloads.

This is a release which takes what was already great about MySQL Cluster (real-time performance through memory-optimized tables, linear scale-out with transparrent sharding and cross-shard joins, High Availability and SQL as well as NoSQL interfaces) and makes it even faster, easier to manage and simpler to run accross geographies.

Team MariaDB is back from SCALE13X - This show keeps getting bigger and better
+1 Vote Up -0Vote Down

Wed, 2015-02-25 19:36Marc Sherwood

Members of Team MariaDB have now all made it home from SCALE13X, held in LA. This year we had three talks. Max, talked about Advanced Query Routing and Proxying with MaxScale, and Sharding Your Data With Spider, while Colin Charles talks …

  [Read more...]
MySQL Webinar: Analyze & Tune Queries for Better Performance
Employee +2 Vote Up -0Vote Down

Thanks to everyone who attended my webinar today, and thanks for all the positive feedback in the Q&A session.  Unfortunately, I was not able to respond to everyone during the 15 minutes available for Q&A.  If your question did not get answered, feel free to use the comments section of this blog post to ask your question.  You can also ask questions on the MySQL Optimizer Forum.
The slides from the presentation are available …

  [Read more...]
Shinguz: MySQL Enterprise Incremental Backup simplified
+1 Vote Up -0Vote Down

Taxonomy upgrade extras: mebMySQL Enterprise BackupenterpriseBackupincremental backup

MySQL Enterprise Backup (MEB) has the capability to make real incremental (differential and cumulative?) backups. The actual releases are quite cool and you should really look at it...

Unfortunately the original MySQL documentation is …

  [Read more...]
Showing entries 1 to 10 of 34031 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.