• drapeau français
  • System administration (8)
  • Database (12)
  • Diverse (1)
  • Development (21)

Using Explain function of MySQL to optimize query

  • Jun 14, 2022
  • Database
  • MariaDB, Performance, MySQL
MySQL logo

When database queries are slow a good approach is to use EXPLAIN to get the execution plan of the queries. But the result is not always obvious. In this post I show you how I use EXPLAIN to solve a real performance issue. Read the post

How Doctrine2 ORM killed the benefit of my cache to relieve my database

  • Feb 9, 2022
  • Development
  • Performance, PHP, Symfony, Doctrine
Doctrine logo

Today I tell you a little story about MariaDB and Doctrine2 sinking and how Redis, coming to save them, sinks them even faster. Feedback on my setbacks with Redis and Doctrine2 hoping to relieve a MariaDB out of breath. Read the post

Alter table in MySQL and MariaDB without locking table with Percona Toolkit

  • Oct 17, 2018
  • Database
  • Linux, MariaDB, Performance, MySQL
MySQL logo

Alter table operation can be a very long task, depending on your database. It's often that database administrator wait too run these operations and do it late in the night to avoid disturbing user. But solutions exist to allow alter table without locking table, pt-online-schema-change from Percona Toolkit is one of these solutions. Read the post

Share

Search

Recent posts

  • Index document in Elasticsearch using PHP library: elasticsearch-php
  • Manage Elasticsearch indices with elasticsearch-php library
  • Using Behat to write functional test of a Symfony command

Tags

Debian Doctrine Fail2ban Jenkins Linux MariaDB Security MySQL Performance PHP PhpMyAdmin OOP RabbitMQ Backup Shell Symfony VIM Elasticsearch Ansible