Posts

[Level X] Customize your own storage engine.

refer to the following website: http://forge.mysql.com/wiki/MySQL_Internals_Custom_Engine Wish this helps. regards, Stanley Huang

[Books] Recommanded books for MySQL.

Image
Two recommanded books for MySQL. The detail, please refer to the website of Amazon High Performance MySQL: http://www.amazon.com/gp/product/0596101716?ie=UTF8&tag=perinc-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0596101716 MySQL Developer's Library: http://www.amazon.com/MySQL-4th-Paul-DuBois/dp/0672329387/ref=sr_1_1?ie=UTF8&s=books&qid=1268323842&sr=8-1 Wish this helps. regards, Stanley Huang

[Level 2] Spider Storage Engine for MySQL

The new storage engine "Spider" does work for its strong scalability to access other storage engine of MySQL, to idea to the most considerations are below; 1:Scalability 2:Faster Access 3:Data Synchronizations 4:Reduce The Cost More information please refer to the following links: http://spiderformysql.com https://launchpad.net/spiderformysql Wish this helps. regards, Stanley Huang

[Level 2] How to get the difference between two tables.

Two table have the same data in echo column, how to get the difference between two tables. You can use out join and constraint the condition. Example: mysql> create table table1 (id int, name varchar(32)); mysql> create table table2 (id int, name varchar(32)); mysql> insert into table1 values(1,'Stanley'),(2,'John'),(4,'Mary'); mysql> insert into table2 values(1,'Stanley'),(3,'Joseph'),(5,'Christy'); case 1: find the data in table1 but not in table2; mysql> select * from table1 left join table2 on table1.id=table2.id where table2.id is null; case 2: find the data in table2 but not in table1; mysql> select * from table2 left join table1 on table2.id=table1.id where table1.id is null; Wish this helps. regards, Stanley Huang

[Level 2] Convert character set in MySQL

How to convert character set from Big5 to UTF-8 in MySQL. After MySQL 4.1, you can use alter command to convert character. alter all column in one command: mysql> alter table table_name convert to character set 'utf8'; Query OK, 3 rows affected (0.00 sec) Records: 3  Duplicates: 0  Warnings: 0 mysql> alter each column in one command: mysql> alter table orb modify a varchar(32) character set 'utf8'; Query OK, 3 rows affected (0.00 sec) Records: 3  Duplicates: 0  Warnings: 0 mysql> Wish this helps. regards, Stanley Huang

[Web Links] MySQL University

There is a good website for your to learning MySQL. http://forge.mysql.com/wiki/MySQL_University Wish this helps. regards, Stanley Huang

[Books] SQL Performance Tuning

Image
A good book for study SQL performance tuning. The introduction in Amazon: http://www.amazon.com/SQL-Performance-Tuning-Peter-Gulutzan/dp/0201791692/ref=sr_1_1?ie=UTF8&qid=1264478735&sr=8-1 Wish this helps. regards, Stanley Huang