Get the App
SLTechnology News&Howtos  ›  Database  › 

Try mysql5.5.8

Shulou Source: shulou.com Published: 2022-06-01 05:14:32 10月04日 Update

Install mysql558 [@ more@]

First of all, read the official document http://dev.mysql.com/doc/refman/5.5/en/source-installation.html.

According to cmake, don't talk about it. Download the source code and change bug.

Http://bugs.mysql.com/bug.php?id=58350

Http://lists.mysql.com/commits/126782

Compile

CC='/usr/bin/gcc'

CFLAGS='-O2-g-pipe-Wall-Wp,-D_FORTIFY_SOURCE=2-fexceptions-fstack-protector-- param=ssp-buffer-size=4-M64-mtune=generic-fPIC-Wall-O3-g-static-libgcc-fno-omit-frame-pointer-fno-strict-aliasing-DDBUG_OFF'

CXX='/usr/bin/gcc'

CXXFLAGS='-O2-g-pipe-Wall-Wp,-D_FORTIFY_SOURCE=2-fexceptions-fstack-protector-- param=ssp-buffer-size=4-M64-mtune=generic-felide-constructors-fno-exceptions-fno-rtti-fPIC-Wall-Wno-unused-parameter-fno-implicit-templates-fno-exceptions-fno-rtti-O3-g-static-libgcc-fno-omit-frame-pointer-fno-strict-aliasing-DDBUG_OFF'

LDFLAGS=''

ASFLAGS=''

Cmake-DCMAKE_INSTALL_PREFIX=$MYSQL_HOME

-DDEFAULT_CHARSET=gbk

-DMYSQL_UNIX_ADDR=$MYSQL_HOME/run/mysql.sock

-DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_PERFSCHEMA_STORAGE_ENGINE=1

-DWITHOUT_ARCHIVE_STORAGE_ENGINE=1

-DWITHOUT_BLACKHOLE_STORAGE_ENGINE=1

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1

-DWITHOUT_FEDERATED_STORAGE_ENGINE=1

-DWITHOUT_PARTITION_STORAGE_ENGINE=1

-DWITHOUT_ARCHIVE_STORAGE_ENGINE=1.

Make-j 16

Make install

InnoDB: The InnoDB memory heap is disabled

InnoDB: Mutexes and rw_locks use GCC atomic builtins

InnoDB: Compressed tables use zlib 1.2.3

101221 13:51:32 InnoDB: Using Linux native AIO

101221 13:51:32 InnoDB: Initializing buffer pool, size = 32.0G

101221 13:51:33 InnoDB: Completed initialization of buffer pool

InnoDB: The first specified data file. / ibdata1 did not exist:

InnoDB: a new database to be created!

101221 13:51:33 InnoDB: Setting file. / ibdata1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

101221 13:51:33 InnoDB: Log file. / ib_logfile0 did not exist: new to be created

InnoDB: Setting logfile. / ib_logfile0 size to 500 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Progress in MB: 100 200 300 400 500

101221 13:51:34 InnoDB: Log file. / ib_logfile1 did not exist: new to be created

InnoDB: Setting logfile. / ib_logfile1 size to 500 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Progress in MB: 100 200 300 400 500

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: 127rollback segment (s) active.

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

101221 13:51:37 InnoDB: 1.1.4 started; log sequence number 0

101221 13:51:37 [Warning] 'user' entry' root@userext4-ztb' ignored in-skip-name-resolve mode.

101221 13:51:37 [Warning] 'user' entry' @ userext4-ztb' ignored in-- skip-name-resolve mode.

101221 13:51:37 [Warning] 'proxies_priv' entry' @ root@userext4-ztb' ignored in-- skip-name-resolve mode.

101221 13:51:37 [Note] Event Scheduler: Loaded 0 events

101221 13:51:37 [Note] / home/oracle/mysql/bin/mysqld: ready for connections.

Version: '5.5.8 socket:' / home/oracle/mysql/run/mysql.sock' port: 3306 Source distribution

Tags: Official documentation source code compilation Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Xiaomi Apple Shulou Tech Info vpn NVidia