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
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
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
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
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
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
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:
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
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
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
10 matches
Mail list logo