Re: MyISAM vs InnoDB - Index choice and Huge performance difference

2007-11-26 Thread Edoardo Serra
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

Re: MyISAM vs InnoDB - Index choice and Huge performance difference

2007-11-26 Thread Edoardo Serra
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

Re: MyISAM vs InnoDB - Index choice and Huge performance difference

2007-11-26 Thread Edoardo Serra
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,

MyISAM vs InnoDB - Index choice and Huge performance difference

2007-11-25 Thread Edoardo Serra
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]

Re: SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

2007-08-29 Thread Edoardo Serra
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

Index usage - MyISAM vs InnoDB

2007-08-25 Thread Edoardo Serra
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]

Query cache problem with stored procedures

2007-08-19 Thread Edoardo Serra
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

Issue with locking and INSERT DELAYED

2007-05-15 Thread Edoardo Serra
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