Setting MySQL innodb_buffer_pool_size

I was confused how big i should set my “innodb_buffer_pool_size” value. Then i find this post in stackexchange. I can run this query to get what is the suggestion of “innodb_buffer_pool_size” value. SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM (SELECT SUM(data_length+index_length) Total_InnoDB_Bytes FROM information_schema.tables WHERE engine=’InnoDB’) A; The result will be in GB.

Exporting MySQL Databases Command Line in Linux

To export a mysql database by linux command line, for example your database name is my_database, your mysql username is my_username, and your mysql password is my_password, you can use this command : mysqldump –opt –single-transaction -umy_username -pmy_password my_database > /your/path/here/export.sql Note: after “-u” and “-p”, there is NO space. 🙂

Multilanguage Programming with UTF-8 Encoding

Multilanguage non-ASCII site? Sometimes we need to make website that can handle languages which contains non-ASCII characters, for example chinese, russian, french, germany, etc. To handle this, we need to handle the language on 3 parts : on PHP itself, HTML, and on the database (i use MySQL as example here). Basically, we need to […]