Bookmark and Share
Last Updates
Display: 1 - 9 of 9, Total Pages: 1
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 find-fragment-table.sh#!/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

MYSQL在运行一段时间后,速度变慢,其中一个原因是一段时间后,随着数据表中内容的改变,表的素引的统计数据(statistics)过期,使得优化器(Optimizer)在执行查询(query)操作时不能提供最优查询策略。

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/sql_base.cc::close_cached_tables().

  • 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%

1
Latest Comments
eozzrixrlo

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

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

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

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

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

tramadol..
- By admin, 2008-3-12 1:48am
wnniqpohsg

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

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

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