[ale] mysql advice

[Brian Pitts]

On 06/18/2009 09:20 AM, Atlanta Geek wrote:
> Does anyone know if there is a client limit to mysql. Currently these
> daemons will be writing to the same tables. Any suggestions.  This
> situation is difficult to simulate in the lab unless we write
> speciallized code.  Any suggestions from experience would be
> appreciated.
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_connections

Are the connections be persistent, or do the daemons open and close them
as needed? Maintaining a connection has overhead, as does opening a
connection, so it's a tradeoff. Knowing your mysql server configuration
(which affects how much memory is reserved for each connection) and
knowing how often the daemons access the database will help you decide
which is the better approach.

When you say writing, do you mean INSERT or UPDATE?

All the best,
Brian Pitts