Softizy, PHP / MySQL Performance Optimization Services.
  • Home
  • Contact
  • About
  • Blog
Home / MySQL Optimizations
May 15, 2017
jocelyn fournier
Case Studies, MySQL Optimizations
5 comments

Performance regression between Percona Server 5.6 & 5.7

I) An upgrade which hasn’t gone as planned One of our customer needed help after trying to upgrade their slave from Percona Server 5.6 to Percona Server 5.7. (here 5.7.17 is used) Indeed, from time to time, the replication lag was linearly growing, which could be quite annoying… (good guess, 5.7 is the red dashed line!) […]

Read More>>
TokuDB Parallel Replication
Aug 15, 2016
jocelyn fournier
MySQL Optimizations
No comments yet

Parallel Replication with TokuDB & MariaDB 10.1

I) What is parallel replication? Parallel replication is a nice feature introduced in MariaDB 10.0, and which allows to run in parallel some queries on a slave. Basically, by default (the conservative mode), it runs in parallel transactions that couldn’t have any conflict. Note you have to enable GTID to use this feature. Starting with […]

Read More>>
TokuDB Fractal Tree
Jul 27, 2016
jocelyn fournier
Case Studies, MySQL Optimizations
28 comments

TokuDB Read Free Replication : not implemented in MariaDB!

I) Why using TokuDB? I have been playing with TokuDB since 2013. Although it’s a really good storage engine, it’s sometimes full of surprises. Initially I migrated one of my customer from InnoDB to TokuDB because it was solving all their issues : their DB has been growing to more then 1TB, and they were facing […]

Read More>>
MySQL Caching Techniques
Jan 12, 2016
jocelyn fournier
MySQL Optimizations
2 comments

Should you disable or enable the MySQL query cache?

I – What is a query cache? The MySQL query cache was introduced as part of version 4.0 of MySQL. Its main function is simple: it is a giant hash table that associates bulk SQL queries with a group of results. It signifies that if you add a space or change a capital letter in your SQL […]

Read More>>
MySQL vs MariaDB
Nov 22, 2015
jocelyn fournier
MySQL Optimizations
10 comments

MariaDB 10.1 vs MySQL 5.7: Real-World Performances

I) The Best Performances Ever ? Let’s have a closer look MariaDB 10.1 and MySQL 5.7 have been officially GAed for a few weeks now, and each company claims to have awesome performances. MariaDB claims that the biggest improvement on its new version is scalability on massively multithreaded hardware, reaching more than 1 million queries per second on […]

Read More>>
Logo prestashop
May 29, 2015
jocelyn fournier
MySQL Optimizations, PHP Optimizations
5 comments

PrestaShop 1.6.1.0: a new level of performances

I) What’s new in PrestaShop 1.6.1.0? A lot of things have been improved on PrestaShop 1.6.1.0 : Design Invoices Search Performance : we have done a lot of work to improve the overall performances of PrestaShop, and reached in some cases a whooping 10x improvement. Let’s now dig into the optimizations we have put in place, […]

Read More>>
Logo mariadb
May 13, 2014
jocelyn fournier
MySQL Optimizations
No comments yet

MariaDB 10: Zoom in on table statistics

I – Table Statistics – Why? When you execute a SQL query that uses an index, creates a join, or another complex operation, MySQL will read the statistics linked to these tables, which will allows it to chose the optimal plan of execution. For InnoDB for example, this behaviour is controlled by innodb_stats_% type variables: show variables LIKE […]

Read More>>

NEWSLETTER

Categories

  • Case Studies
  • MySQL Optimizations
  • PHP Optimizations

Recent Comments

  • Sunisa Sookdee on Performance in Prestashop 1.7: new improvement
  • Alessandro on PrestaShop 1.6.1.0: a new level of performances
  • Marcos Gil Fuertes on PrestaShop 1.6.1.0: a new level of performances
  • Prestarocket on Performance in Prestashop 1.7: new improvement
  • jocelyn fournier on Performance in Prestashop 1.7: new improvement
Softizy, PHP / MySQL Optimization Services

PHP / MySQL Performance Optimization Services.

Contact

Email: [email protected]


2015-2020 © Softizy SARL. All Rights Reserved.