Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 91 to 100 of 34043 10 Older Entries
Take the long view on the MySQL PERFORMANCE_SCHEMA with ps_history and sys_history
+1 Vote Up -0Vote Down

The performance_schema is a powerful tool for analyzing MySQL performance and behavior. One aspect of the performance_schema is that the view of the data is "right now", and very little historical information is present. You can see that there are 10 threads connected right now, but what about five minutes ago?

ps_history
ps_history is a set of stored routines and events for periodically collecting the data in the performance_schema into another schema called ps_history. The ps_history schema contains a copy of each performance_schema view as a real table, and timestamp and server_id …


  [Read more...]
BACKUP SERVER command for MySQL with Query Rewrite Pre-Parse Plugin
Employee_Team +0 Vote Up -0Vote Down

Few times I heard from MySQL users, customers and Sales consultants about their wish to have SQL command, allowing to backup MySQL server. I asked why calling mysqbackup or mysqldump does not work for them and these people had reasons. One of them is security: this way you don't need to give shell access to MySQL server for the person who is supposed to do backup.

MySQL does not have such a command, except for MySQL Cluster. There are instead multiple programs which can make backup if run externally, such as mysqlbackup of mysqldump.

That time I wrote a UDF which runs any external command ( …



  [Read more...]
Operationalizing TokuDB
+0 Vote Up -0Vote Down

In my previous post, I talked about implementing multi-threaded replication (MTR) using Percona Server 5.6. The server pairs that are utilizing MTR are also exclusively using the TokuDB storage engine.

I find TokuDB to be a fascinating engine. I can tell I will need to re-watch our Dbhangops session where Tim Callaghan talked about the differences …

  [Read more...]
Multithreaded Replication to the Rescue
+0 Vote Up -0Vote Down

Recently, I set up several new database pairs for our backend search team to use. After bringing them online, the search team began backfilling data by writing to the A-side. A bit later, I noticed that replication had started falling behind, maxing out at ~1000 inserts/second.

There isn’t too much unusual about these servers. They run Percona Server 5.6.19 to take advantage of the TokuDB storage engine option …

  [Read more...]
Free Webinar! What Should I Monitor, and How Should I Do It?
+0 Vote Up -0Vote Down

Monitoring tools offer alerts based on thresholds and time-series charts of status counters, but they do not tell us what we should monitor. On Tuesday, February 10th at 2 PM EST, Baron Schwartz will discuss the guiding principles needed to answer these questions.

The following questions will be answered:

  • What status counters from MySQL are central and core, and which are peripheral?
  • What is the meaning of MySQL status metrics?
  • Which subsystems inside MySQL are the most common causes of problems in production?
  • What is the unit of work-getting-done in MySQL, and how can you measure it?
  [Read more...]
MySQL-next = Drizzle 5 years ago?
+0 Vote Up -0Vote Down

With JSON functionality, alternate protocols (HTTP, memcache), a move towards saner defaults and crash safety, pluggable logging etc it really looks like MySQL is following what we did in Drizzle years ago, which is great!

Making High Performance MySQL's New Website
+0 Vote Up -0Vote Down

I recently updated the High Performance MySQL website to modernize it. I am impressed at how easy it is these days to get a great little brochure site hosted. It used to be a lot more work. I used a variety of tools and services to do this and decided to share this for people who are interested. Hopefully you’ll add comments and point me towards more tools and tips to make these things even easier for me in the future!

Before

The website used to be a WordPress blog. This used to be my go-to solution for everything. It used to be the easiest way to whip together something …

  [Read more...]
MySQL Fabric — Three Node High Availability Server Farm
Employee +1 Vote Up -0Vote Down

So how do you use MySQL Fabric to set up a Highly Available Server Farm? The last two postings in this series were on installing Fabric on a master and then setting up slaves. Now it is time to get get the Fabric Farm started.

The Fabric controller is node number 1 and the slaves are 10, 20, and 30 at IP 10.10.13.1, 10, 20, and 30 respectively. I am keeping with the last octet of the IP addresses for clarity. I am trying to recreate the Fabric Farm from this image.

On the 10, 20, and 30 systems we need to add the following to the mysld section of the my.cnf
[mysqld]
binlog-format=ROW



  [Read more...]
MySQL Community Awards 2015: Call for Nominations!
+1 Vote Up -0Vote Down

The 2015 MySQL Community Awards event will take place, as usual, in Santa Clara, during the Percona Live MySQL Conference & Expo, April 2015.

The MySQL Community Awards is a community based initiative. The idea is to publicly recognize contributors to the MySQL ecosystem. The entire process of discussing, voting and awarding is controlled by an independent group of community members, typically based of past winners or their representatives, as well as known contributors.

It is a self-appointed, self-declared, self-making-up-the-rules-as-it-goes committee. It is also very aware of the importance of the …

  [Read more...]
Percona Server 5.6.22-72.0 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Server 5.6.22-72.0 on February 6, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories.

Based on …

  [Read more...]
10 Newer Entries Showing entries 91 to 100 of 34043 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.