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
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
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
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
On Wed, Jun 14, 2006 at 11:00:36PM +0100, Graham Reeds wrote:
> Dan Buettner wrote:
> >Graham, I seem to recall those single quote marks working without a
> >problem on various platforms and versions of MySQL. Of course they are
> > generally just a nicety and only required if you are using rese
Dan Buettner wrote:
Graham, I seem to recall those single quote marks working without a
problem on various platforms and versions of MySQL. Of course they are
generally just a nicety and only required if you are using reserved
words as table/column/key names, so you could just remove them ent
Graham Reeds wrote:
I have posted a similar question on the blojsom group but I feel I will
have better chance of an answer here.
Blojsom 3 was developed using MySQL5 for it's back end. However the
host I am with uses 4.0.25 and are unwilling to upgrade - which is fair
enough.
So I decided
Graham, I seem to recall those single quote marks working without a
problem on various platforms and versions of MySQL. Of course they are
generally just a nicety and only required if you are using reserved
words as table/column/key names, so you could just remove them entirely.
Could you po
On 2006-01-20, at 01:13, Tucker Cunningham wrote:
So, my question is: what are the pros and cons of using varchar
vs. text/longtext? Right now, longtext seems to be the best option
(it provides most flexibility in data that can be stored, at only a
2-byte-per-row storage premium) There
Joerg Bruehe wrote:
Hi Dan, all!
Dan Trainor wrote:
Thanks for the prompt reply, Augusto -
I completely understand what you're saying. To have anything such as
a real-time measurement to the exact number of tables would be an
incredible preformance degration, not to mention overhead and th
Hi Dan, all!
Dan Trainor wrote:
Thanks for the prompt reply, Augusto -
I completely understand what you're saying. To have anything such as a
real-time measurement to the exact number of tables would be an
incredible preformance degration, not to mention overhead and the like.
Right.
This
Thanks for the prompt reply, Augusto -
I completely understand what you're saying. To have anything such as a
real-time measurement to the exact number of tables would be an
incredible preformance degration, not to mention overhead and the like.
I think I'm willing to accept the fact that wh
James Harvard wrote:
I suppose this is an inherent limitation of transactional tables - you might
see x rows, but at the same time a use who has just inserted some rows will see
x+y rows.
However I don't see that the numbers are going to be hugely inaccurate. After
all, if the table was MyISA
I suppose this is an inherent limitation of transactional tables - you might
see x rows, but at the same time a use who has just inserted some rows will see
x+y rows.
However I don't see that the numbers are going to be hugely inaccurate. After
all, if the table was MyISAM and you get an exact
Dan Trainor wrote:
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table', I see 17203 - a diff
Hi -
Anyone else get the following message with *ever*single*post* to the
list? Anyone have a procmail filter established already? ;)
Thanks
-dant
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED]
If you really intend for this to get to me, remove the 'no' in the eMail address
above & I'll send
Dan Trainor wrote:
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table', I see 17203 - a diff
On Fri, 16 Sep 2005 10:32:23 -0400
[EMAIL PROTECTED] wrote:
> You asked basically two questions:
>
> a) what are the differences between ORACLE SQL plus and MYSQL?
> depends on how they are with MySQL already. One well-known point on
how
> MySQL and Oracle differ is in how to define a JOIN in
Phong Nguyen <[EMAIL PROTECTED]> wrote on 09/15/2005 10:56:57 AM:
> All,
>
> Could you please tell us what are the differences
> between ORACLE SQL plus and MYSQL SQL? We developed
> application using ColdFusion with Oracle. Now I like
> to point my application to mysql database. How do I
> fix m
Hi,
> Could you please tell us what are the differences
> between ORACLE SQL plus and MYSQL SQL? We developed
"oracle sql plus" is a client side application to execute SQL statements.
"oracle sql" is Oracles version of standard SQL (which is not standard)
and "mysql sql" is MySQLs version of sta
On Monday 18 March 2002 4:22 pm, [EMAIL PROTECTED] wrote:
> Everyone,
>
> What's the differences with MySQLD and MySQL-max?
MySQL-max supports more table types.
-
Before posting, please check:
http://www.mysql.com/manual.php
21 matches
Mail list logo
