I don't have a definitive answer but I got curious and found this.
http://forums.admon.org/databases/8130-error-1018-hy000-cant-read-dir-errno-24-a.html
So maybe there is an issue where files are not closing properly.
...and restarting mysql reset the open files counter?
or something like that?
Hi Nick:
On Mon, Jan 03, 2011 at 10:15:50AM -0500, Nicholas Hart wrote:
> I am trying to configure mysql to use a different datadir than default in
> order to move this to a larger volume.
Don't forget about the "innodb_data_home_dir" and
"innodb_log_group_home_dir" settings, though this probably
On Mon, Jan 3, 2011 at 1:38 PM, William Klein wrote:
> If it’s just the data path it’s very easy to just make a symbolic link to
> the new volume in the default directory. That way you can even have
> different databases on different volumes.
>
Ack. While that may be "easy" in some cases,
If it's just the data path it's very easy to just make a symbolic link to
the new volume in the default directory. That way you can even have
different databases on different volumes.
From: Nicholas Hart [mailto:nh...@partsauthority.com]
Sent: Monday, January 03, 2011 10:16 AM
To: talk@lists.
Nick,
Just off the top of my head a few questions:
1. what is the output of mysqld -help (same error?)
2. what is the output of show variables like 'open_files_limit'
3. did you reload your apparmor profile?
However my best guess, based on what you wrote, is that you need to add your
db path
I am trying to configure mysql to use a different datadir than default in
order to move this to a larger volume. I have copied all mysql data from
/var/lib/mysql to my new volume and ran both chown -R mysql:mysql * and
chmod -R 660 * in order to setup correct ownership and rights for the
data. I
