I run a Perl program on a test run of about 4 hours and my database
connection expired/broke down.
Here is the error I got :
DBI connect('project','root',...) failed: Can't connect to local MySQL
server through socket '/var/lib/mysql/mysql.sock' (2) at
/usr/local/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI.pm line 840
DBIx::Class::ResultSet::find_or_create(): DBI Connection failed: Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(2) at Test.pm line 239
Interestingly enough , that was about 18:07 and looking at
/var/log/mysqld.log at 18:07 I see
13583 090503 18:07:03 [Note] /usr/libexec/mysqld: Normal shutdown
13585 090503 18:07:04 InnoDB: Starting shutdown...
13586 090503 18:07:06 InnoDB: Shutdown completed; log sequence number 0
I am not into configuration issues of mysql but could you please help me
to configure it so that it
doesn't behave this way ?
I should mention that the shutdown was not due to a command of mine , I
was walking in the park when that happened actually.
Also if you can , please tell me the configurations you've made for that
not to happen so I can replicate them on my test machine also(not mouse).