Mysql innodb supports storing tables and indexes on bare devices. The storage I/O wait problem has always been the key to affecting database performance. Bare devices do not need to be processed by the file system I/O, therefore, the performance has been improved.
Mysql innodb supports storing tables and indexes on bare devices. The storage I/O wait problem has always been the key to affecting database performance, bare devices do not need to be processed by the file system I/O, so the performance is improved.
Mysql innodb supports storing tables and indexes on bare devices. The storage I/O wait problem has always been the key to affecting database performance, bare devices do not need to be processed by the file system I/O. Therefore, the performance has been improved to some extent. It is obvious when using the kvm Virtual Machine in rhel, the performance of bare devices and virtio is basically the same as that of physical machines. in Oracle, bare devices are not supported starting from 11 GB, however, 10 Gb rac ocr and votedisk must be stored on bare devices. We recommend that you use ASM to improve storage I/O performance. ASM supports strip, advanced features such as redundancy and online addition and deletion of disk groups have some manageability. In contrast, Mysql bare devices are vulnerable, and may be distributed, the data volume of a single Mysql instance does not require bare devices to improve I/0 performance. The following shows how to use bare devices to store innodb Storage tables and indexes on Mysql.
1. Create an LVM volume and bind it with raw, where the raw1-raw5 is the asm disk of oracle
2. Modify the my. cnf file and add the following two items in [mysqld! Whether to use bare devices for database storage should be planned before database creation
3. initialize the mysql database and start the mysql service. You can see the formatting process and website space in the log. Before the newraw in the previous two configurations is changed to raw, the Hong Kong VM, an error occurred while creating an innodb table.
4. After closing the database, modify the my. cnf file, restart the database, create a table, and insert data for testing.
5. Use the strings command to extract printable characters from bare devices.
This article is from the "Bo Yue" blog, Hong Kong space. I am not allowed to reprint it!