[ale] mysql advice

[Atlanta Geek]

On Thu, Jun 18, 2009 at 10:39 AM, Brian Pitts<brian at polibyte.com> wrote:
> 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
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
>
Today the connection is persistent.
Their all Inserts.


-- 
http://www.atlantageek.com