同时优化参数
基本目录:basedir
数据存放目录datadir:/data
日值:/logs
创建表:
CREATE TABLE `base` (
`id` int(10) NOT NULL,
`name` char(4) NOT NULL,
`address` varchar(60) default NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+----+------+---------+
| id | name | address |
+----+------+---------+
| 1 | 王伟 | 北京 |
+----+------+---------+
写入中文数据
--prefix=/mnt/soft/mysql
--with-unix-socket-path=/mnt/soft/mysql/tmp/mysql.sock
--localstatedir=/mnt/database/mysql_data
--enable-assembler
--with-mysqld-ldflags=-all-static
--with-mysqld-user=wbx
安装Mysql数据服务器
同时优化参数
基本目录:basedir
数据存放目录datadir:/data
日值:/logs
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data --user=nobody --defaults-file=/usr/local/mysql/my.cnf
/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf &
/usr/local/mysql/bin/mysqladmin shutdown
启动能关闭
创建表:
CREATE TABLE `base` (
`id` int(10) NOT NULL,
`name` char(4) NOT NULL,
`address` varchar(60) default NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+----+------+---------+
| id | name | address |
+----+------+---------+
| 1 | 王伟 | 北京 |
+----+------+---------+
写入中文数据