lldate BETWEEN '2007-07-01 00:00:00' AND '2007-07-30 23:59:59'
)
GROUP BY day, disposition;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 25, 2007 10:03 PM
To: Edoardo Serra
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM v
ssage-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 25, 2007 10:03 PM
To: Edoardo Serra
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM vs InnoDB - Index choice and Huge performance difference
just want to take a note on 4Gbytes
What kernel u use?
4Gbytes or bigger m
means nothing on your MySQL, because if your kernel
is not compiled using correct patch or simply use CentOS/RHEL, then
your MySQl will limited to use up to 2Gbytes only, so 4Gbytes -->
2Gbytes is useless
On 11/25/07, Edoardo Serra <[EMAIL PROTECTED]> wrote:
Hi everybody,
ent array of disks on a different channel, etc...
Im using MySQL 5.0.32 on a Debian stable.
Tnx in advance for help
Regards
Edoardo Serra
WeBRainstorm S.r.l.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Krishna,
you can use MySQL binlog to see queries that made changes to db data
Hope it helps
Regards
Krishna Chandra Prajapati ha scritto:
Hi All,
Is there is any script or tool that generate the report and send an email
for changes done in the databases;
There is any otherway (man
11 sec)
Another strange thing is that the EXPLAIN on InnoDB says the table has
5016758 rows but a SELECT count(*) returns 4999347 rows (which is the
correct number)
Tnx in advance for help
Regards
Edoardo Serra
WeBRainstorm S.r.l.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hing after variable substitution
but I'm not aware of MySQL internals to judge if this is the correct
behaviour.
P.S: I noticed that MySQL caches without problems queries contained in
stored procedures which does not contains variables.
Tnx in advance for help
Regards
Edoardo Serra
WeB
T
[...]
Thread #6 is running the slow report query but other SELECTs are Locked
(1, 3, 4)
I see thread #2 is 'Upgrading lock', is that locking the other SELECTs ?
Why is that happening ? Shouldn't MyISAM support INSERTs without READ
LOCKING the tables ?
I'm using MySQL
