Bookmark and Share
Last Updates
Display: 1 - 5 of 5, Total Pages: 1
1
[Blog] Using the Transaction Information Schema Tables to check lock status [Original] 2010-12-28 4:50pm

It is sometimes helpful to be able to identify which transaction is blocking another. You can use the Information Schema tables to find out which transaction is waiting for another, and which resource is being requested.

Read Full Article...

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

[Blog] an example of using load data infile [Original] 2009-11-2 3:52pm

 $ more load-data.sql
load data infile '/data2/real/HDM_Extract_2.csv' into table member
fields TERMINATED BY ','
LINES TERMINATED BY '\n' IGNORE 1 LINES;

Read Full Article...

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

[Work Notes] Upgrade from MySQL 5.0 to MySQL 5.1 [Original] 2009-9-27 12:54pm
Upgrade from MySQL5.0 to MySQL5.11. backup databases first.2. $rpm -Uvh MySQL5.1.rpm3. If 2 doesn't work, we need to manual upgrade MySQL- Ensure that you have a complete, working backup of your data..

Read Full Article...

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

[Work Notes] useful command line [Original] 2009-9-10 11:55am
-- change master command:change master to master_host='host1',master_user='repl',master_password ='xxxxx',master_port = 3306,master_log_file='db-bin.000649',master_log_pos = xxx;-- skip one transactio..

Read Full Article...

Section:MySQL DBA | Read:1344 | 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