I will give an example of changing innodb_thread_concurrency in MySQL.
Since InnoDB uses operating system threads to process user transactions, the innodb_thread_concurrency parameter allows you to limit them. By default in new MySQL versions the value is 0, which means that there is no limit on the number of simultaneously executed threads and this is correct for modern servers. If you want to limit, then when the limit is reached, the extra threads will wait a certain number of microseconds specified in the innodb_thread_sleep_delay parameter, and then try to get into the queue. Also in MySQL 5.6.3 and higher, the innodb_adaptive_max_sleep_delay parameter was added which allows you to specify the maximum number of microseconds for the innodb_thread_sleep_delay parameter and then InnoDB automatically adjusts innodb_thread_sleep_delay.
Tag Archives: Performance
Performance Tuning Guidelines for Mellanox Network Adapters
Title: Performance Tuning Guidelines for Mellanox Network Adapters
Format: PDF
Revision: 1.17
Size: 901 KB
Language: English
Creating a RAMdisk on Ubuntu
In this article I will give an example of creating a disk in RAM.
Continue reading “Creating a RAMdisk on Ubuntu”Using BNG Blaster
BNG Blaster is a testing tool, it can create thousands of virtual PPPoE and IPoE clients to test the performance of access servers, it also supports IGMP, QinQ, IPv6, etc.
Continue reading “Using BNG Blaster”File mirroring script
Once I needed to make several mirrors in different countries for files that were often downloaded by users, so I made two scripts for synchronization.
Continue reading “File mirroring script”Configuring RPS (Receive Packet Steering)
Receive Packet Steering (RPS) is a software implementation of RSS. Useful for example when there are fewer interrupts on the network interface than the processor cores.
Continue reading “Configuring RPS (Receive Packet Steering)”LACP Link Aggregation on Cisco Nexus 3064
I will give an example of configuring LAG (LACP) on a Cisco Nexus 3064.
Continue reading “LACP Link Aggregation on Cisco Nexus 3064”Moving the MySQL data directory to a new location
In this article I will describe the process of moving the MySQL data directory to a separate location, namely on a level 10 raid with 4 disks, this will increase performance.
Continue reading “Moving the MySQL data directory to a new location”PCI Express ASPM
ASPM (Active-State Power Management) is used to manage the power consumption of PCI Express buses, even if the PCIe device is in use and may affect the device’s response delay.
Continue reading “PCI Express ASPM”Changing gc_thresh on Linux
In this article I will give an example of changing gc_thresh on Linux, this parameter usually needs to be increased on highly loaded access servers.
Continue reading “Changing gc_thresh on Linux”