Fast and Furious guide to MySQL database engines
Berkley DB, HEAP, ISAM, InnoDB, MyISAM
|
Visit
|
The MySQL stock engine is certainly adequate, but there are circumstances where the other available engines may be better suited to the task at hand. If you want, you can even bore out the cylinders and slap on a four-barrel carburetor by building your own database engine using the MySQL++ API. Let's look at how you choose the engine and how to change between engines that are available to you.
http://builder.com.com/ ... 6388-1058872.html (3179 hits)
rck, 2004-05-09 |
|
|
InnoDB
Database, Engine, MySQL
|
Visit
|
Transactions, row level locking, hot backup and foreign keys for MySQL -- without compromising the speed of MySQL.
http://www.innodb.com (2759 hits)
rck, 2004-05-09 |
|
|
InnoDB benchmark with PostgreSQL, MyISAM and Oracle 9i
no keywords.
|
Visit
|
...InnoDB and Oracle 9i win!
http://www.innodb.com/bench.php (3060 hits)
rck, 2004-05-09 |
|
|
java2s vSQL / MySQL examples
no keywords.
|
Visit
|
many examples for SQL / MySQL, organized by topic
http://www.java2s.com/C ... QL/CatalogSQL.htm (2311 hits)
rck, 2006-02-01 |
|
|
MyISAM Tables
Compressed MyISAM, MyISAM, MyISAM Merge Tables, RAID Tables
|
Visit
|
MySQL, like the Linux kernel, is modular. You can disable and even remove pieces that you have no need for. Modularity affords MySQL a very important advantage over many other database management systems: you can choose the type of each table at the time it is created.
http://www.linux-mag.co ... 4-02/lamp_01.html (4031 hits)
rck, 2004-05-15 |
|
|
Transactions in MySQL
ACID, Berkley DB, Gemini, InnoDB, MyISAM
|
Visit
|
In this tell-all tutorial, Jay Greenspan, author of MySQL Weekend Crash Course and co-author of MySQL/PHP Database Applications, starts with a tour of the basics: He answers the age-old Q: "What's the big deal with Transactions?"; investigates the four properties that a database must have to be considered transaction-capable; takes a closer look at locking mechanisms; and finishes up with a look at MyISAM tables, the lesser cousin of fully transaction-capable tables.
http://hotwired.lycos.c ... ls/tutorial2.html (3247 hits)
rck, 2004-05-09 |
|
|
