MySQl Question

[peace]

Hello.

 

My question is about installing MySQL 5.1 in fresh master box. Is it OK to use standart configuration (i'm about installing via GUI) or its better to go through expanded settings. Is it something important there?

 

Thank you.

[studeggle]

default will work, but just like a default os install it is configured to be most versatile not most efficent. most efficent allways requires analyzing your exact situation.

[peace]

I understand that default settings are the most versatile. I'm talking about using MySQL for master+web server, so what would you advise?

[pjdaley]

I would advise get the default package, and then the GUI admin package if you don't know MySQL command line.

 

 

http://dev.mysql.com/downloads/mysql/5.1.html#downloads - use this for default MySQL install.

 

http://dev.mysql.com/downloads/gui-tools/5.0.html - use this for the GUI MySQL admin

 

If you have any questions let me know. After you get bigger, you can tweak the database, http://www.mysql.com has a wealth of knowledge

[peace]

From time to time i see in Event Viewer 3 events in series:

 

1st is "Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619"

 

2nd is "Event Scheduler: Loaded 0 events"

 

And the 3rd is "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.34-community' socket: '' port: 3306 MySQL Community Server (GPL)"

 

It sems that MySQL stops after "Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619" and run again "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections. Version: '5.1.34-community' socket: '' port: 3306 MySQL Community Server (GPL)"

 

If i understand correctly database is getting error because max open files, max connections or table cache is being exceeded (theoretically). Im runing Windows 2003 R2 with all latest updates. For fact it can't be so many connection one time or opened files. But anyway panel works fine.

 

Did any of you have such a problem and what setting should be changed to fix this?

 

Tomorrow I'll reconfigure MySQL to 1 connection. If im not mistaken user communication with database go beetwen TCAdmin so is it ok to limit connection to 1 user?

 

Thank You.