I have problem with these versions of mysql. Few seconds after
start I have tons of log in /var/log/mysql/ which looks like this:
update.61871 update.62874 update.63877 update.64880 update.65883 update.66886
update.67889
update.61872 update.62875 update.63878 update.64881 update.65884 update.66887
update.67890
update.61873 update.62876 update.63879 update.64882 update.65885 update.66888
update.67891
update.61874 update.62877 update.63880 update.64883 update.65886 update.66889
update.67892
update.61875 update.62878 update.63881 update.64884 update.65887 update.66890
update.67893
update.61876 update.62879 update.63882 update.64885 update.65888 update.66891
update.67894
update.61877 update.62880 update.63883 update.64886 update.65889 update.66892
update.67895
update.61878 update.62881 update.63884 update.64887 update.65890 update.66893
update.67896
update.61879 update.62882 update.63885 update.64888 update.65891 update.66894
update.67897
update.61880 update.62883 update.63886 update.64889 update.65892 update.66895
update.67898
update.61881 update.62884 update.63887 update.64890 update.65893 update.66896
update.67899
update.61882 update.62885 update.63888 update.64891 update.65894 update.66897
update.61883 update.62886 update.63889 update.64892 update.65895 update.66898
update.61884 update.62887 update.63890 update.64893 update.65896 update.66899
update.61885 update.62888 update.63891 update.64894 update.65897 update.66900
[EMAIL PROTECTED] mysql]# pwd
/var/log/mysql
[EMAIL PROTECTED] mysql]# ls | wc -l
7420
strace shows
12751 open("/var/log/mysql/err", O_WRONLY|O_NONBLOCK|O_CREAT|O_NOCTTY|O_LARGEFILE,
0666) = 3
12759 open("/var/log/mysql/err", O_WRONLY|O_APPEND|O_CREAT, 0666 <unfinished ...>
12759 open("/var/log/mysql/log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 5
12759 open("/var/log/mysql/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 6
12759 open("/var/log/mysql/update.001", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) =
6
12759 open("./ib_logfile0", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0660 <unfinished ...>
12759 open("./ib_logfile0", O_RDWR|O_LARGEFILE <unfinished ...>
12759 open("./ib_logfile1", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0660 <unfinished ...>
12759 open("./ib_logfile1", O_RDWR|O_LARGEFILE <unfinished ...>
12759 open("./ib_logfile0", O_RDWR|O_LARGEFILE <unfinished ...>
12759 open("/var/log/mysql/isamlog.log", O_RDWR|O_APPEND|O_CREAT|O_LARGEFILE, 0660) =
11
12871 open("/var/log/mysql/log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660
<unfinished ...>
12871 open("/var/log/mysql/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY <unfinished
...>
12871 open("/var/log/mysql/update.002", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660
<unfinished ...>
12877 open("/var/log/mysql/log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 5
12877 open("/var/log/mysql/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 20
12877 open("/var/log/mysql/update.45202", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660)
= 6
12883 open("/var/log/mysql/log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660
<unfinished ...>
12883 open("/var/log/mysql/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY <unfinished
...>
12883 open("/var/log/mysql/update.45203", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660
<unfinished ...>
12887 open("/var/log/mysql/log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 5
12887 open("/var/log/mysql/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 29
12887 open("/var/log/mysql/update.45204", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660)
= 6
12893 open("/var/log/mysql/log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 5
12893 open("/var/log/mysql/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 29
12893 open("/var/log/mysql/update.45205", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660)
= 6
12897 open("/var/log/mysql/log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 5
12897 open("/var/log/mysql/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 29
12897 open("/var/log/mysql/update.45206", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660)
= 6
12903 open("/var/log/mysql/log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 5
12903 open("/var/log/mysql/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 29
12903 open("/var/log/mysql/update.45207", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660)
= 6
[EMAIL PROTECTED] mysql]# ls -l log update.0* err
-rw-r----- 1 mysql mysql 72 2003-08-05 12:25 err
-rw-rw---- 1 mysql mysql 11943223 2003-08-05 12:33 log
-rw-rw---- 1 mysql mysql 59 2003-08-05 12:25 update.001
-rw-rw---- 1 mysql mysql 59 2003-08-05 12:25 update.002
rest of update.XXX files has mysql.mysql and 0 size.
What is going on here? :-(
This is Linux 2.4.20 with xfs as filesystem.
--
Arkadiusz Miśkiewicz CS at FoE, Wroclaw University of Technology
arekmatssedotpl AM2-6BONE, 1024/3DB19BBD, arekm(at)ircnet, PLD/Linux
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
