Bookmark and Share
Last Updates
Display: 1 - 9 of 9, Total Pages: 1
[Study Notes] Speeding up [Original] 2009-11-10 12:54pm
Not all ALTER TABLE operations cause table rebuilds. For example, you can change or drop a column’s default value in two ways (one fast, and one slow). Say you want to change a film’s defa..

Read Full Article...

Section:MySQL DBA | Read:897 | Comment:0 | Rating:0%

[Work Notes] How to find fragmented tables? [Original] 2009-11-8 12:21pm
$more!/bin/bashmysql -uroot -pxxx -N information_schema < find-fragment-table.sql > fragment-table.sql $ more find-fragment-table.sqlselect concat("optimize table ", TAB..

Read Full Article...

Section:MySQL DBA | Read:2810 | Comment:0 | Rating:0%

[Work Notes] How to repair a crashed MyISAM table? [Original] 2009-10-26 10:52pm
A MyISAM table got the following error message in the mysql error log:091026 21:00:01 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './openadstest/phpads_data_raw_ad_click.MYI'; try to repair..

Read Full Article...

Section:MySQL DBA | Read:3197 | Comment:1 | Rating:0%

[Work Notes] Building MyISAM Indexes Quickly [Original] 2009-9-22 11:11am
The usual trick for loading MyISAM tables efficiently is to disable keys, load the data, and reenable the keys: mysql> ALTER TABLE test.load_data DISABLE KEYS; -- load the data mysql> ALTER T..

Read Full Article...

Section:MySQL DBA | Read:2171 | Comment:1 | Rating:60%

[Work Notes] How to find out all tables which refer a table's column as a foreign key? [Original] 2009-9-3 3:15pm
mysql > select concat(table_name, '.', column_name) as 'foreign key', concat(referenced_table_name, '.', referenced_column_name) as 'references'from information_schema.key_column_usagewhere referen..

Read Full Article...

Section:MySQL DBA | Read:1080 | Comment:0 | Rating:0%

[Work Notes] How to delete duplicate primery keys in a table [Original] 2009-8-11 4:57pm
During a migration from Mysql 4 to Mysql 5, there is one table which got bunch of duplicated primary keys, how to delete those duplicated keys. Two methods: 1. using "select distinct(data_id)" mysql..

Read Full Article...

Section:MySQL DBA | Read:936 | Comment:0 | Rating:0%

[Blog] using MySQL merge engine for the large table [Original] 2007-3-6 1:13am
1. Known issue for the merge table
the merge table doesn't support the fulltext index. But you can have 
fulltext index on the underline tables. Since mysql doesn't support
fulltext index in Chinese, you may think of delete those fulltext
indexes on the tables.

Read Full Article...

Section:MySQL DBA | Read:815 | Comment:0 | Rating:0%

[Blog] MySQL速度变慢,怎么办? -- Analyze the tables (表分析) [Original] 2007-1-1 12:00am


Read Full Article...

Section:MySQL DBA | Read:5425 | Comment:0 | Rating:0%

[Blog] How MySQL Handles FLUSH TABLES [Copied] 2006-12-28 4:53pm
  • FLUSH TABLES is handled in sql/

  • The idea of FLUSH TABLES is to force all tables to be closed.

Read Full Article...

Section:MySQL DBA | Read:1801 | Comment:0 | Rating:0%

Latest Comments

on line..
- By admin, 2008-4-24 2:34am

free nud..
- By admin, 2008-4-24 2:33am

- By admin, 2008-4-5 1:02pm

somali p..
- By admin, 2008-4-5 1:01pm

- By admin, 2008-3-12 1:48am

- By admin, 2008-3-12 1:48am

- By admin, 2008-4-24 2:32am

in phent..
- By admin, 2008-4-24 2:29am

- By admin, 2008-3-12 1:47am