I will give an example of resizing the InnoDB buffer pool in MySQL.
Continue reading “Configuring InnoDB Buffer Pool size in MySQL”
In the InnoDB buffer pool, this is the memory space in which indexes, caches, buffers, etc. are stored.
I noticed once on one of the new Ubuntu servers an error when opening phpMyAdmin – “The extension mysqli | mysql not found.”
Continue reading “How to solve “Extension mysqli | mysql not found””
I will give an example of changing the root password for MySQL.
Continue reading “How to change root password for MySQL”
I will give the option of changing the root password of the user for MySQL.
Continue reading “How to reset root password for MySQL”
I will give an example of viewing and increasing the open_files_limit parameter in MySQL.
Continue reading “How to change open_files_limit in MySQL”
Will perform operations in the Ubuntu Server 16.04.
query_cache_type – this parameter enables or disables the operation of MySQL Query Cache.
Continue reading “Changing query_cache_type in MySQL”
table_open_cache – the number of cached open tables for all threads. Opening tables is a resource-intensive process, so it is recommended to keep a certain number of tables open in the cache.
Continue reading “Changing table_open_cache in MySQL”
innotop is a utility for monitoring the status of MySQL server.
I will give an example of installing innotop in Ubuntu. Since innotop is present in mysql-client, we install it and the necessary components:
Continue reading “Installing and using innotop”
Once optimizing one of the servers, I executed the command:
And I saw the following messages:
Continue reading “Solution apparmor=”DENIED” operation=”open” profile=”/usr/sbin/mysqld””
MySQLTuner – This is a Perl script that will give recommendations for improving the performance and stability of the MySQL server.
GitHub Page – https://github.com/major/MySQLTuner-perl
MySQLTuner in Ubuntu can be installed with the command:
sudo apt-get install mysqltuner
In CentOS as follows:
yum install mysqltuner
Continue reading “Installing and using mysqltuner.pl”