In this blog, I will answer questions posed in my recent introduction to MySQL troubleshooting basic techniques webinar.

Thank you for attending my March 10 MySQL troubleshooting webinar “Introduction to MySQL troubleshooting: basic techniques,” which is the second in the “MySQL Troubleshooting Webinar” series. The recording and slides for the webinar are available here. Here is the list of your questions that I wasn’t able to answer during the webinar, with responses.

Q: Any known …

I want to share this posts with you because when i was working on native PHP and Ajax Post requestSpecially AngularJS Post request at that time i cant get Post value on form submit Thats why i would like to share you this post I also want to tell you i was working on my Ubuntu 1404 I did try

When i was working on my Laravel application using git bitbucket repository i fatch problem when first i did commit on my master branch and i think i did 3 or 4 commits and my project partner pull also in his local system but we did wrong code in this commit so we required to remove that 3 or 4 c

Git is distributed version control system that is a awesome when ever you are working with git repository if you did commit your code in your local system by mistake then if you want to remove last commit from your project so lets see following examplestrong classexampleExamplestrong

Codership’s first Galera Cluster for MySQL webinar “hit a home run” in the world series of webinars.  One of the attendees said: “The Webinar was one of the best I have attended.  The fluff was minimized and the tech presentation hit a home run” .

Take a look Codership’s Galera Cluster® for MySQL Installation and Quick Start recorded webinar

http://galeracluster.com/videos/galera-cluster-installation-and-quick-start/

There will be other  Galera Cluster for MySQL webinars coming from the developers and experts of Galera Cluster, so stay tuned.

Galera, Galera Cluster and Galera Replication are registered trademarks of Codership.

This is the second and last tutorial blog post on how to use pt-table-checksum / pt-table-sync tools for MySQL replication.

In the first post, I showed you how to use the

pt-table-checksum

  /

pt-table-sync

  tools in a typical MySQL replication setup. In this post, we’ll discuss MySQL replication for more advanced topologies. I will show you how to use these tools in a chained …

Following the recent post on replication performance and efficiency, I'd like to talk about another MySQL feature that has received some treatment in Aurora: the Query Cache.
We'll first discuss the limitations of "traditional" Query Cache implementation, we will then watch a sysbench read-only test take off and go from 250K reads per second to nearly 650K reads per second, all thanks to the improved Query Cache. Have fun!
Query Cache The MySQL Query Cache is a hugely useful feature that caches the result sets of SELECT statements in memory. It makes perfect sense in typical OLTP applications (especially web apps), where queries are quite repeatable because the same piece of data is often selected multiple times by many clients.
The following performance issues are associated with query cache implementation in vanilla …

How do you dig down into the JSON data, say like in comments on a blog post? This is a badly paraphrased question from Peter Zaitsev of Percona at the end of a recent presentation of mine at the Great Wide Open conference. I have to admit I had not done like that with JSON data but it had to be able to be done, right? Surely it can be done. Can't it? Time to dig. I could not find an example of JSON data on a blog with comments. But the good folks at Mongo had an example of a restaurant with grades.

{
  "address": {
     "building": "1007",
     "coord": [ -73.856077, 40.848447 ],
     "street": "Morris Park Ave",
     "zipcode": "10462"
  },
  "borough": "Bronx",
  "cuisine": "Bakery",
  "grades": [
     { "date": { "$date": 1393804800000 }, "grade": "A", "score": 2 },
     { "date": { "$date": …

In this blog post, we’ll be discussing Percona Server 5.7 performance improvements.

Starting from the Percona Server 5.6 release, we’ve introduced several significant changes that help address performance problems for highly-concurrent I/O-bound workloads. Some of our research and improvements were re-implemented for MySQL 5.7 – one of the best MySQL releases. But even though MySQL 5.7 showed progress in various aspects of scalability and performance, we’ve found that it’s possible to push I/O bound workload limits even further.

Percona Server 5.7.11 currently has two major performance features in this area:

• …

Percona is glad to announce the release of Percona XtraBackup 2.3.4 on March 17th, 2016. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups.

This …