Antelope is the innodb-base file format, Barracude is the file format introduced after Innodb-plugin, and Barracude file format is also supported. The difference between the two is:
File format
Support for row formats
This article mainly introduces the differences between MySQLAntelope and Barracuda. Antelope and Barracude are both in a file format. if you need them, refer to the document that Antelope is an innodb-base file format, barracude is the file format
Difference Analysis Between MySQL Antelope and Barracuda, antelopebarracuda
Antelope is the file format of innodb-base, Barracude is the file format introduced after innodb-plugin, and Barracude also supports Antelope file format. The difference is:
Antelope and Barracuda difference author: Wu Bingxi Source: http://www.mysqlsupport.cn/Contact Information: wubingxi # 163.com reprint please indicate/translator and source, and cannot be used for commercial purposes, offenders must
Antelope is a innodb-base file format, Barracude is a file format introduced after Innodb-plugin, and Barracude also supports Antelope file formats. The difference between the two is:
File format
Support Row format
1. Use the Join method to add an underscore to each element of the list by stitching it into a string, Li = [' Alex ', ' Eric ', ' Rain ']Li = [' Boom ', ' TNT ', ' zhadan ']daying = ' _ '. Join (LI) print (daying)2. Find the elements in the list,
Add by Zhj: In the MySQL5.6 of some parameters have been increased, see http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.htmlOriginal: http://mageedu.blog.51cto.com/4265610/1062628Marco Education Linux operation and maintenance
Innodb_adaptive_flushing= {ON | OFF}Set whether to allow the MySQL server to dynamically adjust the dirty pages in the InnoDB buffer pool based on the workload. The purpose of dynamically adjusting the write speed is to avoid IO activity spikes. The
Today the development of the import data in the time to report an error:Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. Some columns to TEXT or BLOBsCause: The imported data row length is found to be
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.