Problem: [Warning] changed limits: max_open_files: 2048 max_connections:
800 table_cache: 619
MySQL Server
After binary installation is performed in windows, the mysqld-NT Server is called by default in the Windows service. We can see in the properties of the Windows MySQL service:
"C: \ Program Files \ mysql \ MySQL Server 5.0 \ bin \ mysqld-nt" -- defaults-File
= "C: \ Program Files \ mysql \ MySQL Server 5.0 \ My. ini" MySQL
We can also enable the mysqld server instead of the default MySQL server in windows.
Start MYSQL:
C: \ Program Files \ mysql \ MySQL Server 5.0 \ bin> mysqld -- Console
070608 14:12:04 [Warning] changed limits: max_open_files: 2048 max_connections:
800 table_cache: 619
070608 14:12:05 InnoDB: started; log sequence number 0 956199
070608 14:12:05 [note] mysqld: Ready for connections.
Version: '5. 0.27-communit' socket: ''port: 3306 MySQL Community edition (GP
L)
If the -- console option is omitted, the server writes the diagnosis output to the error log in the data directory (c: \ Program Files \ mysql \ MySQL Server 5.1 \ data by default. The extension of the error log file is. Err.
C: \ Program Files \ mysql \ MySQL Server 5.0 \ bin> mysqld -- defaults-file = "C: \ Program Files \ mysql \ MySQL Server 5.0 \ My. ini"
070608 9:32:34 [Warning] changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619
If we do not execute environment variables andProgramVariables, mysqld and mysqld-nt are read from the [mysqld] and [server] groups in the configuration file. *
......
[Read the full text]