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

DBMS client applications need to store SQL query results in local memory or local files. The format is flat and the fields are ordered -- that's "serialization". The most important serializer format uses human-readable markup, like

and the important ones in the MySQL/MariaDB world are CSV (what you get with SELECT ... INTO OUTFILE or LOAD INFILE), XML (what you get with --xml or LOAD XML), and JSON (for which there are …

  [Read more...]
How to stop offending queries with ProxySQL
+0 Vote Up -0Vote Down

This blog discusses how to find and address badly written queries using ProxySQL.

All of us are very good in writing good queries. We know this to always be true!

But sometimes a bad query escapes our control and hits our database. There is the new guy, the probie, who just joined the company and is writing all his code using SELECT * instead of WHERE. We’ve told him “STOP” millions of times, but he refuses to listen. Or a there is a new code injection, and it will take developers some time to fix and isolate the part of the code that is sending killing queries to our database.

The above are true stories; …

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

Percona announces the GA release of Percona Server 5.7.14-7 on August 23, 2016. Download the latest version from the Percona web site or the Percona Software Repositories.

Based on MySQL 5.7.14, including all the …

  [Read more...]
ConFoo Montreal 2017 Calling for Papers
+0 Vote Up -0Vote Down

ConFoo Montreal: March 8th-10th 2016

Want to get your web development ideas in front of a live audience? The call for papers for the ConFoo Montreal 2017 web developer conference is open! If you have a burning desire to hold forth about PHP, Java, Ruby, Python, or any other web development topics, we want to see your proposals. The window is open only from August 21 to September 20, 2016, so hurry. An added benefit: If your proposal is selected and you live outside of the Montreal area, …

  [Read more...]
Budapest MySQL Meetup
+0 Vote Up -0Vote Down

I just created the Budapest MySQL Meetup group. I hope there will be interest for that, the first event is under organising.  Check it if you are near Budapest!   Share This:

Register for Part 1 of our MySQL Query Tuning Trilogy
+0 Vote Up -0Vote Down

Remember to join us Tuesday, August 30th for the first part of our upcoming webinar trilogy on MySQL Query Tuning. This first of three in-depth webinar sessions led by Krzysztof Książek, Senior Support Engineer at Severalnines, covers MySQL query tuning process and tools.

When done right, Tuning MySQL queries and indexes can increase the performance of your application and decrease response times. We will be covering this complex topic over the course of three webinars of 60 minutes each, so …

  [Read more...]
Web-scale MySQL back in the day
+0 Vote Up -0Vote Down

I spent a few years at Facebook where I was extremely busy helping to make MySQL better at web-scale. I worked a lot with Domas. He found so many problems and I helped fix them along with a few others (the MySQL db-eng team was small). Domas made it easy to understand what was broken and there was a lot of low-hanging fruit. This slide deck is one perspective on what we did. I doubt I have the energy to go through another few years like that, but it was a great time. The timing was also right as there were many people at Oracle/MySQL pushing to make MySQL scale on modern hardware.

Percona Server 5.6.32-78.0 is now available
+0 Vote Up -0Vote Down

Percona announces the release of Percona Server 5.6.32-78.0 on August 22nd, 2016. Download the latest version from the Percona web site or the Percona Software Repositories.

Based on …

  [Read more...]
Magicbricks Migrates to MariaDB to Support its High Volume Traffic
+0 Vote Up -0Vote Down

Mon, 2016-08-22 22:40Guest

The following is a guest blog post from Subodh Kumar, head of technology at Magicbricks, India's largest online property portal.

To support our growing online traffic, Magicbricks migrated from a proprietary database to MariaDB (version 10.1.x).

With this migration, we’ve re-factored our application architecture to separate read and write database calls. This has allowed us to load balance our heavy read calls across multiple instances of Slaves without any worries of lag during data syncs.

Using MariaDB, we are now …

  [Read more...]
What to measure when running a team - part 2
+0 Vote Up -0Vote Down


Yesterday I wrote a blog on some metrics I like to start with when running a delivery team. 


There are two items that I missed in blog.

  1. Building the right thing
  2. Checking those metrics



"Building the thing right" is not "building the right thing"
@mysqldbahelp nice write up. I think they cover "are we building the thing right" but need others for "are we building …








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

Planet MySQL © 1995, 2016, 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.