mysql storage engine

searching for memory storage engine

storing this for future reference;
http://jonathanhui.com/mysql-storage-engine

optimize mysql with index

if you want to join large table, indexing may help.

table1: 30,000 rows
table2: 40 rows

indexing for example user ID may speed up select query

SELECT name, phoneNo, address FROM table1 INNER JOIN table2 ON table1.userid = table2.userid

with no index, query takes about 8second
but with index query only 0.4second

fine tune mysql server

http://serverfault.com/questions/53266/how-to-fine-tune-our-mysql-server

bookmark this page for later reference

mysql tuning

this is good reference how to do about optimizing mysql setting

http://serverfault.com/questions/148926/mysql-optimizing

http://www.ibm.com/developerworks/library/l-tune-lamp-3.html