innodb_io_capacity – determines the number of write IOPS for background InnoDB tasks, such as flushing pages from a buffer pool, etc. If the cleanup operation is lagging, then InnoDB can perform cleanup more aggressively at a higher IOPS, which is defined in the innodb_io_capacity_max variable.
Continue reading “How to change innodb_io_capacity in MySQL”Author Archives: Vyacheslav
Configuring OSPF in Quagga
I will give a simple example of setting up OSPF in Quagga, for the test I will use Hyper-V with a virtual switch and virtual machines running Ubuntu Server 18.04.
Continue reading “Configuring OSPF in Quagga”Installing and configuring xt_NAT
I will give an example of installing and configuring xt_NAT on Ubuntu Server 14.04 with kernel version 4.4.0-142. xt_NAT may not work on newer kernel versions. According to the developer, it should work on Linux Kernel 3.18 and 4.1. To make it work on newer versions of the kernel, you can find patches.
Continue reading “Installing and configuring xt_NAT”Partitioning tables in MySQL
Partitioning tables in MySQL is splitting a large table into parts according to the specified criteria, which will speed up reading and writing data to it if this table contains a very large amount of data.
Continue reading “Partitioning tables in MySQL”How to change innodb_stats_on_metadata in MySQL
innodb_stats_on_metadata – Lets you collect statistics on metadata operations such as SHOW TABLE STATUS when accessing INFORMATION_SCHEMA.TABLES or INFORMATION_SCHEMA.STATISTICS tables.
In newer versions of MySQL, the innodb_stats_on_metadata parameter is disabled by default, which makes working with these tables faster.
How to upgrade phpBB 3.3.3 to 3.3.4
For example, I will update phpBB version 3.3.3 to 3.3.4.
Continue reading “How to upgrade phpBB 3.3.3 to 3.3.4”Configuring OCSP Stapling
OCSP is a protocol for checking the validity of certificates, that is, to make sure that they have not been revoked and whether they were actually issued. Enabling OCSP Stapling on the web server side allows you to increase the speed of site opening, since the request to the certification authority is made not by the browser, but by the web server.
Continue reading “Configuring OCSP Stapling”How to change default-storage-engine in MySQL
When creating a table, the ENGINE option is used, which specifies the storage engine, if this option is not specified in the SQL query, then the default storage engine is used, which is specified in the MySQL server configuration file or when it starts mysqld –default-storage-engine=InnoDB.
Continue reading “How to change default-storage-engine in MySQL”Teleste Luminato Firmware Update
For example, I will update the firmware on Teleste Luminato with the installed firmware version 5.2.34.
Continue reading “Teleste Luminato Firmware Update”Changing thread_cache_size in MySQL
thread_cache_size – responsible for caching client threads after they are disconnected so that they can be reused, for example, when hundreds of connections are made to the server per second, this parameter can greatly improve performance.
Continue reading “Changing thread_cache_size in MySQL”