sound like files of a replication slave or master and that is why you should post details and folder-listings in the first posting to hep understand waht you are speaking about
[root@srv-rhsoft:~]$ ls /data/db/mysql-srv/ | grep bin -rw-rw---- 1 mysql mysql 12M 2013-03-22 19:44 bin.000001 -rw-rw---- 1 mysql mysql 14M 2013-03-23 13:36 bin.000002 -rw-rw---- 1 mysql mysql 153M 2013-03-27 20:33 bin.000003 -rw-rw---- 1 mysql mysql 102 2013-03-23 13:38 bin.index [root@srv-rhsoft:~]$ cat /data/db/mysql-srv/bin.index /mnt/data/db/mysql-srv/bin.000001 /mnt/data/db/mysql-srv/bin.000002 /mnt/data/db/mysql-srv/bin.000003 [root@srv-rhsoft:~]$ cat /etc/my.cnf | grep bin log-bin = /mnt/data/db/mysql-srv/bin.log log-bin-index = /mnt/data/db/mysql-srv/bin.index Am 27.03.2013 20:25, schrieb Arnold: > There are files beginning with 1.<sequence number>. The sequence number is > 000001 to 000015. A new file is created every time MySQL is restarted. The > 1.index file contains a list of these files. One thing that I have done is > when I was hardening the security we stopped MySQL and moved the data > directory to a directory called /var/lib/db/mysql. I changed the datadir > variable in the my.cnf file to point to this directory. This was to be sure > that our data directory was not on the same partition as our SYSTEM or the > Log partitions. Everything is working fine except I have the files mentioned > above. > > -----Original Message----- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Wednesday, March 27, 2013 3:14 PM > To: mysql@lists.mysql.com > Subject: Re: *.index files in MySQL Data directory > > > > Am 27.03.2013 19:53, schrieb Arnold: >> What are the *.index files in the MySQL Data directory? I notice a new one >> is created every time that MySQL is stopped and restarted. My Data >> directory is not in the default location so does that have anything to do >> with it? > > maybe a "ls -lha" of a sample would be nice > > never seen one of them from MySQL 3.x to 5.5 nor with MariaDB, indexes are > .MYI
signature.asc
Description: OpenPGP digital signature
