Re: Optimizer Bug?

much like Bill Clinton, what exactly does "ALL" mean, then? -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: Optimizer Bug?

always refers to what /will/ happen, and "rows" refers to how many rows /might/ be looked at. Thanks. -- David Hillman LiveText, Inc 1.866.LiveText x235

Optimizer Bug?

e rows? How can it look at more than "ALL" rows? Why does dropping an index that it wasn't using change, well, anything? Can someone make some sense of this for me? This is on version 4.1.18. Thanks. -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: First View

and found nothing, so hopefully someone here can help... where can I download MySQL 10 from? ;) -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: Slave Replication issues

0:00', 'author')'. Default database: 'manuscript_central_1_1' One of the indexes on your 'permissions' table in defined to be 'unique', and your application is trying to insert a row with a duplicate value. This doesn't seem like a rep

Re: Row count discrepancy when converting from MyISAM to InnoDB

only maintains an estimate of the number of rows in each table. This is why "select count(*) from table" takes a long time on big InnoDB tables. Usually the InnoDB count will be off by 50% or so. http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html -- David Hillman Live

Re: 'on duplicate key update' and 'last_insert_id'

_INSERT_ID ();" then I don't get the id of the 'updated' table, I get the *next* auto increment value. Is the last bit a bug? Yes, http://bugs.mysql.com/bug.php?id=19243 -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: Backups with MySQL/InnoDB

, compressed, fast, no-max-size. ( In order ) -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: Timeseries

to be how to get multiple "last-timestamped records", and I don't think that answer will be elegant. -- David Hillman LiveText, Inc 1.866.LiveText x235

Re: Two fast queries combined = slow?

You are the man, Joe. The wall next to my desk thanks you, for stopping me from continuing to beat my head against it. -- David Hillman LiveText, Inc 1.866.LiveText x235 On Nov 22, 2005, at 7:50 PM, Joseph Cochran wrote: Subqueries in 1.4.14 don't use indexes, instead performing

Two fast queries combined = slow?

going on? Thanks. ( MySQL 4.1.14 on various systems ) -- David Hillman LiveText, Inc 1.866.LiveText x235