Bookmark and Share
Last Updates
Display: 1 - 10 of 15, Total Pages: 2
1 2 > >>
[Study Notes] The query optimizer and Last_query_cost [Original] 2009-11-18 12:15pm
MySQL uses a cost-based optimizer, which means it tries to predict the cost of variousexecution plans and choose the least expensive. The unit of cost is a single randomfour-kilobyte data page read. Y..

Read Full Article...

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

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

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

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

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

[Study Notes] MySQL cluster summary [Original] 2009-9-17 10:57pm
MySQL Cluster features Overview:• MySQL Cluster is a technology that enables clustering of in-memorydatabases in a shared-nothing system.• MySQL Cluster is designed not to have any single point of fai..

Read Full Article...

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

[Study Notes] MySQL Cluster Performance [Original] 2009-9-1 3:40pm
MySQL Cluster has a very different impact on the concepts of response time, throughput, and scalability than a normal single-system, disk-based database, such as MyISAM or InnoDB.   Response ti..

Read Full Article...

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

[Study Notes] SQL_CALC_FOUND_ROWS and FOUND_ROWS() [Original] 2009-8-26 11:58am
SQL_CALC_FOUND_ROWS and FOUND_ROWS() can be useful in situations when you want to restrict the number of rows that a query returns, but also determine the number of rows in the full result set without..

Read Full Article...

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

1 2 > >>
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