ERROR 1114 (HY000): The table `tbl_name` is full
Possible reason is the partition being full – this is just what happened to me now.
ERROR 1114 (HY000): The table `tbl_name` is full
Possible reason is the partition being full – this is just what happened to me now.
ERROR 1206 (HY000): The total number of locks exceeds the lock table size
The total number of locks exceeds the lock table size. To avoid this error, increase the value of innodb_buffer_pool_size.
Within an individual application, a workaround may be to break a large operation into smaller pieces. For example, if the error occurs for a large INSERT, perform several smaller INSERT operations.
Coming soon!
I always found it a bit tricky doing a clean re-install of MySQL. Here’s some steps I have learned from my experience
Note: this will delete *everything* associated with MySQL on ubuntu, I believe that’s what is meant by a ‘complete uninstall’ to be able to do a fresh installation. (Tested on 10.4 LTS)
apt-get --purge remove mysql-server apt-get --purge remove mysql-client apt-get --purge remove mysql-common
apt-get autoremove apt-get autoclean
I noticed aptitude does a better job of removing dependencies
aptitude remove mysql-client aptitude remove mysql-server aptitude remove mysql-common
apt-cache rdepends mysql-server apt-cache rdepends mysql-client
vi /etc/apparmor.d/usr.sbin.mysqld
rm -rf /etc/mysql
find / -iname 'mysql*' -exec rm -rf {} \;
After all of the above, follow the steps below for a clean install
apt-get install mysql-server mysql-client
service mysql status
and you should get the output
mysql start/running, process 1234
mysqladmin -u root -p status
Recent Comments