RE: what is stored in /var/lib/mysql_log/ ?
The 2 (possibly more) iblog files are necessary for the inner workings of InnoDB. They do not change in size. They should not (normally) be removed or otherwise tampered with. No useable data is stored there -- that is, they cannot be used for any form of disaster recovery. Tunable things for InnoDB can be found in my.cnf (my.ini). They can be viewed (mostly) via SHOW VARIABLES LIKE 'innodb%'; Current status: SHOW GLOBAL STATUS LIKE 'Innodb%'; SHOW ENGINE INNODB STATUS; All of MySQL (not just InnoDB) needs tmp space for _some_ queries. It is normally not be this same directory, but it is probably harmless if it is. -Original Message- From: walter harms [mailto:wha...@bfs.de] Sent: Sunday, October 28, 2012 2:05 PM To: mysql@lists.mysql.com Subject: Re: what is stored in /var/lib/mysql_log/ ? Am 28.10.2012 21:50, schrieb Reindl Harald: Am 28.10.2012 21:29, schrieb walter harms: hi list, on my system this this directory contains ib_logfile0/ib_logfile1, so far no problem. From the documentation i had the impression that this is everything and the files size should not change. but it seems that immodb also uses this space for temp space, do they make a copy of ib_logfile here ? please provide a directory listing so that anybody get a clue what you are speaking about! sorry, I tend to forget that no everyone has the same configuration :( on my system /var/lib/mysql_log -rw-rw 1 mysql mysql 268435456 Oct 28 19:20 ib_logfile0 -rw-rw 1 mysql mysql 268435456 Oct 19 23:03 ib_logfile1 but i guess i just found what is going on: innodb_log_group_home_dir=/var/lib/mysql_log tmpdir=/var/lib/mysql_log I was always looking for innodb related configuration/problems but i guess the strange files that appeared (and related problems) where perhaps caused by tmpdir :) ntl, thx re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: what is stored in /var/lib/mysql_log/ ?
Am 31.10.2012 17:31, schrieb Rick James: The 2 (possibly more) iblog files are necessary for the inner workings of InnoDB. They do not change in size. They should not (normally) be removed or otherwise tampered with. No useable data is stored there -- that is, they cannot be used for any form of disaster recovery. Tunable things for InnoDB can be found in my.cnf (my.ini). They can be viewed (mostly) via SHOW VARIABLES LIKE 'innodb%'; Current status: SHOW GLOBAL STATUS LIKE 'Innodb%'; SHOW ENGINE INNODB STATUS; Hi Rick, thx for your help. I have found the root cause that was not related to immodb. It was that tmpdir was pointing to the same space. This were no problem for a long time then something happended, the system was optimizing and was running out of space causing a table corruption (why can a failed optimisation cause a table corruption ?) re, wh All of MySQL (not just InnoDB) needs tmp space for _some_ queries. It is normally not be this same directory, but it is probably harmless if it is. -Original Message- From: walter harms [mailto:wha...@bfs.de] Sent: Sunday, October 28, 2012 2:05 PM To: mysql@lists.mysql.com Subject: Re: what is stored in /var/lib/mysql_log/ ? Am 28.10.2012 21:50, schrieb Reindl Harald: Am 28.10.2012 21:29, schrieb walter harms: hi list, on my system this this directory contains ib_logfile0/ib_logfile1, so far no problem. From the documentation i had the impression that this is everything and the files size should not change. but it seems that immodb also uses this space for temp space, do they make a copy of ib_logfile here ? please provide a directory listing so that anybody get a clue what you are speaking about! sorry, I tend to forget that no everyone has the same configuration :( on my system /var/lib/mysql_log -rw-rw 1 mysql mysql 268435456 Oct 28 19:20 ib_logfile0 -rw-rw 1 mysql mysql 268435456 Oct 19 23:03 ib_logfile1 but i guess i just found what is going on: innodb_log_group_home_dir=/var/lib/mysql_log tmpdir=/var/lib/mysql_log I was always looking for innodb related configuration/problems but i guess the strange files that appeared (and related problems) where perhaps caused by tmpdir :) ntl, thx re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: what is stored in /var/lib/mysql_log/ ?
Am 31.10.2012 19:47, schrieb walter harms: thx for your help. I have found the root cause that was not related to immodb. It was that tmpdir was pointing to the same space. This were no problem for a long time then something happended, the system was optimizing and was running out of space causing a table corruption (why can a failed optimisation cause a table corruption ?) because running out of disk space is a condition which is hard to test in any combination and should never happen signature.asc Description: OpenPGP digital signature
RE: what is stored in /var/lib/mysql_log/ ?
Oh, another issue... If you have your disk partitioned, and the tmpdir is pointing to a small partition, you could run out of room for that reason. I sometimes find a tiny boot partition (not a terrible idea), plus partitions for /tmp, /var /usr, and maybe others. (Or C:, D:, etc, if you are that type of person.) Hence, I _dislike_ splitting disks into separate filesystems. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Wednesday, October 31, 2012 11:56 AM To: mysql@lists.mysql.com Subject: Re: what is stored in /var/lib/mysql_log/ ? Am 31.10.2012 19:47, schrieb walter harms: thx for your help. I have found the root cause that was not related to immodb. It was that tmpdir was pointing to the same space. This were no problem for a long time then something happended, the system was optimizing and was running out of space causing a table corruption (why can a failed optimisation cause a table corruption ?) because running out of disk space is a condition which is hard to test in any combination and should never happen
Re: what is stored in /var/lib/mysql_log/ ?
personally i use ONLY vmware-guests for any production servers because HA/Failover and unified managmenent and a really easy way to resize drives for /var/log, /vbar/cache, /tmp and hwatever mountpoint holds data - all seperated from /boot and rootfs so it is no problem to use a own DISk for /tmp or configure the mysql-temp-fodler to a folder on a large enough disk it is really simple to calculate - largest table + 50% for mysqltemp running out of disk space is simply the result of a config mistake or missing to watch growing data Am 31.10.2012 22:13, schrieb Rick James: Oh, another issue... If you have your disk partitioned, and the tmpdir is pointing to a small partition, you could run out of room for that reason. I sometimes find a tiny boot partition (not a terrible idea), plus partitions for /tmp, /var /usr, and maybe others. (Or C:, D:, etc, if you are that type of person.) Hence, I _dislike_ splitting disks into separate filesystems. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Wednesday, October 31, 2012 11:56 AM To: mysql@lists.mysql.com Subject: Re: what is stored in /var/lib/mysql_log/ ? Am 31.10.2012 19:47, schrieb walter harms: thx for your help. I have found the root cause that was not related to immodb. It was that tmpdir was pointing to the same space. This were no problem for a long time then something happended, the system was optimizing and was running out of space causing a table corruption (why can a failed optimisation cause a table corruption ?) because running out of disk space is a condition which is hard to test in any combination and should never happen signature.asc Description: OpenPGP digital signature
Re: what is stored in /var/lib/mysql_log/ ?
Am 28.10.2012 21:29, schrieb walter harms: hi list, on my system this this directory contains ib_logfile0/ib_logfile1, so far no problem. From the documentation i had the impression that this is everything and the files size should not change. but it seems that immodb also uses this space for temp space, do they make a copy of ib_logfile here ? please provide a directory listing so that anybody get a clue what you are speaking about! signature.asc Description: OpenPGP digital signature
Re: what is stored in /var/lib/mysql_log/ ?
Am 28.10.2012 21:50, schrieb Reindl Harald: Am 28.10.2012 21:29, schrieb walter harms: hi list, on my system this this directory contains ib_logfile0/ib_logfile1, so far no problem. From the documentation i had the impression that this is everything and the files size should not change. but it seems that immodb also uses this space for temp space, do they make a copy of ib_logfile here ? please provide a directory listing so that anybody get a clue what you are speaking about! sorry, I tend to forget that no everyone has the same configuration :( on my system /var/lib/mysql_log -rw-rw 1 mysql mysql 268435456 Oct 28 19:20 ib_logfile0 -rw-rw 1 mysql mysql 268435456 Oct 19 23:03 ib_logfile1 but i guess i just found what is going on: innodb_log_group_home_dir=/var/lib/mysql_log tmpdir=/var/lib/mysql_log I was always looking for innodb related configuration/problems but i guess the strange files that appeared (and related problems) where perhaps caused by tmpdir :) ntl, thx re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
