Mysql的警告-windows server 2003

Submitted by mayazhao on 周二, 2008/09/02 - 08:35

事件类型: 警告
事件来源: MySQL
事件种类: 无
事件 ID: 100
日期: 2008-9-2
事件: 6:03:15
用户: N/A
计算机: YC2
描述:
Changed limits: max_open_files: 2048 max_connections: 1910 table_cache: 64

For more information, see Help and Support Center at http://www.mysql.com.

超出链接大小了吗？

如何解决？
mysql 5.1
怎么解决

Taxonomy upgrade extras:

yejr

周三, 2008/09/03 - 09:12

贴上mysql自己目录下的那个错误日志内容。貌似打开文件数超限了，搜下本站的文章，有相关的。

MySQL方案、培训、支持

mayazhao

周六, 2008/11/01 - 18:22

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
080817 19:25:21 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080817 19:25:21 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 29 MB
InnoDB: Database physically writes the file full: wait...
080817 19:25:22 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 29 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080817 19:25:23 InnoDB: Started; log sequence number 0 0
080817 19:25:23 [Note] E:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080817 19:38:32 [Note] E:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

081025 7:16:58 InnoDB: Starting shutdown...
081025 7:17:01 InnoDB: Shutdown completed; log sequence number 0 51844
081025 7:17:01 [Note] E:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

081025 7:18:58 InnoDB: Started; log sequence number 0 51844
081025 7:19:02 [Note] E:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
081026 6:00:30 [Note] E:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

yejr

周六, 2008/11/01 - 21:52

想发这个表达啥？

MySQL方案、培训、支持

mayazhao

周六, 2008/11/01 - 18:23

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
080817 19:25:21 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080817 19:25:21 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 29 MB
InnoDB: Database physically writes the file full: wait...
080817 19:25:22 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 29 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080817 19:25:23 InnoDB: Started; log sequence number 0 0
080817 19:25:23 [Note] E:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080817 19:38:32 [Note] E:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

081025 7:16:58 InnoDB: Starting shutdown...
081025 7:17:01 InnoDB: Shutdown completed; log sequence number 0 51844
081025 7:17:01 [Note] E:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

081025 7:18:58 InnoDB: Started; log sequence number 0 51844
081025 7:19:02 [Note] E:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
081026 6:00:30 [Note] E:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown