Bookmark and Share
Last Updates
Display: 41 - 50 of 150, Total Pages: 15
<< < 1 2 3 4 5 6 7 8 ... 15 > >>
[Blog] How to Read iostat Output [Original] 2010-5-11 5:01pm

By default, it shows some of the same CPU usage information as vmstat. We’re usually interested in just the I/O statistics.

Read Full Article...

Section:Linux tips | Read:46103 | Comment:0 | Rating:0%

[Blog] How to Read vmstat Output [Original] 2010-5-11 11:57am

By default, vmstat and iostat produce just one report showing the average values of various counters since the server was started, which is not very useful. However, you can give both tools an interval argument. This makes them generate incremental reports showing what the server is doing right now, which is much more relevant for tuning. (The first line shows the statistics since the system was started; you can just ignore this line.)

 

 

Read Full Article...

Section:Linux tips | Read:24761 | Comment:0 | Rating:0%

[Blog] how to dump mysql procedures [Original] 2010-4-26 10:44pm

mysqldump -uroot -p --routines --no-create-info --no-data -S /data1/mysql/tmp/mysql.sock network > proc.sql

Read Full Article...

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

[Blog] InnoDB buffer pool Hit rate [Original] 2010-4-19 4:37pm

innodb buffer pool hit ratio =
1 - (innodb_buffer_pool_reads / innodb_buffer_pool_read_requests)

Read Full Article...

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

[Blog] Move an innodb .ibd file and the associated table from one database to another [Original] 2010-4-19 12:28pm

To move an .ibd file and the associated table from one database to another, use a RENAME TABLE statement:
RENAME TABLE db1.tbl_name TO db2.tbl_name;

 

Read Full Article...

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

[Blog] Resizing innoDB datafile [Original] 2010-4-19 12:21pm

it's better to use innodb-file-per-table. Then you will never need to resize innodb datafile size.

Read Full Article...

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

[Blog] character_set and collation [Original] 2010-4-9 3:56pm

Another way is to change the connection character set and collation to utf8. You can do that with SET NAMES 'utf8' or by setting the character_set_connection and collation_connection system variables directly.

Read Full Article...

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

[Blog] Bad performance on a large offet and coving index [Original] 2010-4-1 11:50am

A statement with an offset got bad performance when the offset getting bigger and bigger. The performance was improved after changing it to use the primary key.

 

Read Full Article...

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

<< < 1 2 3 4 5 6 7 8 ... 15 > >>
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