Separate server for MySQL database - how to save traffic and speed up the application
If you have a busy project, and the database server is located on a separate physical machine from the application, I recommend that you enable data compression between the application and the database.
The picture shows a clear example of the network load curve. Until 18:00, compression was disabled, at 18:00 - enabled.
')
The CPU graph is as follows:
On mysqlperformanceblog, a benchmark is described using the example of Sphinx.
In PHP, using mysql_connect is enabled with the "MYSQL_CLIENT_COMPRESS" flag.
The picture shows a clear example of the network load curve. Until 18:00, compression was disabled, at 18:00 - enabled.
')
The CPU graph is as follows:
On mysqlperformanceblog, a benchmark is described using the example of Sphinx.
In PHP, using mysql_connect is enabled with the "MYSQL_CLIENT_COMPRESS" flag.
Source: https://habr.com/ru/post/167823/
All Articles