Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34033 10 Older Entries
MySQL Replication and GTID-based failover - A Deep Dive into Errant Transactions
+0 Vote Up -0Vote Down

For years, MySQL replication used to be based on binary log events - all a slave knew was the exact event and the exact position it just read from the master. Any single transaction from a master may have ended in different binary logs, and in different positions in these logs. It was a simple solution that came with limitations - more complex topology changes could require an admin to stop replication on the hosts involved. Or these changes could cause some other issues, e.g., a slave couldn’t be moved down the replication chain without time-consuming rebuild process (we couldn’t easily change replication from A -> B …

  [Read more...]
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...]
Showing entries 1 to 10 of 34033 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.