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”
Once I needed to receive Multicast traffic from different TV providers and from different VLANs, so I had to use access-list in order to correctly transmit the igmp-report from the client to the required VLAN. If Multicast is in only one VLAN, then you can do without access-list.Continue reading “Configuring Multicast on Eltex MES2324B”
Once a user made a call and Asterisk began to display a lot of warnings, and there was also no sound:Continue reading “Solution for warning Asked to transmit frame type ulaw, while native formats is (g729) read/write = ulaw/ulaw”
Once it was necessary to determine which SFP modules are in EPON ports, namely C+ or C++.Continue reading “BDCOM. How to determine which SFP is in the EPON port”
Default value is 1, possible values are 0-2.
0 – Logs are written and flushed to disk once per second. Transactions that have not been flushed out can be lost as a result of a crash.
1 – Logs are written and flushed to disk every time a transaction is committed.
2 – Logs are written after each commit of a transaction and flushed to disk once per second. Transactions that have not been flushed out can be lost in the event of a failure.
I will give an example of changing innodb_read_io_threads in MySQL.
The innodb_read_io_threads value determines the number of I/O threads for read operations in InnoDB. The default is 4, the minimum possible is 1, the maximum is 64.
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)”