Tech-Today
MyISAM (http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html)
-to create a MyISAM table, add ENGINE = MYISAM; at the end of create table script
-supports table locking (this is an issue when you need to backup the whole database)
-fast execution compared to innodb
-each table is stored in each own file
-has row limit
-produce more compact data
-use less storage space than innodb
-supports full-text search
-rollback is an issue
Innodb (http://dev.mysql.com/doc/refman/5.0/en/innodb.html)
-supports row locking, which is good for huge amount of concurrent inserts/updates
-tables and indexes are stored in a tablespace (multiple files)
-efficient in processing large amount of data
-supports transaction (commit, rollback, etc)
-fast query algorithms but use more memory compared to MyISAM
-choose if transaction, primary and foreign key are important for your system
-I prefer this, because of referential integrity, transactions and rollbacks
-if your database is normalized and you have lots of foreign keys, there are tables
that are dependent on others, then you need this
Benchmark of Falcon, MyISAM and Innodb
http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/
Mysql Management Tools:
mysql gui tools - http://dev.mysql.com/downloads/gui-tools/5.0.html
sqlyog - http://www.webyog.com/en/downloads.php
toad - http://www.quest.com/toad-for-mysql/
- Java Standalone Persistence Using Jpa
This application demonstrates the use of JPA in a standalone Java application. I. Getting StartedThis project is a standalone Java application that reads a server log file, parses and saves to a MySQL table access_log. It also executes a named query...
- Database
MSSQLMSSQL equivalent of DESC in MYSQLPostgresqlChange postgresql's postgres passwordHow to install hstore in postgresql 9.1JDBC provider setting in java for postgresql, mysql and oracleHow to alter the sequence value in postgresqlOracleHow to change...
- Create A New Seam Web Project In Eclipse-helios
In this exercise we will be building seam web project in eclipse. It's long so stay focus :-D. What you need (The following should be installed correctly): Note: in parentheses is where I installed mine. 1.) Jboss seam 2.2.1 (C:\jboss-seam-2.2.1)...
- How To Get Started With Hibernate In Java. Create A Simple Class And Database Schema For Demostration.
Since, I've always been using different database sometimes I get confused how to implement the others. Like hibernate, where the configuration must be properly set. *This help assumes that you have already created a java project in eclipse that has...
- Magento: Cannot Add Or Update A Child Row: A Foreign Key Constraint Fails
I am in the stage of migrating my local database of magento to public when I have encountered this error. How did it happen: 1.) I use phpmyadmin3.2 to export the sql statements. 2.) In my host mysql's phpmyadmin, I have executed the dump statements....
Tech-Today
MySQL Engine: MyISAM vs Innodb
MyISAM (http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html)
-to create a MyISAM table, add ENGINE = MYISAM; at the end of create table script
-supports table locking (this is an issue when you need to backup the whole database)
-fast execution compared to innodb
-each table is stored in each own file
-has row limit
-produce more compact data
-use less storage space than innodb
-supports full-text search
-rollback is an issue
Innodb (http://dev.mysql.com/doc/refman/5.0/en/innodb.html)
-supports row locking, which is good for huge amount of concurrent inserts/updates
-tables and indexes are stored in a tablespace (multiple files)
-efficient in processing large amount of data
-supports transaction (commit, rollback, etc)
-fast query algorithms but use more memory compared to MyISAM
-choose if transaction, primary and foreign key are important for your system
-I prefer this, because of referential integrity, transactions and rollbacks
-if your database is normalized and you have lots of foreign keys, there are tables
that are dependent on others, then you need this
Benchmark of Falcon, MyISAM and Innodb
http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/
Mysql Management Tools:
mysql gui tools - http://dev.mysql.com/downloads/gui-tools/5.0.html
sqlyog - http://www.webyog.com/en/downloads.php
toad - http://www.quest.com/toad-for-mysql/
- Java Standalone Persistence Using Jpa
This application demonstrates the use of JPA in a standalone Java application. I. Getting StartedThis project is a standalone Java application that reads a server log file, parses and saves to a MySQL table access_log. It also executes a named query...
- Database
MSSQLMSSQL equivalent of DESC in MYSQLPostgresqlChange postgresql's postgres passwordHow to install hstore in postgresql 9.1JDBC provider setting in java for postgresql, mysql and oracleHow to alter the sequence value in postgresqlOracleHow to change...
- Create A New Seam Web Project In Eclipse-helios
In this exercise we will be building seam web project in eclipse. It's long so stay focus :-D. What you need (The following should be installed correctly): Note: in parentheses is where I installed mine. 1.) Jboss seam 2.2.1 (C:\jboss-seam-2.2.1)...
- How To Get Started With Hibernate In Java. Create A Simple Class And Database Schema For Demostration.
Since, I've always been using different database sometimes I get confused how to implement the others. Like hibernate, where the configuration must be properly set. *This help assumes that you have already created a java project in eclipse that has...
- Magento: Cannot Add Or Update A Child Row: A Foreign Key Constraint Fails
I am in the stage of migrating my local database of magento to public when I have encountered this error. How did it happen: 1.) I use phpmyadmin3.2 to export the sql statements. 2.) In my host mysql's phpmyadmin, I have executed the dump statements....