Hi,
It's InnoDB on 5.0.51. The only thing I can think of that *may* be
different about this is that this index used to be on a composite key
(some_id, some_varchar) but then the VARCHAR column got dropped. Other
than that, it's just a plain index on an INT(11).
Morten
On Jun 16, 2009, a
Hi,
Is your table MyISAM or InnoDB?
Andrew
-Original Message-
From: Morten [mailto:my.li...@mac.com]
Sent: 15 June 2009 21:23
To: mysql@lists.mysql.com
Subject: The size of an index (INDEX_LENGTH)
Hi,
I dropped an index on a table with 25M records today. The INDEX_LENGTH
in informa
you're a genius! I had old_passwords=1 in my.cnf, changed it to 0,
restarted mysql, and then the users worked like a charm. thanks!
Little, Timothy wrote:
My theory would be that it's an OLD-PASSWORDS issue. It would seem that
you might have used the
old_passwords=1 in your original configur
My theory would be that it's an OLD-PASSWORDS issue. It would seem that
you might have used the
old_passwords=1 in your original configuration my.cnf but it's not in
your new configuration file.
-Original Message-
From: Adam Williams [mailto:awill...@mdah.state.ms.us]
Sent: Monday, June
I'm running Fedora 11 i386 with Mysql 5.1.32. I dumped my mysql
databases with:
mysqldump -u root -pxxx --lock-all-tables --all-databases >
/root/mysql-backup/all-db.sql
and then wiped the operating system and reinstalled. Then I ran
mysqladmin -u root password
to set my root pass
Hello List,
how can i get table "update_time" using innodb engine?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
In the last episode (Jun 15), Morten said:
> I dropped an index on a table with 25M records today. The INDEX_LENGTH
> in information_schema.tables shrank from 3834642432 to 3215982592, ie.
> ~618Mb difference
>
> The index was on an int(11) column.
>
> That means each index key takes up ~618M
Hi,
I dropped an index on a table with 25M records today. The INDEX_LENGTH
in information_schema.tables shrank from 3834642432 to 3215982592, ie.
~618Mb difference
The index was on an int(11) column.
That means each index key takes up ~618Mb/25M ~= 25 bytes but that
doesn't sound right?
On Mon, 15 Jun 2009 10:00:00 -0400
Jim Lyons wrote:
> There's an option called "init-file" that will invoke an sql script
> on start up. That would probably work for you.
Thanks you, that is what I was searching for. I guess I should clean my
glasses :)
--
MySQL General Mailing List
For list
Hi Bruce,
bruce wrote:
hi.
i've got a situation, where i'm trying to figure out how to select an item
from tblA that may/maynot be in tblB.
if the item is only in tblA, i can easilty get a list of the items
select * from tblA
if the item is in tblA but not linked to tblB, i can get the item
There's an option called "init-file" that will invoke an sql script on start
up. That would probably work for you.
On Mon, Jun 15, 2009 at 5:17 AM, Gabriel Linder wrote:
> Hi,
>
> I must call a routine when mysqld start (to populate a heap table). I
> did not find any related options in mysqld -
It sounds to me like you want to join the two tables?
http://dev.mysql.com/doc/refman/5.1/en/join.html
On Mon, Jun 15, 2009 at 03:56, bruce wrote:
> hi.
>
> i've got a situation, where i'm trying to figure out how to select an item
> from tblA that may/maynot be in tblB.
>
> if the item is only in
Hi Artem,
There can be many malicious factors at play here, but if you are
not using an index then definitely create on now. It will obviously
help you with option 1 and you can still benefit from it with option
2. If you don't have an index, MySQL has to search for you data row by
row which i
Hello!
I cannot figure out the fastest way to do a select on the floowing field:
f_spectinyint not null;
It is a table of 100 000 records of products and f_spec is set only for
about 200 products.
I figure it could be done in two ways:
1) create an index on f_spec and do simple
select *
Hi,
I must call a routine when mysqld start (to populate a heap table). I
did not find any related options in mysqld --help --verbose. Is there a
way to achieve this, without modifying the startup script ?
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
15 matches
Mail list logo
