Any way to find out value of MAX_CONNECTIONS at present?

[ubbuser]

Hello in mysql for the database used by Vb on the server, is there any way I can find out the value of MAX_CONNECTIONS at any given time? I want to see at peak times what is the value of this variable as it croaked and gave me a few error messages which were emailed to me automatically by vB.

Any tips would be greatly appreciated as always. Thanks!;

[UserName]

I'm not sure what your asking exactly, but you may get the data you need from running the command:

mysqladmin ext

You will be able to see the variable:

Max_used_connections

Which tells you the maximum number of connections that were in use simultaneously since MySQL was started.

There are also other helpful stats in that list like the Threads_connected, which, as I understand it, tells you how many connections are open at the moment you look.

You can see all of the variables and what they mean here:
http://www.mysql.com/doc/S/H/SHOW_STATUS.html

Hope that's helpful in some way.

[eva2000]

Originally posted by ubbuser
Hello in mysql for the database used by Vb on the server, is there any way I can find out the value of MAX_CONNECTIONS at any given time? I want to see at peak times what is the value of this variable as it croaked and gave me a few error messages which were emailed to me automatically by vB.

Any tips would be greatly appreciated as always. Thanks!; f150guy in this thread http://vbulletin.com/forum/showthread.php?s=&threadid=37174 posted a script which logs to a file via cron the mysql extended-status out etc

you could probably use that to get a hourly log of mysql extended-status and hence max_connections

run via cron


#!/bin/sh

cd /usr/local/mysql/bin
uptime >> /usr/local/sbin/mysql.dat
./mysqladmin extended-status >> /usr/local/sbin/mysql.dat
./mysqladmin processlist >> /usr/local/sbin/mysql.dat