MyIsam engine transaction support

by

MyISAM effectively works in auto-commit mode (as it’s not a transactional engine), and it just ignores the commit/rollback.

Actually storage engine is a different layer in the MySQL architecture, separated from the SQL parser, the SQL layer communicates to the storage engine with lower-level API, and that’s the reason there is a common SQL and engines, supporting different subset of featured. You can see very high-level overview of the architecture here

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. How to properly create composite primary keys – MYSQL
  3. Is there a REAL performance difference between INT and VARCHAR primary keys?
  4. What’s the difference between MyISAM and InnoDB? [duplicate]
  5. MySql: MyISAM vs. Inno DB! [closed]
  6. How to lock a single row
  7. How can I check MySQL engine type for a specific table?
  8. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  9. Should I always prefer MySQL InnoDB over MyISAM?
  10. how to generate report for attendance system
  11. MySQL pivot table query with dynamic columns
  12. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  13. Finding duplicate values in MySQL
  14. Error installing mysql2: Failed to build gem native extension
  15. How to debug Lock wait timeout exceeded on MySQL?
  16. How to extract two consecutive digits from a text field in MySQL?
  17. Connect By Prior Equivalent for MySQL
  18. How to send email from MySQL 5.1
  19. MySQL skip first 10 results
  20. Import Data from Excel Spreadsheet or CVS into MySQL
  21. How to convert all tables from MyISAM into InnoDB?
  22. How can I get rid of these comments in a MySQL dump?
  23. How to create relationships in MySQL
  24. How to delete a MySQL record after a certain time
  25. using (-) dash in mysql table name
  26. Force InnoDB to recheck foreign keys on a table/tables?
  27. Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
  28. How can I enable MySQL’s slow query log without restarting MySQL?
  29. Does MySQL allows to create database with dot?
  30. Second SELECT query if first SELECT returns 0 rows

Leave a Comment