query_cache_type – this parameter enables or disables the operation of MySQL Query Cache.
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.
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:
Once optimizing one of the servers, I executed the command: And I saw the following messages:
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: In CentOS as follows:
To see data from one column, it is enough to execute the SQL query (where “abcd” is the name of the column in the table): To export to a file, just run the command in Linux: Here is an example of exporting email addresses from a mysql table to an http page using PHP. The […]
I’ll give an example of specifying or changing the default value in the MySQL column. Let’s see the list of tables in the database: Let’s see the structure of the table we are interested in: Let’s say the activate column has the type date and the default value is 0000-00-00, and we want to make […]
The appropriate solution I found for running MySQL server on specific IP addresses is to run it at all and then filter the connected clients through iptables. For the test, I used Ubuntu Server 16.04.5 LTS, which had more than 200 external white IPs and was highly loaded.
In this article I will give examples of some SQL queries for the base of the ABillS billing system.
It took one day to write a script to add to ipset all the IP for which the session was started on the access server, Abills billing was used, so I decided to take IP addresses from the MySQL billing table. The first step is to create a test ipset: