Linux系统下Mysql数据库安装配置归整
发布时间：2022-06-15 11:48:17 所属栏目：教程 来源：互联网
导读：Mysql安装对于各位站长来讲是非常重要的一个网如果没有数据库那必须不是什么好站了,好站都会有Mysql数据库了,下面我们就来介绍Mysql安装配置教程. Mysql安装 1、通过官网下载mysql源码包,http://dev.mysql.com/downloads/ 点击MySQL Community Server,选择
|
Mysql安装对于各位站长来讲是非常重要的一个网如果没有数据库那必须不是什么好站了,好站都会有Mysql数据库了,下面我们就来介绍Mysql安装配置教程. Mysql安装 1、通过官网下载mysql源码包,http://dev.mysql.com/downloads/ 点击MySQL Community Server,选择Source Code,点击 Generic Linux. (Architecture Independent),Compressed TAR Archive后的Download. # wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.20.tar.gz # tar zxvf mysql-5.6.20.tar.gz # cd mysql-5.6.20 2、安装cmake(mysql5.5以后源码安装都得通过cmake编译,并安装了ncurses ncurses-devel. # yum -y install cmake ncurses ncurses-devel # groupadd mysql # useradd -g mysql mysql 3、编译并安装 # cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/webserver/mysql -DMYSQL_DATADIR=/usr/local/webserver/mysql -DSYSCONFDIR=/usr/local/webserver/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1 编译出错需删掉CMakeCache.txt # rm CMakeCache.txt 拷贝mysql配置文件,并进行相应配置,这里是服务器是阿里云的最低配置,单核 512M内存. # cd /usr/local/webserver/mysql # chown -R mysql:mysql data/ # cp support-files/my-default.cnf my.cnf # vi my.cnf 编辑my.cnf: [mysqld] innodb_buffer_pool_size = 100M basedir = /usr/local/webserver/mysql datadir = /usr/local/webserver/mysql/data port = 3306 server_id = 1 socket = /tmp/mysql.sock join_buffer_size = 10M sort_buffer_size = 10M read_rnd_buffer_size = 12M query_cache_size = 32M tmp_table_size = 32M key_buffer_size = 32M performance_schema_max_table_instances=1000 table_definition_cache=800 table_open_cache=512 long_query_time=1 slow_query_log=1 slow_query_log_file=/usr/loca/webserver/mysql/data/slow-queries.log //phpfensi.com log_queries_not_using_indexes=1 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 初始化Mysql数据库: /usr/loca/webserver/mysql/scripts/mysql_install_db --user=mysql 启动Mysql: # ./support-files/mysql.server start 报错: Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/webserver/mysql/data/AY121218115148c506503.pid). 2014-08-14 11:29:38 1678 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2014-08-14 11:29:38 1678 [Note] InnoDB: The InnoDB memory heap is disabled 2014-08-14 11:29:38 1678 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation 2014-08-14 11:29:38 1678 [Note] InnoDB: Memory barrier is not used 2014-08-14 11:29:38 1678 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-08-14 11:29:38 1678 [Note] InnoDB: Not using CPU crc32 instructions 2014-08-14 11:29:38 1678 [Note] InnoDB: Initializing buffer pool, size = 100.0M InnoDB: mmap(106840064 bytes) failed; errno 12 2014-08-14 11:29:38 1678 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2014-08-14 11:29:38 1678 [ERROR] Plugin 'InnoDB' init function returned error. 2014-08-14 11:29:38 1678 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2014-08-14 11:29:38 1678 [ERROR] Unknown/unsupported storage engine: InnoDB 2014-08-14 11:29:38 1678 [ERROR] Aborting 无法给innodb_buffer_pool_size分配100M内存,但启动Mysql之前实际上是有内存的,Mysql5.6有几个默认值,按照这些值启动需要消耗几百兆内存,然后再分配给innodb_buffer_pool_size就不足了,服务器上可怜的512M内存. （编辑：聊城站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐