InnoDB Overview InnoDB provides MySQL with a transaction-safe (acid-compatible) storage engine with Commit, rollback, and crash resiliency. InnoDB locks the row-level and also provides an Oracle-style, non-locking read in the SELECT statement. These
In small memory VPS, kids shoes (including me) generally love to do the so-called "optimization". Among them, MySQL optimization has three parameters:
Skip-innodb/skip-bdb/skip-locking
In particular, the first parameter is said to save memory
Reference Manual | Chinese InnoDB chinese reference Manual---Dog dog (heart Sail) Translation 2 InnoDB startup options
In order to use the InnoDB table in mysql-max-3.23, you must specify the configuration parameters in the [mysqld] section of the
First, determine the version
View MySQL version
Copy Code code as follows:
Mysql-v
Or you can log in to MySQL using select version (); or status; Command view
Ii. Commencement of work
Close MySQL
Copy Code code as follows:
How to disable the innodb engine in mysql5.5 and mysq5.6 today we found that a backup mysql data folder has become abnormal. I found three more files: ibdata1 ib_logfile0 ib_logfile1, the former 18 m, the last two 5 MB data were migrated from mysql5.
How to disable the InnoDB engine in MySQL
I. determine the version
View MySQL versionMysql-VYou can also log on to MySQL using the select version (); or status; command to view
II. start work
Disable MySQLService mysql stopIf the preceding command
MySQL database innodb cannot be restarted after startup, mysqlinnodb
Problem description
The computer crashes during use. After the computer restarts, it finds that mysql is not successfully started. Check the error log and find that the innodb
Detailed description of InnoDB parameters,
1. query InnoDB parameters of MySQL 5.5 and comment on the following:[Root @ localhost etc] # grep-I innodb my. cnf;
T_innodb; otherwise, slaves may diverge from the master.
Uncomment the following if you
Backup | reference | reference Manual | recovery | data | database | Chinese InnoDB Chinese Reference Manual---canine (heart sail) Translation 6 backup and restore InnoDB database
Secure database management is the use of regular data
First, Xtrabackup Introduction
A, Xtrabackup is what
Xtrabackup is a tool for data backup of InnoDB, which supports online hot backup (without affecting data reading and writing during backup), is a good substitute for the commercial Backup tool
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.