Thursday, September 3, 2015

MySQL : ERROR 3 (HY000): Error writing file

In one of  my development server my developers not able create a new table from Heidisql Tool.When I checked it, the server seems working fine.

Error is ,  ERROR 3 (HY000): Error writing file './backup/updateSites1.frm'

But when I checked the server disk it is almost full after I cleared the unwanted files they can able to create new table.

Issue because of Disk full so from MySQL could not create new table.



Monday, July 27, 2015

MySQL Can't create a new thread (errno 11)

In one of my MySQL Production server, I have faced an issue that MySQL could not create a new thread.Below the error i got in mysql error log file.

Error : Can't create a new thread (errno 11); if you are not
out of available memory, you can consult the manual for a possible OS-dependent bug

Solution :

1.Check your hardlimit and softlimit for MySQL user in the server.
#ulimit -a mysql

2.Change the threads in OS level,edit the below file and add the bold lines in the file.

#vi /etc/security/limits.conf


  mysql     soft     nofile     30000
  mysql     hard    nofile     30000
  mysql     soft     nproc     30000
  mysql     hard    nproc     30000



Restart MySQL

Then MySQL works fine without any error.

Its happened because of the linux server has limited connections to handle for MySQL user.After increased the value in server the error didn’t occurs.