- 论坛徽章:
- 0
|
本帖最后由 chinafenghao 于 2013-10-11 11:30 编辑
机器A,Centos6.3 x64,机器B, reahat 5.5 x86,两台机器上都是用rpm安装的MySql,区别就是A机器是64位的,B机器是32位的,两者的硬件软件配置见下图所示
现在问题是,两台服务器都处于局域网环境,用ssh远程连上,用mysql自带的客户端连上mysql,用source命令执行内容完全一样的sql文件,sql文件都放在各自服务器的本地硬盘上,性能差距巨大,A机器按说应该更快,却比B机器慢至少三倍的速度,A机器执行insert命令时,显示的执行时间每条约0.03-0.06sec,但是B机器执行时显示的时间几乎全是0.00,连0.01都很难看见。二者的配置文件完全相同,我自安装后就没动过性能上的设置,只是改了utf-8- # For advice on how to change settings please see
- # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
- [mysqld]
- character_set_server = utf8
- [client]
- default-character-set=utf8
- init_connect='SET NAMES utf8'
- # Remove leading # and set to the amount of RAM for the most important data
- # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
- # innodb_buffer_pool_size = 128M
- # Remove leading # to turn on a very important data integrity option: logging
- # changes to the binary log between backups.
- # log_bin
- # These are commonly set, remove the # and set as required.
- # basedir = .....
- # datadir = .....
- # port = .....
- # server_id = .....
- # socket = .....
- # Remove leading # to set options mainly useful for reporting servers.
- # The server defaults are faster for transactions and fast SELECTs.
- # Adjust sizes as needed, experiment to find the optimal values.
- # join_buffer_size = 128M
- # sort_buffer_size = 2M
- # read_rnd_buffer_size = 2M
- sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
复制代码 我现在想不通这个差别是为什么,按说64位性能应该更高 |
|