错误日志如下110426 00:19:23 mysqld_safe mysqld from pid file /var/lib/mysql/ldc2095.aus.us.siteprotect.com.pid ended
110426 00:19:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110426 0:19:24 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
110426 0:19:24 InnoDB: Initializing buffer pool, size = 1.0G
110426 0:19:24 InnoDB: Completed initialization of buffer pool
110426 0:19:24 InnoDB: highest supported file format is Barracuda.
110426 0:19:24 InnoDB: Warning: allocated tablespace 1, old maximum was 0
110426 0:19:24 InnoDB Plugin 1.0.15 started; log sequence number 7625969722
110426 0:19:24 [Note] Event Scheduler: Loaded 0 events
110426 0:19:24 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.56-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)下面这3个提示信息,不懂什么意思?谁帮我解释一下啊
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
110426 0:19:24 InnoDB: Warning: allocated tablespace 1, old maximum was 0另外各位在生产环境中,用PLUGIN还是BUILDIN?
110426 00:19:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110426 0:19:24 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
110426 0:19:24 InnoDB: Initializing buffer pool, size = 1.0G
110426 0:19:24 InnoDB: Completed initialization of buffer pool
110426 0:19:24 InnoDB: highest supported file format is Barracuda.
110426 0:19:24 InnoDB: Warning: allocated tablespace 1, old maximum was 0
110426 0:19:24 InnoDB Plugin 1.0.15 started; log sequence number 7625969722
110426 0:19:24 [Note] Event Scheduler: Loaded 0 events
110426 0:19:24 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.56-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)下面这3个提示信息,不懂什么意思?谁帮我解释一下啊
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
110426 0:19:24 InnoDB: Warning: allocated tablespace 1, old maximum was 0另外各位在生产环境中,用PLUGIN还是BUILDIN?
解决方案 »
- mysql的多对多如何建立?
- 100分---mysql 双机热备,error connecting to master的问题
- 菜鸟提问,不知安装哪个版本的Mysql
- 一定要用regexp解决sql的大小写问题
- 为什么我向MySQL数据库(5.0版本)插入记录的时候,当某个字段的内容是中文的时候就提示错误呢?详见内容
- MySQL 通过ADO连接VC++
- 下面是MYSQL数据库表单
- gcc编译mysql c api出错,大家请帮忙,一定给分
- mysql截取取中字符串,且要除零
- mysql 倒数截取?
- PostgreSQL9.0装上去后,用pgAdminⅢ打开连不上数据库
- innodb5.5的Storage Layout Tips问题!
5.1.38开始,MySQL包含了2个不同版本的InnoDB存储引擎—一个是旧版本的引擎,称之为build-in innodb;另一个是1.0.4版本的InnoDB存储引擎。如果你想使用新的InnDB Plugin引擎,只需在配置文件做如下设置:
[mysqld]
ignore-builtin-innodb
plugin-load=innodb=ha_innodb_plugin.so
;innodb_trx=ha_innodb_plugin.so
;innodb_locks=ha_innodb_plugin.so
;innodb_cmp=ha_innodb_plugin.so
;innodb_cmp_reset=ha_innodb_plugin.so
;innodb_cmpmem=ha_innodb_plugin.so
;innodb_cmpmem_reset=ha_innodb_plugin.so
在写本书时,InnoDB Plugin的最新版本是1.0.4,并已经是MySQL 5.4版本默认的InnoDB存储引擎版本,其新功能包括以下几点。
快速索引重建。
更好的多核性能。
新的页结构。
页压缩功能。
更好的BLOB处理能力。
+----------------------+
| version() |
+----------------------+
| 5.1.56-community-log |
+----------------------+
1 row in set (0.01 sec)mysql> select @@innodb_version;
+------------------+
| @@innodb_version |
+------------------+
| 1.0.15 |
+------------------+
1 row in set (0.00 sec)