As the
Zabbix Ops, we want to
split the large ibdata1 file, so than
we can reduce the obsolete data like history_uint table.
[ jonny@zabbix-server ~ ]
$ ls -lh /var/lib/mysql/ [Enter]
total 16G
-rw-rw---- 1 mysql mysql 16K Aug 15 10:36 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Aug 15 10:36 aria_log_control
-rw-rw---- 1 mysql mysql 15G Aug 15 12:45 ibdata1
-rw-rw---- 1 mysql mysql 5.0M Aug 15 12:45 ib_logfile0
-rw-rw---- 1 mysql mysql 5.0M Aug 15 12:45 ib_logfile1
drwx------ 2 mysql mysql 4.0K Aug 15 10:36 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 15 10:44 mysql.sock
drwx------ 2 mysql mysql 4.0K Aug 15 10:36 performance_schema
drwx------ 2 mysql mysql 6 Aug 15 10:36 test
drwx------ 2 mysql mysql 8.0K Aug 15 13:59 zabbix
▲ We can see the ibdata1 filesize is very large.