mariadb安裝筆記 Ubuntu 12.04

sudo aptitude install software-properties-common python-software-properties

sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
sudo add-apt-repository 'deb http://ftp.kaist.ac.kr/mariadb/repo/10.0/ubuntu precise main'

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

sudo apt-get update
sudo aptitude install mariadb-server mariadb-client libmariadbclient-dev libmariadbd-dev php5-mcrypt phpmyadmin php5-mysql
sudo /etc/init.d/mysql restart

安裝完成後其實也沒做任何設定及出什麼問題，就直接使用囉~


附帶提一下我遇到的疑難雜症，最近蠻常會遇到網站出現一堆錯誤訊息
在做資料庫滙出的動作時，發現現似乎是連線數不足
mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_638_2.MAI' (Errcode: 24 "Too many open files")' when trying to dump tablespaces

我是直接改/etc/mysql/my.cnf
innodb_buffer_pool_size = 2560M
innodb_log_buffer_size  = 80M
innodb_file_per_table   = 1
innodb_open_files       = 4000
innodb_io_capacity      = 4000
innodb_flush_method     = O_DIRECT

一些數字後面直接加1個0，希望會有用 @@

上面的資訊改完，發現問題仍然存在，於是又加了
open-files-limit        = 4000

另外昇級完後，執行restart發現會一直出現" Checking for corrupt, not cleanly closed and upgrade needing tables."，不知會不會有問題
root@ubuntu:~# /etc/init.d/mysql restart
 * Stopping MariaDB database server mysqld                               [ OK ]
 * Starting MariaDB database server mysqld                               [ OK ]
 * Checking for corrupt, not cleanly closed and upgrade needing tables.
PS.我在一台新裝的Ubuntu 14.04主機上，全新安裝也有這個訊息，所以應該是沒問題