Hello everyone.
I have already tried several times to try to find the error myself, but I only fell that insted of reaching the solution, I am getting more lost.
My zabbix is having slow problems when reading the database, and with that I found the solution of partitioning my database, since this solution seems to be very good for this problem I have. I started looking for what it was and how to do it, I found a guide on how to achieve it.
Everything was fine in the beginning, I made a test database in case I have errors that do affect my other database. I partitioned the tables: history, history_uint, history_str, history_text, history_log, trends and trends_uint. In all these tables they gave me their dates, only the one in history_log came out NULL, but I didn't give it any importance. From here I started to partition from its last dates to these days and everything was fine, the problem started when I tried to enable the Perl scripts, downloaded its script, gave it its editing privileges, I even did the MySQL/login part (I'm not sure about $dsn=DBI:mysql:'.$db_schema.':mysql_socket=/var/lib/mysql/mysql.sock' ; since I can't find it).
I did the time thing and everything else, but when I run the script "perl /usr/share/zabbix/mysql_zbx_part.pl" it gives me the error:
"DBI connect('zabbix:mysql_socket=/var/lib/mysql/mysql.sock','zabbix' ,...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/share/zabbix/mysql_zbx_part.pl line 42." and I just don't understand.
P.S. I am keep checinkg for solutions, and the problem shows when I run the perl script, so probably it might be the location of my DB, but can find the .sock file.
Any generous person who can help me?
Nice day.
I have already tried several times to try to find the error myself, but I only fell that insted of reaching the solution, I am getting more lost.
My zabbix is having slow problems when reading the database, and with that I found the solution of partitioning my database, since this solution seems to be very good for this problem I have. I started looking for what it was and how to do it, I found a guide on how to achieve it.
Everything was fine in the beginning, I made a test database in case I have errors that do affect my other database. I partitioned the tables: history, history_uint, history_str, history_text, history_log, trends and trends_uint. In all these tables they gave me their dates, only the one in history_log came out NULL, but I didn't give it any importance. From here I started to partition from its last dates to these days and everything was fine, the problem started when I tried to enable the Perl scripts, downloaded its script, gave it its editing privileges, I even did the MySQL/login part (I'm not sure about $dsn=DBI:mysql:'.$db_schema.':mysql_socket=/var/lib/mysql/mysql.sock' ; since I can't find it).
I did the time thing and everything else, but when I run the script "perl /usr/share/zabbix/mysql_zbx_part.pl" it gives me the error:
"DBI connect('zabbix:mysql_socket=/var/lib/mysql/mysql.sock','zabbix' ,...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/share/zabbix/mysql_zbx_part.pl line 42." and I just don't understand.
P.S. I am keep checinkg for solutions, and the problem shows when I run the perl script, so probably it might be the location of my DB, but can find the .sock file.
Any generous person who can help me?
Nice day.