错误日志如下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是否有postgreSQL一样的美元包围符号
- 如果一个innodb的表没有主键
- 数据库分析对人力资源进行统计分析
- 求一个单表的SQL语句
- mysql视图如何写?
- 用phpmyadmin访问mysql的问题
- 采用mysql开发的数据库应用程序,在安装到其他电脑上的时候,可以不安装mysql,而把mysql数据库当成一个文件连接到应用程序中使用吗?就
- 如何查询时间间隔的 mysql语句?
- http://www.8848home.com/xnzj.asp 同步支持ASP/PHP/CGI,不限空间和流量,可选MS SQL或MySQL的一种,1000/年。可以考虑吗?
- 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)