Changes in MYSQL source code compilation and MYSQL source code compilation

Changes in MYSQL source code compilation and MYSQL source code compilation

For Mysql installation, the source code compilation method for mysql of different versions is different. 5.6.2 has changed from configure to cmake, related to the new compilation method in mysql official website has provided http://dev.mysql.com/doc/refman/5.6/en/source-configuration-options.html source code as follows http://dev.mysql.com/downloads/mysql/ related mysql5.6 source code compilation method .. /Configure make & make install this compilation method is a traditional method. The specific configuration parameters are as follows: specify the installation path of the program; -- enable-Cycler: Use Assembly mode; (Document Description: compiling in x86 (and iSCSI) versions of common string operations, which shoshould result in more performance. compile common operators on x86 to improve performance) -- enable-local-infile: enable support for the load data local infile syntax (not supported by default); -- enable-profiling: build a version with query profiling code (req. community-features) -- enable-thread-safe-client: Use the compile client; (meaning that the client supports threads) -- with-big-tables: enable 32-bit platform support for 4G big tables; -- with-charset = CHARSET: Specifies the character set; -- with-collation =: Default collation; -- with-extra-charsets = CHARSET, CHARSET ,...: Specify the additional character set; -- with-fast-mutexes: Compile with fast mutexes -- with-readline: -- with-ssl: enables SSL support; -- with-server-suffix =: add the string to the version information. -- with-embedded-server: compile embedded-server to build the embedded MySQL library. -- with-pthread: force the use of the pthread class library; -- with-mysqld-user =: Specifies the user of the mysqld daemon; -- with-mysqld-ldflags =: statically compiled MySQL server; (the static link improves the performance by 13%) -- with-client-ldflags =: statically compiled MySQL client; (static link improves performance by 13%) -- with-plugins = PLUGIN, PLUGIN and so on (the storage engine components supported by the MySQL server (which is empty by default) have many optional values: partition: MySQL Partitioning Support; daemon_example: This is an example plugin daemon; ftexample: simple full-text parser plugin; archive: Archive Storage Engine; blackhole: Basic Write-only Read-never tables; csv: Stores tables in text CSV format, mandatory installation; example: example for Storage Engines for developers; federated: Connects to tables on remote MySQL servers; heap: Volatile memory based tables, mandatory installation; ibmdb2i: IBM DB2 for I Storage Engine; innobase: transactional Tables using InnoDB; innodb_plugin: Transactional Tables using InnoDB; myisam: Traditional non-transactional MySQL tables, mandatory installation; myisammrg: Merge multiple MySQL tables into one, mandatory installation; ndbcluster: high Availability Clustered tables;) -- with-plugin-PLUGIN: forces the specified plug-in link to the MySQL server; -- with-zlib-dir =: provide MySQL with a custom compression class library address; -- without-server: Only install the MySQL client; -- without-query-cache: do not compile the query cache; -- without-geometry: do not compile the geometry-related part. -- without-debug: Compile the geometry-related part as the product version and discard the debugging code. -- without-ndb-debug: Disable the special ndb debug feature. Based on the above, my configuration :. /configure -- prefix =/usr/local/mysql/-- with-server-suffix = yu -- enable-encryper -- enable-local-infile -- enable-thread-safe-client -- -big-tables -- with-charset = utf8 -- with-extra-charsets = gbk, gb2312, utf8, ascii -- with-readline -- with-ssl -- with-embedded-server -- with-pthread -- with-mysqld-user = mysql -- with-mysqld-ldflags =-all-static -- -client-ldflags =-all-static -- with-plugins = partition, innobase, innodb_plugin

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.