Re: Mysql monitering and performance tool

2007-07-28 Thread Maxim Veksler
On 7/26/07, Baron Schwartz [EMAIL PROTECTED] wrote: krishna chandra prajapati wrote: Hi Everybody, I am looking for a tool which can moniter mysql and if any thing goes wrong with mysql then it can send a mail or alert. It can show the innodb status and all the complete details about

Re: Mysql monitering and performance tool

2007-07-28 Thread Mark Leith
Maxim Veksler wrote: On 7/26/07, Baron Schwartz [EMAIL PROTECTED] wrote: krishna chandra prajapati wrote: Hi Everybody, I am looking for a tool which can moniter mysql and if any thing goes wrong with mysql then it can send a mail or alert. It can show the innodb status and all the

Is MySQL Embedded the solution?

2007-07-28 Thread Car Toper
I am starting to do the RD on the next phase of development on my program and I am looking for a database and I am wondering if MySQL Embedded is the solution. The database needs to be embedded from the standpoint that when my application starts, so does the database, when mine shuts down, so

Migration of really old database.

2007-07-28 Thread Eric Berry
Hey all, I'm trying to help out a friend of mine who has a database based on powerbase - which is a really old database, and he said that the company has long since closed down. I was trying to see if I there was any way to import the data from there in to MySQL. He doesn't think there's any way

Re: Mysql monitering and performance tool

2007-07-28 Thread Baron Schwartz
Mark Leith wrote: Maxim Veksler wrote: On 7/26/07, Baron Schwartz [EMAIL PROTECTED] wrote: krishna chandra prajapati wrote: Hi Everybody, I am looking for a tool which can moniter mysql and if any thing goes wrong with mysql then it can send a mail or alert. It can show the innodb

RE: Is MySQL Embedded the solution?

2007-07-28 Thread Andrew Armstrong
You may want to consider SQLite if you have not seen it already. http://www.sqlite.org/ - Andrew -Original Message- From: Car Toper [mailto:[EMAIL PROTECTED] Sent: Sunday, 29 July 2007 7:10 AM To: mysql@lists.mysql.com Subject: Is MySQL Embedded the solution? I am starting to do the

Using index for group-by: Not working?

2007-07-28 Thread Andrew Armstrong
Hi, I have the following query: SELECT c2, c3, c4, Count(DISTINCT c5) FROM table1 WHERE c1 IN (1, 2, 3...) GROUP BY c2, c3, c4 order by null Yet I can only get it at best to show (under extra): Using where, using filesort. I have read up on:

Alternative to subquery to perform distinct aggregation in query

2007-07-28 Thread Andrew Armstrong
Hi, I have a query at the moment like this: SELECT SQL_NO_CACHE STRAIGHT_JOIN t1.col1, t1.col2, t2.col1, ... MAX(t1.col6)... ( SELECT Count(DISTINCT col1) FROM table3 t3 WHERE t3.col1 = t1.col1 AND t3.col2 = t1.col2 AND t3.col1 IN

RE: Using index for group-by: Not working?

2007-07-28 Thread Andrew Armstrong
Hey Terry, 1) I've tried placing the Count/Distinct bit first - no change. Could you elaborate on your bottom up parsing? I am not aware of this myself (and have not read this anywhere). Would be interested if you could elaborate or provide more info. 2) When a GROUP BY is performed, sorting is

RE: Using index for group-by: Not working?

2007-07-28 Thread Andrew Armstrong
It's just occurred to me that the IN clause is not a constant. This probably throws out any chance of using an index for group by? Cheers -Original Message- From: Andrew Armstrong [mailto:[EMAIL PROTECTED] Sent: Sunday, 29 July 2007 1:07 PM To: mysql@lists.mysql.com Subject: Using