In this blog post, we’ll discuss the ins and outs of Percona Server 5.7 parallel doublewrite.

After implementing parallel LRU flushing as described in the previous post, we went back to benchmarking. At first, we tested with the doublewrite buffer turned off. We wanted to isolate the effect of the parallel LRU flusher, and the results validated the design. Then we turned the doublewrite buffer back on and saw very little, if any, gain from the parallel LRU flusher. What happened? Let’s take a look at the data:

We see that the doublewrite buffer mutex is gone as expected and that the top waiters are the rseg mutexes and the index lock (shouldn’t this be fixed in 5.7?). Then we checked PMP:

2678 nanosleep(libpthread.so.0),...,buf_LRU_get_free_block(buf0lru.cc:1435),...
867 pthread_cond_wait,...,log_write_up_to(log0log.cc:1293),...
396 …

We recently introduced the Severalnines Blueprint for MySQL Replication, a new whitepaper which discusses all aspects of a MySQL Replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies as ProxySQL, MaxScale and HAProxy.

If you haven’t got your copy yet, do sign up for it here:
Get your free copy of our new whitepaper

The MySQL Replication Blueprint is about having a complete ops-ready solution from end to end including:

• Installation and configuration of master/slave MySQL servers, load balancers, Virtual IP and failover rules
• Management of the topology, including failure detection, failover, repair and subsequent reconfiguration of components
• Managing topology changes when adding, …

Mon, 2016-05-09 08:26Guillaume Lefranc

Some of the most common questions asked by our users are regarding MariaDB support in Docker, and in particular how it can be used in specific development or production deployments. This series of articles will try to cover a few Docker and MariaDB use cases.

Why choose Docker for MariaDB?

• Docker containers can be used to test, deploy and release applications within any environment.
• Docker deployments can be automated easily, creating deployment environments and reproducing them easily in staging and production.
• Docker is lightweight virtualization. Hypervisors are not needed, and a MariaDB Docker container should perform just as well as a normal MariaDB installation without any noticeable overhead.
• Docker is agnostic - once you’ve installed Docker on your OS, the instructions for running containers are …

Before data insertion, updates, deletes etc, database management systems that support foreign keys (like MySQL) make sure you do not introduce any inconsistencies. So, you need to make sure you're not leaving orphan records behind in child tables.

you can set multiple database connections in same laravel application Laravel provide configration file for setup multiple database connections you can see configdatabasephp file and see mysql multiple database connections you can add setting another mysql database detail like this waystrong

In this post i want to share you how to solve tokenmismatchexception error on ajax request time in laravel application When i was working on my ecommerce website in laravel 5 I was found like bellow errorpreNetworkError 500 Internal Server Error httplearnl52hdgetProductTokenMismatc

Sometimes you may need to remove packages from your laravel application I mean if you installed package but you dont need now and that useless in your project you want to remove that useless package from your project that you remove using laravel composer command In this posts i am going to g

you can set multiple database connections in same laravel application Laravel provide configration file for setup multiple database connections you can see configdatabasephp file and see mysql multiple database connections you can add setting another mysql database detail like this waystrong

This example is make using jqueryuijs library We may always need to jquery dialog box in our project because modal is very interesting and specially for GUI Always we like to use modal for creating data or editing data and also for conformation So if you think how to set modal in my project the

In this blog, we’ll examine how CPU governor performance affects MySQL.

It’s been a while since we looked into CPU governors and with the new Intel CPUs and new Linux distros, I wanted to check how CPU governors affect MySQL performance.

Before jumping to results, let’s review what drivers manage CPU frequency. Traditionally, the default driver was “acpi-cpufreq”, but for the recent Intel CPUs and new Linux kernel it was changed to “intel_pstate”.

To check what driver is being used, run the command

cpupower frequency-info

 .

cpupower frequency-info
analyzing CPU 0:
driver: acpi-cpufreq
CPUs which run at the same hardware frequency: 0
CPUs which need to have their frequency coordinated by software: 0
maximum transition latency: 10.0 us.
hardware limits: 1.20 GHz - 2.00 GHz
available frequency steps: 2.00 GHz, 2.00 GHz, 1.90 GHz, 1.80 GHz, 1.70 GHz, 1.60 GHz, 1.50 GHz, 1.40 GHz, …