Re: MySQL Monitor and Percona

2012-10-26 Thread Laurynas Biveinis
2012/10/25 Sabika M : > We are in the process of switching to percona binaries of MySQL . I am > using Percona 5.5.27 and monitoring the MySQL server with the MySQL > Enterprise monitor. It starts up fine, but after a while I end up with > MySQL monitor connections stacking up unti

RE: MySQL Monitor and Percona

2012-10-25 Thread Rick James
, 2012 4:15 PM To: Rick James Cc: mysql@lists.mysql.com Subject: Re: MySQL Monitor and Percona I don't have the full anymore. It had a few hundred of these. I had issues a drop database that hung which made me run show processlist. Sadly, I did not check the processlist beforehand. | 1

Re: MySQL Monitor and Percona

2012-10-25 Thread Sabika M
12 11:44 AM > > To: mysql@lists.mysql.com > > Subject: MySQL Monitor and Percona > > > > We are in the process of switching to percona binaries of MySQL . I am > > using Percona 5.5.27 and monitoring the MySQL server with the MySQL > > Enterprise monitor. It

RE: MySQL Monitor and Percona

2012-10-25 Thread Rick James
What does SHOW FULL PROCESSLIST say? What values do you have for max_connections wait_timeout (GLOBAL version) > -Original Message- > From: Sabika M [mailto:sabika.makhd...@gmail.com] > Sent: Thursday, October 25, 2012 11:44 AM > To: mysql@lists.mysql.com > Subject: My

MySQL Monitor and Percona

2012-10-25 Thread Sabika M
We are in the process of switching to percona binaries of MySQL . I am using Percona 5.5.27 and monitoring the MySQL server with the MySQL Enterprise monitor. It starts up fine, but after a while I end up with MySQL monitor connections stacking up until the server becomes pretty much useless. This

OPTMAX MySQL Monitor

2012-07-17 Thread Rodrigo Ferreira
(Only for portuguese speaker colaborators of this list. Para os colaboradores de língua portuguesa desta lista de discussão.) Prezados, Segue a divulgação de uma nova ferramenta para monitoramento e otimização de servidores de bancos de dados MySQL. Interface e suporte em português. Vale a pena

Re: Suse Linux (SLES10), Portuguese characters and "dead keys" in "MySQL monitor" in SSH sessions with Unicode (UTF-8)

2007-08-08 Thread Ricardo Dias Marques
Hi all, Here I am, following up to my own post - available below and at http://lists.mysql.com/mysql/208343 - with a solution (basically, a "workaround"). To summarize: I couldn't enter Portuguese accented characters in "MySQL monitor" (MySQL command line / console c

Suse Linux (SLES10), Portuguese characters and "dead keys" in "MySQL monitor" in SSH sessions with Unicode (UTF-8)

2007-07-31 Thread Ricardo Dias Marques
Hi all, First of all, sorry for the lengthy subject, but it serves to describe my problem: I'm having problems entering Portuguese accented characters (with a Portuguese keyboard) in "MySQL monitor" (MySQL command line / console client), when I'm in a SSH (Secure Shell)

Re: Starting mysql monitor on Windows 2000

2006-03-27 Thread Whil Hentzen
I'm trying to run the MySQL monitor in a DOS box and having no luck. I open a DOS box, and no matter what command I run, I do not get the nifty mysql> prompt that I can get on my Linux machine. Here are some permutations and the results (or lack thereof): c:\mysql\bin> mysql -u ro

Starting mysql monitor on Windows 2000

2006-03-27 Thread Whil Hentzen
Hi folks, I have MySQL 5.0.18 running like a charm on Win2K as a service. I've been connecting to it willy-nilly, creating databases and querying the daylights out of it. Working just dandy. I'm trying to run the MySQL monitor in a DOS box and having no luck. I open a DOS box, and

Re: Trying to run multiple statements through MySQL monitor

2004-04-18 Thread Jigal van Hemert
> Normally I'd write a > query with a sub select to get that information - something like this: Normally I'd NOT use a subquery ;-) > SELECT a.* > FROM table a > WHERE a.ssn IN (SELECT b.ssn FROM table b GROUP BY b.ssn HAVING > count(b.ssn) > 1); > > However, I don't have MySQL 4.1.x so th

Re: Fwd: Trying to run multiple statements through MySQL monitor

2004-04-17 Thread Michael Stassen
Adam wrote: All, I've got data listing people's identification details including first and last name, social, and status in the application. Given this data, I want to know how many duplicate socials I have. Normally I'd write a query with a sub select to get that information - something like

Fwd: Trying to run multiple statements through MySQL monitor

2004-04-17 Thread Adam
All, I've got data listing people's identification details including first and last name, social, and status in the application. Given this data, I want to know how many duplicate socials I have. Normally I'd write a query with a sub select to get that information - something like this: SELECT

Re: Mysql monitor

2004-03-03 Thread vpendleton
;>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 3/3/04, 9:24:20 AM, Peter <[EMAIL PROTECTED]> wrote regarding Mysql monitor: > Hi, > Due to poor database design and heavy load, database tables get corrupted a > lot.

Mysql monitor

2004-03-03 Thread Peter
Hi, Due to poor database design and heavy load, database tables get corrupted a lot. I want to monitor that process and once a table to get corrupted to repair it on the fly and send email to the support team that table is corrupted and reapired automatically including the hostaname, and mysql vers

re: Low Impact Security Exposure in MySQL Monitor

2003-01-23 Thread Egor Egorov
On Thursday 23 January 2003 05:12, George Toft wrote: > I have discovered an exposure in the history recall functionality of > MySQL Monitor. When a user uses MySQL monitor authenticated as the > database root user to issue commands, such as changing user passwords or > database ta

Low Impact Security Exposure in MySQL Monitor

2003-01-22 Thread George Toft
Greetings, I have discovered an exposure in the history recall functionality of MySQL Monitor. When a user uses MySQL monitor authenticated as the database root user to issue commands, such as changing user passwords or database table creation, that history can be recalled by a database user of

Mysql Monitor output from perl

2002-10-24 Thread Eric
Hi, There is a CPAN module that formats queries just like the mysql monitor does. I want this so that I can send some query results in emails without having to format them myself. But horror of horrors I can't find the module that I know is there which I noticed while browsing a short