Bookmark and Share
Last Updates
Display: 61 - 70 of 150, Total Pages: 15
<< < 1 ... 3 4 5 6 7 8 9 10 ... 15 > >>
[Study Notes] testing MySQL Cluster [Original] 2009-11-9 3:22pm
MySQL Clustering in a Sandboxhttp://www.databasejournal.com/features/mysql/article.php/3819061/MySQL-Clustering-in-a-Sandbox.htm MySQL Cluster Sandbox - pre-defined packageshttp://www.severalnines.co..

Read Full Article...

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

[Study Notes] How MySQL handles errors during trigger execution? [Original] 2009-11-4 4:22pm
MySQL handles errors during trigger execution as follows:     * If a BEFORE trigger fails, the operation on the corresponding row is not performed.    * A BEFORE trigger..

Read Full Article...

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

[Study Notes] potential problems of Stored Programs in MySQL replication [Original] 2009-11-4 4:19pm
18.6. Binary Logging of Stored Programshttp://dev.mysql.com/doc/refman/5.4/en/stored-programs-logging.html However, there are certain binary logging issues that apply with respect to stored programs..

Read Full Article...

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

[Study Notes] Disadvantages of mysql stored procedures [Original] 2009-11-4 4:17pm
• MySQL doesn’t provide good developing and debugging tools, so it’s harder towrite stored code in MySQL than it is in some other database servers.• The language is slow and prim..

Read Full Article...

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

[Work Notes] Can't open file (errno: 24) [Original] 2009-11-3 11:57am
I go the following errors in a database: 091030 0:23:46 [ERROR] /usr/sbin/mysqld-max: Can't open file: './register/member.frm' (errno: 24)091030 0:23:46 [ERROR] /usr/sbin/mysqld-max: Can't open file:..

Read Full Article...

Section:MySQL DBA | Read:6756 | 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] InnoDB variables [Original] 2009-10-28 11:53am
innodb_log_files_in_group = 2 innodb_file_per_table ==> If innodb_file_per_table is disabled (the default), InnoDB creates tables in the shared tablespace. If innodb_file_per_table is enabled, In..

Read Full Article...

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

[Study Notes] spider data sharding and replication [Original] 2009-10-22 5:20pm
A. what is spider? (extracted from spider document) 1. Spider Storage Engine creates table links from local databases to remote databases.   Spider makes available tables in remote MySQL..

Read Full Article...

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

<< < 1 ... 3 4 5 6 7 8 9 10 ... 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