Innodb Database Engine:
This is the transaction database engine and it supports data integrity and relationships between the tables. If the database is crashed you can easily get back the data. It I storing in a single file and we can easily mix the innodb tables. By default innodb state is disabled. To enable the innodb state open my.cnf file that is located in file:///C:/xampp/mysql/bin/.
To change the configuration settings of innodb directives, first we have to comment (#) skip_innodb statement. And remove the comments (#) of configuration directives.
Memory (key) Engine:
By using this table we can store the information in Ram. It is 30% faster that myisam. They are accessed and used in exactly the same as regular myisam tables. However, the data stores within them are available only for the life time of Mysql server and erased when the server is crashed.
Berkeley db Engine: The Bdb table supports commit, roll back options, crash recovery multiuser. But it contains some limitations. We can’t move easily, cannot compress and table size is larger than myisam. That is the reason why we are not using this table in applications.
Also on Friday, Jackson met his other set of great-grandparents. php notes and Granpa made the drive up from Orlando, and we had the best time seeing them. They even brought php notes a wonderful Auburn quilt that a lady in their church made for them. What a special gift that will be treasured for many years!
ReplyDelete