The innodb_write_io_threads value determines the number of I/O threads for writing to InnoDB. The default is 4, the minimum possible is 1, the maximum is 64.Continue reading “How to change innodb_write_io_threads in MySQL”
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.
Once I installed FreeRadius 3.0.23, by the way I described the process in the article: ABillS. Installing Freeradius, and optimized some parameters of the MySQL server, after which FreeRadius stopped starting and I saw errors in the logs:Continue reading “FreeRadius. error solution rlm_sql_mysql: Couldn’t connect to MySQL server”
In this article, I will provide an example of setting up MP3 for Music on hold (moh) in Asterisk.Continue reading “Asterisk. MP3 for Music on hold (moh)”
Size: 1.74 Mb
Last modified: July 2016
Once in one organization, old cash registers were used that were connected via COM port emulators and after automatic Windows updates, a new version of the COM port emulator driver was installed, after which it was displayed with an exclamation mark and stopped working, so it was necessary to prohibit the driver update.
Windows Pro and Enterprise have the ability to block driver updates through the Group Policy Editor (gpedit.msc). In this article I will show you how to do this.
max_allowed_packet is the maximum size of data that can be transferred in one request. Increase the value when the “Packet too large” error occurs so that the connection is not interrupted.
The default value for MySQL client is 16 MB, for MySQL server 64 MB.
For example, I will telnet to the BDCOM P3310C and reboot the ONU.Continue reading “BDCOM. How to reboot ONU”
Title: Performance Tuning Guidelines for Mellanox Network Adapters
Size: 901 KB
Name: Eltex Operation Manual
Version: 1.25 (30.04.2021)
Size: 8.52 MB