Forum for MySQL Monitor http://forums.mysql.com/list.php?142 Tue, 24 Nov 2009 20:21:39 +0000 Phorum 5.2.1-alpha http://forums.mysql.com/read.php?142,289415,289415#msg-289415 http://forums.mysql.com/read.php?142,289415,289415#msg-289415
I enabled the log, the Slow Query Log option.

It is my system variables:

....

log_slow_queries slowquery.log

long_query_time 1

....

slow-query-log TRUE

slow_launch_time 2

slow_query_log_file slowquery.log

.....

I load web page, where sql request takes 15 second, but there is not file slowquery.log on my computer. What is trouble? :]]> mnbv poiu MySQL Monitor Wed, 04 Nov 2009 10:31:59 +0000 http://forums.mysql.com/read.php?142,289122,289122#msg-289122 http://forums.mysql.com/read.php?142,289122,289122#msg-289122 http://blogs.sun.com/DatabaseEmporium/entry/agents_hosts_and_instances_oh]]> Edwin DeSouza MySQL Monitor Mon, 02 Nov 2009 16:50:35 +0000 http://forums.mysql.com/read.php?142,288761,288761#msg-288761 http://forums.mysql.com/read.php?142,288761,288761#msg-288761 http://www.markleith.co.uk/?p=290]]> Edwin DeSouza MySQL Monitor Fri, 30 Oct 2009 19:44:10 +0000 http://forums.mysql.com/read.php?142,285741,285741#msg-285741 http://forums.mysql.com/read.php?142,285741,285741#msg-285741
I have a requirement to store a huge data(Millions of patient records). Kindly answer my few queries?

1. What could be the maximum size of database?
2. What could be maximum number of rows ( Assuming average_length of 80)
3. Does the maximum size differs in MySQL Enterprise version against non Enterprise version.

Regards,
Raj.]]> Rajesh Kumar MySQL Monitor Mon, 12 Oct 2009 07:20:30 +0000 http://forums.mysql.com/read.php?142,283078,283078#msg-283078 http://forums.mysql.com/read.php?142,283078,283078#msg-283078 i see a prebundlesd mysql 5.1.37 enterprise commercial pro edition that enterprise monitor monitoring.when i go MySQL enterprise dash board.it moniotr only prebundled MySQL server.But i have delete this server from Settings-->Manage Server.-->delete section.
Now Monitor Zero Host Out of 32 Host Monitoring...So How i manage new server.i can't do it.i am trying it atleast 10 Hours.i read MySQL enterprise manual.yet i can't do it.
Please Please Please Help.How I Manage A New Server By MySQL Enterprise Monitor.]]> Nayan Paul MySQL Monitor Thu, 24 Sep 2009 18:56:44 +0000 http://forums.mysql.com/read.php?142,280784,280784#msg-280784 http://forums.mysql.com/read.php?142,280784,280784#msg-280784

U0146 Unable to schedule rule "Excessive Query Length" due to "mysql.Statement.exec_time" data not being collected from server "mysql.server:3306". It may be an unsupported collection for that server.


Jeremy]]> Jeremy Regan MySQL Monitor Fri, 11 Sep 2009 13:35:19 +0000 http://forums.mysql.com/read.php?142,280476,280476#msg-280476 http://forums.mysql.com/read.php?142,280476,280476#msg-280476
The flagship features of this release are:

o Visual correlation of any graph activity with queries in the
Query Analyzer
o Query History Graphs (in the query pop-ups)
o Query Error and Warning tracking
o Open Support issues are listed on the What's New page, and issues
waiting for customer feedback are highlighted on the main
Dashboard
o Important product-related announcements on the What's New? page
o New rules and graphs
o Many bug fixes and performance improvements

For more information on what's new in this release, an introduction to the Query Analyzer, and an overview of how to get started using it, please see:

https://update.mysql.com/mnmaas/2.1.0.1096/docs_en/MEM_Whats_New_en.pdf

https://update.mysql.com/mnmaas/2.1.0.1096/docs_en/MEM_Query_Analyzer_en.pdf

https://update.mysql.com/mnmaas/2.1.0.1096/docs_en/MEM_Getting_Started_en.pdf

You will find binaries of the new release here:

https://enterprise.mysql.com/monitoring/download.php

More information on MySQL Enterprise and the Enterprise Monitor can be found here:

http://www.mysql.com/products/enterprise/
http://www.mysql.com/products/enterprise/advisors.html
http://www.mysql.com/products/enterprise/query.html
https://enterprise.mysql.com/monitoring/index.php
http://forums.mysql.com/index.php?137

If you are not a MySQL Enterprise customer and want try the Monitor
and Query Analyzer via our 30-day free customer trial, register at
http://www.mysql.com/trials/customers, or contact Sales at
http://www.mysql.com/about/contact/sales.html?s=corporate for
information on the trial or on upgrading your subscription.

If you haven't looked at 2.1 recently, please do so now and let us know what you think.

Thanks and Happy Monitoring!

- The MySQL Enterprise Tools Development Team]]> Andy Bang MySQL Monitor Thu, 10 Sep 2009 00:47:31 +0000 http://forums.mysql.com/read.php?142,280269,280269#msg-280269 http://forums.mysql.com/read.php?142,280269,280269#msg-280269 http://mysql.com/products/enterprise/monitor-features.html

MySQL Enterprise Monitor: Benefits
http://mysql.com/products/enterprise/benefits.html]]> Edwin DeSouza MySQL Monitor Tue, 08 Sep 2009 22:22:28 +0000 http://forums.mysql.com/read.php?142,280028,280028#msg-280028 http://forums.mysql.com/read.php?142,280028,280028#msg-280028
I have a mysql server where thousands of users connect. I configured max connections but i didn't found how to configure concurrent raunning threads. When i do show status, always RUNNING THREADS=1, even several threads are pending.

How to change this please ?

Anyone can help me please ?

Thank you very much !

Nabila]]> Nabila Salmi MySQL Monitor Mon, 07 Sep 2009 08:02:44 +0000 http://forums.mysql.com/read.php?142,279335,279335#msg-279335 http://forums.mysql.com/read.php?142,279335,279335#msg-279335 Alejandro Chiappe MySQL Monitor Thu, 05 Nov 2009 07:48:33 +0000 http://forums.mysql.com/read.php?142,276581,276581#msg-276581 http://forums.mysql.com/read.php?142,276581,276581#msg-276581 I want to determine the size of database so that if it is near 4GB I should empty the database for further use.

I am getting the size of database using the following query:
SELECT table_schema "Data Base Name",
sum( data_length + index_length )/1048576
"Data Base Size in MB",
sum( data_free )/1048576 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ;

Output:
Database name database size(MB) Free space(MB)
test 0.0313 8.0000

But i can not understand why database size is less than free space.]]> Aysha Keen MySQL Monitor Mon, 17 Aug 2009 11:57:13 +0000 http://forums.mysql.com/read.php?142,276235,276235#msg-276235 http://forums.mysql.com/read.php?142,276235,276235#msg-276235 I have very huge number of records probabaly in 1Tb. I want my system should perform faster.

2. I also want to know is it possible to cache query using bind variables and what are the ways to it.

I am using hibernate also at the application level. so can u suggest me any good techniques so that my systems performs faster.]]> krunal pala MySQL Monitor Fri, 14 Aug 2009 09:14:31 +0000 http://forums.mysql.com/read.php?142,274039,274039#msg-274039 http://forums.mysql.com/read.php?142,274039,274039#msg-274039 page 98（6.4.7) of the "MySQL Enterprise Monitor 2.0"
show me how to build a new rule to watch the row num of a table

but, I found the "mysql:table:num_rows" data item have problem when I want to schedule it.

anyone can help me?

please]]> single lin MySQL Monitor Fri, 31 Jul 2009 09:48:22 +0000 http://forums.mysql.com/read.php?142,270891,270891#msg-270891 http://forums.mysql.com/read.php?142,270891,270891#msg-270891
Thanks,
Steve]]> Bill Withers MySQL Monitor Thu, 09 Jul 2009 01:11:10 +0000 http://forums.mysql.com/read.php?142,266545,266545#msg-266545 http://forums.mysql.com/read.php?142,266545,266545#msg-266545 can anybody tell me which entries does the agent in den local db do ?

is that a problem when i make a snapshot from a master server in replication there is an agent running and use it on a slave (other ) server. ?

thanks]]> Martin Lindner MySQL Monitor Fri, 14 Aug 2009 04:06:49 +0000 http://forums.mysql.com/read.php?142,265798,265798#msg-265798 http://forums.mysql.com/read.php?142,265798,265798#msg-265798
Is it possible to create monitor for mysql database

Is there any third party open source available or we can use mysql tools to monitor availability of mysql.

Please help.

Sunil Sagar]]> Sunil Sagar MySQL Monitor Thu, 11 Jun 2009 09:47:37 +0000 http://forums.mysql.com/read.php?142,263695,263695#msg-263695 http://forums.mysql.com/read.php?142,263695,263695#msg-263695
This is sort of a double posting as I have a similar question in .NET section but as I got no replies I think I've asked the wrong question and/or in the wrong location. So apologies

I'm getting the following error, what I would like to know is what is causing it and how to monitor it and correct it.

Any advise would be appreciated.

Jim

Error: LINE 0 : ERROR CONNECTING: TIMEOUT EXPIRED. THE TIMEOUT PERIOD ELAPSED PRIOR TO OBTAINING A CONNECTION FROM THE POOL. THIS MAY HAVE OCCURRED BECAUSE ALL POOLED CONNECTIONS WERE IN USE AND MAX POOL SIZE WAS REACHED.

Message: at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at SatcomDiscoverySocket.clsLocation.FindNearestFavourite(Int64 AssetID, Decimal Longitude, Decimal Latitude) in C:\Documents and Settings\jim.SATCOM_DOMAIN\My Documents\Visual Studio 2005\Projects\Satcom Discovery Socket Server\SatcomDiscoverySocket\SatcomDiscoverySocket\Thread Polling\clsLocation.vb:line 340]]> Jim Buckley-Barrett MySQL Monitor Thu, 11 Jun 2009 09:48:30 +0000 http://forums.mysql.com/read.php?142,259483,259483#msg-259483 http://forums.mysql.com/read.php?142,259483,259483#msg-259483
i want to monitor mysql remote server on linux machine through mysql enterprize monitoring tool from the windows server.I have installed mysql enterprize monitoring tool for windows.

From the document for mysql monitoring tool installation i understood to we need to install the following softwares.

1.mysql service manager.
2.mysql repository.
3.mysql agent.

my question is how to monitor remote mysql server through mysql enterprize monitoring tool from windows.In remote machine what we need to install to monitor the server from client machine(windows) through web browser and In client machine (windows) what we need to configure.

thanks in advance.

with thanks and regards,
rameshkumar.G]]> ramesh G MySQL Monitor Fri, 24 Apr 2009 12:34:04 +0000 http://forums.mysql.com/read.php?142,258548,258548#msg-258548 http://forums.mysql.com/read.php?142,258548,258548#msg-258548 But I counldn't use Monitoring after upgrading Monitoring version 2.0.5.7153.
The error was occured. following messages;

2009-04-16 16:39:43: (critical) last message repeated 2 times
2009-04-16 16:39:43: (critical) network-io.c:256: successfully reconnected to dashboard at http://agent:agent@10.89.20.42:18080/heartbeat
2009-04-16 16:39:46: (critical) network-io.c:220: curl_easy_perform('http://agent:agent@10.89.20.42:18080/heartbeat') failed: Empty reply from server (curl-error = 'Server returned nothing (no headers, no data)' (52))

2009-04-16 15:48:31: (critical) network-io.c:220: curl_easy_perform('http://agent:agent@10.89.20.42:18080/heartbeat') failed: Send failure: Broken pipe (curl-error = 'Failed sending data to the peer' (55))

I don't know why it was happened.]]> jongse park MySQL Monitor Mon, 20 Apr 2009 01:40:14 +0000 http://forums.mysql.com/read.php?142,258421,258421#msg-258421 http://forums.mysql.com/read.php?142,258421,258421#msg-258421 Scott Saccone MySQL Monitor Sat, 18 Apr 2009 17:29:04 +0000 http://forums.mysql.com/read.php?142,252199,252199#msg-252199 http://forums.mysql.com/read.php?142,252199,252199#msg-252199
I just want to know if is posible to use MYSQL ENTERPRISE MONITOR on MYSQL CLUSTER, is there any version free for 30 or 60 days? or something else?

Thank you.]]> Fernando Figueroa MySQL Monitor Thu, 12 Mar 2009 05:29:00 +0000 http://forums.mysql.com/read.php?142,250764,250764#msg-250764 http://forums.mysql.com/read.php?142,250764,250764#msg-250764 http://blog.wl0.org/?p=56]]> Edwin DeSouza MySQL Monitor Wed, 04 Mar 2009 02:21:24 +0000 http://forums.mysql.com/read.php?142,249782,249782#msg-249782 http://forums.mysql.com/read.php?142,249782,249782#msg-249782
I have one master and two slaves configured and all agents are installed and running on the local DB servers.

However, I am getting "No replication groups" on the Replication tab of the dashboard.

It seems the auto-discovery in MySQL Monitor is not happening.

Anybody experienced a similar issue before? Thanks]]> Wayne W MySQL Monitor Thu, 26 Feb 2009 03:09:17 +0000 http://forums.mysql.com/read.php?142,241278,241278#msg-241278 http://forums.mysql.com/read.php?142,241278,241278#msg-241278
Example: If I have a physical server with multiple MySQL instances installed (say ports 3306 and 3307), and I monitor both of them, should that require one license or two?]]> Mark Filipi MySQL Monitor Fri, 09 Jan 2009 16:45:39 +0000 http://forums.mysql.com/read.php?142,239171,239171#msg-239171 http://forums.mysql.com/read.php?142,239171,239171#msg-239171
I am running a trial version of the Query analyzer to see if it's worth upgrading our current subscription plan, but I am having some trouble getting it started. I installed the monitor on a windows desktop and installed the Agent on a linux machine along with MySQL 5.0.45. However, I keep getting "MySQL Agent Not Communicating With Database Server" events and the server shows as down in my monitor dashboard.

I am able to login through the proxy (port 4040) and issue commands on this linux box, so it appears to me that the agent is working fine. I have also followed all the troubleshooting steps in the docs to make sure the agent is running and communicating with the databse and have not had any success. Currently, my manage servers screen says this:

Server Query Analyzer MySQL Up Since Last MySQL Agent Last Agent
10.5.5.81:3306 On On On 5.0.45 Stopped 2.0.0.7111 Dec 18, 2008 5:53:55 PM

How can I get the agent to report the proper Mysql Status?]]> Mike Marinescu MySQL Monitor Mon, 09 Feb 2009 12:46:39 +0000 http://forums.mysql.com/read.php?142,237753,237753#msg-237753 http://forums.mysql.com/read.php?142,237753,237753#msg-237753
I've got some errors when installing agent under RedHat 7.2.

The system :

Red Hat Linux release 7.2 (Enigma)
2.6.24.5-grsec-xxxx-grs-ipv6-32
GNU C Library stable release version 2.2.5



The error messages :
==================================

Installing
0% ______________ 50% ______________ 100%
########################################Warning: Problem running post-install step. Installation may not complete
correctly
Error running /opt/mysql/enterprise/agent/bin/mysql-monitor-agent
--defaults-file=/opt/mysql/enterprise/agent/etc/mysql-monitor-agent.ini
--plugins=agent --agent-generate-uuid=true :
/opt/mysql/enterprise/agent/sbin/mysql-monitor-agent: relocation error:
/usr/lib/libreadline.so.4: undefined symbol: BC

==================================

Thanks for your anwers.

Laurent]]> Laurent PETIET MySQL Monitor Wed, 10 Dec 2008 19:06:02 +0000 http://forums.mysql.com/read.php?142,231042,231042#msg-231042 http://forums.mysql.com/read.php?142,231042,231042#msg-231042
I have successfully installed the MySQL enterprise monitor and the agents on my databases servers. It seems by deafult the heartbeat interval is 10 seconds. Where can i specify the heartbeat interval if i need to increase the interval from 10 seconds to 1 min.

Thanks]]> megha gupta MySQL Monitor Tue, 21 Oct 2008 15:19:55 +0000 http://forums.mysql.com/read.php?142,223416,223416#msg-223416 http://forums.mysql.com/read.php?142,223416,223416#msg-223416 http://blogs.sun.com/kay/entry/agent_vs_agent_less_monitoring]]> Edwin DeSouza MySQL Monitor Thu, 21 Aug 2008 16:12:37 +0000 http://forums.mysql.com/read.php?142,223415,223415#msg-223415 http://forums.mysql.com/read.php?142,223415,223415#msg-223415
-----------------------------------------------

MySQL Enterprise Monitor:
- Trial (30-days): http://www.mysql.com/trials/enterprise
- Demo: http://www.mysql.com/products/enterprise/demo.html
- Info: http://www.mysql.com/products/enterprise/monitor.html
- FAQ: http://www.mysql.com/products/enterprise/faq.html#monitor
- Docs: http://dev.mysql.com/doc/mysql-monitor/2.0/en/index.html
- Forum: http://forums.mysql.com/posting.php?142

MySQL Enterprise Monitor: Features
http://mysql.com/products/enterprise/monitor-features.html

MySQL Enterprise Monitor: Benefits
http://mysql.com/products/enterprise/benefits.html

Agent vs agent-less monitoring
http://blogs.sun.com/kay/entry/agent_vs_agent_less_monitoring

MySQL Enterprise Monitor: Grouping by Arbitrary Time Ranges (Graphing What You Can See)
http://www.markleith.co.uk/?p=290

MySQL Enterprise Monitor: Agent = Extensibility
http://theopenproductmanager.blogspot.com/2008/08/mysql-enterprise-monitor-agent.html

MySQL Enterprise Monitor: Agents, Hosts and Instances, Oh My!
http://blogs.sun.com/DatabaseEmporium/entry/agents_hosts_and_instances_oh

Reflections on MySQL Enterprise Monitor
http://blog.wl0.org/?p=56]]> Edwin DeSouza MySQL Monitor Thu, 21 Aug 2008 16:12:05 +0000 http://forums.mysql.com/read.php?142,222265,222265#msg-222265 http://forums.mysql.com/read.php?142,222265,222265#msg-222265
I am curious if anybody knows what the RAM usage graph in Enterprise Monitor actually tracks. It doesn't seem to be tracking status variables - but am I missing something?

thanks in advance for your replies,

barzel]]> barzel tindall MySQL Monitor Wed, 13 Aug 2008 06:51:39 +0000