The diagram illustrates the MySQL Database architecture. MySQL has two main storage model: MYISAM and InnoDB. The MYISAM storage doesn't have transactions as InnoDB has. MYISAM has table-level locking while InnoDB has row-level locking. Starting MySQL 5.5, the InnoDB model is set as default. There are several important files in MySQL database:
|
0 Comments
|
MySQLMySQL was first introduced in 1995 and then became part of Sun Microsystem after the acquisition in February 2008. With Oracle acquired Sun in January 2010, MySQL database now is part of the Oracle products. MySQL database is known to be the database for the Web. Web applications use MySQL database as the back-end database. MySQL Latest Release
Archives
July 2017
Categories |