(Mayank Prasad) performance_schema.setup_actors is a table in MySQL Performance schema which could be used to specify what users/hosts one wants to have instrumentation on for. By default connection from all users and hosts are enabled to be instrumented for.

(Marco Tusa) Nowadays most companies use geographic distributed platforms to better serve their customers. It is quite common to see companies with datacenters in North America, Europe and Asia; each site hosting databases and shared data. In some cases the data is simply spread around for better ac

(Arunjith Aravindan) MySQL Replication is very simple to set up. In this post I’ll discuss its importance and five handy tools for monitoring and managing MySQL replication.

(Ronald Bradford) As discussed in my presentation to NYLUG, I wanted to provide system administrations with some really quick analysis and performance fixes if you had limited knowledge of MySQL.

(Justin Swanhart) JSON is an text based, human readable format for transmitting data between systems, for serializing objects and for storing document store data for documents that have different attributes/schema for each document. Popular document store databases use JSON (and the related BSON) fo

(Mikael Ronstrom) Here is one more additional documentation effort in the MySQL Cluster 7.4 source code. This describes a fairly detailed view of what is performed in the various restart phases of MySQL Cluster and in particular for node restarts.

(Ronald Bradford) Improving the performance of a web system involves knowledge of how the entire technology stack operates and interacts. There are many simple and common tips that can provide immediate improvements for a website. Some examples include:

(Mikael Ronstrom) As part of optimising scan execution by about 50% in MySQL Cluster 7.4 we made an effort to also write down a description of the scan protocol locally within the LDM threads. This is documented in the source code of MySQL Cluster 7.4 and here is an excerpt from the source code.

(Robert Barabas) Have you ever had a case where you needed to find a process which sent a HUP/KILL/TERM or other signal to your database? Let me rephrase. Did you ever have to find which process messed up your night? 😉 If so, you might want to read on. I’m going to tell you how you can find

(Mikael Ronstrom) The below description was added to the MySQL Cluster 7.4 source code and describes how new nodes are added into the heartbeat protocol at startup of a node.