Category Archives: MySQL

MySQL ERROR 1114 (HY000): The table `tbl_name` is full

ERROR 1114 (HY000): The table `tbl_name` is full

Possible reason is the partition being full – this is just what happened to me now.

The total number of locks exceeds the lock table size in MySQL

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.

MySQL – High Availability on Linux using DRBD and Heartbeat

Coming soon!

How to Completely Uninstall MySQL on Ubuntu

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)

a) Using apt

apt-get --purge remove mysql-server apt-get --purge remove mysql-client apt-get --purge remove mysql-common
apt-get autoremove apt-get autoclean 

b) Using aptitude

I noticed aptitude does a better job of removing dependencies

aptitude remove mysql-client aptitude remove mysql-server aptitude remove mysql-common 

c) See if anything depends on the installed packages

apt-cache rdepends mysql-server apt-cache rdepends mysql-client

d) Only if you’ve changed apparmor settings, change them back inside here

vi /etc/apparmor.d/usr.sbin.mysqld 

e) Delete configuration(following command deletes all the config)

rm -rf /etc/mysql

f) Find all files with “mysql” on / and delete them

find / -iname 'mysql*' -exec rm -rf {} \;

 

After all of the above, follow the steps below for a clean install

a) Install MySQL server and client

apt-get install mysql-server mysql-client

b) Check to see if mysql is running

service mysql status

and you should get the output

mysql start/running, process 1234

c) Check with mysqladmin

mysqladmin -u root -p status
Array ( [marginTop] => 100 [pageid] => @techish1 [alignment] => left [width] => 292 [height] => 300 [color_scheme] => light [header] => header [footer] => footer [border] => true [scrollbar] => scrollbar [linkcolor] => #2EA2CC )