Re: [Spam][78.6%] Re: Differences between 2 MySQL instances

From: "Joerg Bruehe" Hi! Octavian Rasnita wrote: I have tried, but with no difference. I have changed some indexes and made the queries run faster, but I still found a problem: I use a module that does paging and it makes a select(*) and this query takes a very long time. I have also t

Re: Differences between 2 MySQL instances

ge - > From: John Daisley > To: Octavian Rasnita > Cc: mysql@lists.mysql.com > Sent: Wednesday, June 23, 2010 3:55 PM > Subject: Re: Differences between 2 MySQL instances > > > Have you tried running 'OPTIMIZE TABLE' on the tables in question

Re: Differences between 2 MySQL instances

Rasnita Cc: mysql@lists.mysql.com Sent: Wednesday, June 23, 2010 3:55 PM Subject: Re: Differences between 2 MySQL instances Have you tried running 'OPTIMIZE TABLE' on the tables in question to make sure statistics are up to date. I would expect the vast majority of queries to

Re: Differences between 2 MySQL instances

Have you tried running 'OPTIMIZE TABLE' on the tables in question to make sure statistics are up to date. I would expect the vast majority of queries to run faster on MySQL 5.1 (with identical settings, hardware and operating system). 2010/6/23 Octavian Rasnita > Hello, > > I have the followi

Differences between 2 MySQL instances

Hello, I have the following table under MySQL 5.1.43-community under Windows, and under MySQL 5.0.82sp1 Source distribution under Linux): CREATE TABLE `table_name` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tip_ticker` tinyint(1) NOT NULL, `symbol` varchar(20) NOT NULL, `market` varcha