How to Optimize MySQL Performance Using MySQLTuner

Running MySQL at optimal settings for specific resources helps handle larger server loads and prevents server slowdown. Generally, after tuning Apache to handle larger loads, it is beneficial to tune MySQL to additional connections. Database tuning is an expansive topic, and this guide covers only the basics of editing your MySQL configuration. Large MySQL databases […]

Read More →
10 essential performance tips for MySQL

As with all relational databases, MySQL can prove to be a complicated beast, one that can crawl to a halt at a moment’s notice, leaving your applications in the lurch and your business on the line. The truth is, common mistakes underlie most MySQL performance problems. To ensure your MySQL server hums along at top […]

Read More →
How To Install and Secure phpMyAdmin on Ubuntu 16.04

Introduction While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the system solely from the MySQL prompt. phpMyAdmin was created so that users can interact with MySQL through a web interface. In this guide, we’ll discuss how to install and secure phpMyAdmin so that […]

Read More →
How To Measure MySQL Query Performance with mysqlslap

Introduction MySQL comes with a handy little diagnostic tool called mysqlslap that’s been around since version 5.1.4. It’s a benchmarking tool that can help DBAs and developers load test their database servers. mysqlslap can emulate a large number of client connections hitting the database server at the same time. The load testing parameters are fully […]

Read More →
How do I… Stress test MySQL with mysqlslap?

The mysqlslap utility makes it possible to benchmark and compare MySQL performance on different hardware, as well as accurately quantify the effect of a change in database design. This tutorial shows how you can use mysqlslap to run tests involving multiple clients, custom queries, different table engines, and much more.

Read More →
Réplication MySql Croisée

I► Nous allons voir dans cet article comment mettre en place une réplication croisée MySql en optimisant donc la répartition des charges et la sécurisation des données. Pour des raisons de simplicité, nous testerons cette config sur le même serveur en utilisant mysqld_multi ( référez vous aux précédents articles )   Voici le fichier de […]

Read More →
Les différents moteurs de stockage de MySQL: MyISAM

II. Le moteur MyISAM Licence : GPL Version de MySQL : Depuis la version 3.23, MyISAM a remplacé le moteur ISAM Type : Moteur Non transactionnel. Domaines d’application : – Recherche FULL-TEXT (texte intégrale). – Tables en lecture seule. – Tables de Log. Information : Documentation officielle de MyISAM II-A. Description Depuis sa création, il […]

Read More →
Les différents moteurs de stockage de MySQL: InnoDB

X. Le moteur InnoDB Licence : GPL niveau 2. Société InnoBase, filiale depuis 2005 de la société Oracle. Version de MySQL : Par défaut depuis la version 4.0 de MySQL mais il y est possible de l’installer sur une version 3.23 de MySQL. Type : Transactionnel Domaines d’application : Application nécessitant une fiabilité de l’information […]

Read More →