SQLite format 3 @ - 7K% indexsqlite_autoindex_group_master_2group_master7K% indexsqlite_autoindex_group_master_1group_masterP))[tableschema_versionschema_versionCREATE TABLE [schema_version] ( [schema_desc] TEXT, [schema_major_version] TEXT, [schema_minor_version] TEXT, PRIMARY KEY ([schema_major_version], [schema_minor_version]));O) indexsqlite_autoindex_schema_version_1schema_ve
1.36136
136
3 Current Connections p 1 Connection History
p
3p j - ;O) indexsqlite_autoindex_counter_master_1counter_master P))[tableschema_versionschema_versionCREATE TABLE [schema_version] ( [schemaP))[tableschema_versionschema_versionCREATE TABLE [schema_version] ( [schema_desc] TEXT, [schema_major_version] TEXT, [schema_minor_version] TEXT, PRIMARY KEY ([schema_major_version], [schema_minor_version]));O) indexsqlite_autoindex_schema_version_1schema_version
%%]tablegroup_mastergroup_masterCREATE TABLE `group_master` ( `group_id` INTEGER(10) NOT NULL, `group_type` INTEGER(10) NOT NULL, `group_name` VARCHAR(255) NOT NULL, `enabled` INTEGER(1) NOT NULL default '1', `dirty` INTEGER(1) NOT NULL default '0', `sequence_id` INTEGER(10) DEFAULT NULL, PRIMARY KEY (`group_id`), CONSTRAINT `unique_sequence` UNIQUE(`sequence_id`, `group_type`))
- Connection usage 0O
Percentage of max allowed reached
{ { S))atablecounter_mastercounter_masterCREATE TABLE `counter_master` ( `counter_id` INTEGER(10) NOT NULL, `group_id` INTEGER(10) NOT NULL, `sequence_id` DEFAULT(10) DEFAULT NULL, `counter_name` VARCHAR(255) NOT NULL, `enabled` INTEGER(1) NOT NULL DEFAULT '1', `unmerged` INTEGER(1) NOT NULL DEFAULT '0', `conflicted` INTEGER(1) NOT NULL DEFAUL7K% indexsqlite_autoindex_group_master_1group_master7K% indexsqlite_autoindex_group_master_2group_masterS))atablecounter_mastercounter_masterCREATE TABLE `counter_master` ( `counter_id` INTEGER(10) NOT NULL, `group_id` INTEGER(10) NOT NULL, `sequence_id` DEFAULT(10) DEFAULT NULL, `counter_name` VARCHAR(255) NOT NULL, `enabled` INTEGER(1) NOT NULL DEFAULT '1', `unmerged` INTEGER(1) NOT NULL DEFAULT '0', `conflicted` INTEGER(1) NOT NULL DEFAULT '0', PRIMARY KEY (`group_id`,`counter_id`), CONSTRAINT `unique_sequence` UNIQUE(`sequence_id`, `group_id`));O) indexsqlite_autoindex_counter_master_1counter_master
yl\N@+zfUD2 = ReminderIntervalOverride = NotifyTillStableOverride MailTo)SendStatusInfo !ChartValue YAxisType ChartType %SeriesValues'SeriesCaption
Caption %_PercentUsed)_PercentOnDisk Questions
Catalog 5NotifyStableOverride 'RetryOverride!AdviceText
'
GroupFunction Format Uptime
Barchart Chart MailAlert )WarmUpRequired )AlertCondition Critical
Warning
DocText Value
Formula .:F c +SThreads_connected / max_connections
Customize.Y
Max_used_connections / max_connectionscA
function()
{
if(MONyog.MySQL.Custom.Available != 1)
return "(n/a)";
return (SafeDiv0(MONyog.MySQL.GlobalStatus.Max_used_connections,MONyog.MySQL.GlobalVariables.max_connections)*100).toFixed(2)+ "%";
}sa
A high value indicates that you may run out of connections soon and new clients will be refused connection
65
75cA
function()
{
return GetWarnStatusInt(this.Value, this.Critical, this.Warning, true);
}
Yes
Yes
Yes
Avg:
o
1. Make sure that you have a reasonable high value for max_connections.
2. Design your application such that a MySQL connection is kept open for a very short period of time.
Yes#C
"nr-hdi@nathanresearch.com" Yes %C "nr-hdi@ #
~tj`VLB8.$
-
,
+
*
)
(
'
&
%
$
#
"
!
&c ; --)tablegenericfunctionsgenericfunctionsCREATE TABLE `genericfunctions` ( `fun_id` INTEGER NOT NULL, `fun_name` VARCHAR(255) NOT NULL UNIQUE, `fun_param` VARCHAR(255), `fun_value` VARCHAR, `unmerged` INTEGER(1) NOT NULL DEFAULT '0', `conflicted` INTEGER(1) NOT NULL DEFAULT '0', PRIMARY KEY (`fun_id`))?
S- indexsqlite_autoindex_genericfunctions_1genericfunctions;O) indexsqlite_autoindex_counter_master_2counter_master
++Gtableproperty_masterproperty_master CREATE TABLE property_master(
property_id INT,
property_name TEXT,
property_is_js INT
)\
tablecontentcontent
CREATE TABLE `content` ( `group_id` INTEGER NOT NULL, `counter_id` INTEGER NOT NULL, `property_id` INTEGER NOT NULL, `value` VARCHAR, PRIMARY KEY (`group_id`, `counter_id`, `property_id`))- A indexsqlite_autoindex_content_1content
D' c c c c c +SThreads_connected / max_connectionsB
Customize 0Y
Max_used_connections / max_connections A
function()
{
if(MONyog.MySQL.Custom.A
Avg o
1. Make sure that you have a reasonable high value for max_connections.
2. Design your application such that a MySQL connection is kept open for a very short period of time.
Yes %C
"nr-hdi@nathanresearch.com" Customize+SThreads_connected / max_connections`;function()
{
if(MONyog.MySQL.Custom.Available != 1)
return "(n/a)";
return (SafeDiv0(MONyog.MySQL.GlobalStatus.Threads_connected,MONyog.MySQL.GlobalVariables.max_connections)*100).toFixed(2)+ "%";
}Z/The number of currently open connections as percentage of max allowed connections
40
50cAfunction()
{
return GetWarnStatusInt(this.Value, this.Critical, this.Warning, true);
}
` vi\O` - Yes !1. The global variable max_connections determines the maximum number of concurrent connections to MySQL. Make sure that you have a high value for this variable.
2. Design your application such that a MySQL connection is kept open for a very short period of time.
3. Try pooling connections or switch to persistent connections. This will reduce the number of active MySQL connections. For example try using mysql_pconnect() instead of mysql_connect()
Avg
Yes Yes Yes Afunction()
{
#-C
"nr-hdi@nathanresearch.com" ,
Yes:+o
1. Make sure that you have a reasonable high value for max_connections.
2. Design your application such that a MySQL connection is kept open for a very short period of time. *
Avg )
Yes (
Yes '
Yesc&A
function()
{
return GetWarnStatusInt(this.Value, this.Critical, this.Warning, true);
}
%
55
$
45
& & s#a
A high value indicates that you may run out of connections soon and new clients will be refused connectionc"A
function()
{
if(MONyog.MySQL.Custom.Available != 1)
return "(n/a)";
return (SafeDiv0(MONyog.MySQL.GlobalStatus.Max_used_connections,MONyog.MySQL.GlobalVariables.max_connections)*100).toFixed(2)+ "%";
}.!Y
Max_used_connections / max_connections
Customize Yes Yes
Yes
AvgS !1. The global variable max_connections determines the maximum number of concurrent connections to MySQL. Make sure that you have a high value for this variable.
2. Design your application such that a MySQL connection is kept open for a very short period of time.
3. Try pooling connections or switch to persistent connections. This will reduce the number of active MySQL connections. For example try using mysql_pconnect() instead of mysql_connect() Yes# C "nr-hdi@nathanresearch.com"