>Description:
If a thread grabs a lock on a table, the
__unlocked__ tables don't show properly in "show table status". In particular,
almost all fields (except for table name) are returned as NULL.
>How-To-Repeat:
show table status from mysql;
lock tables my
I have a very large table, where one of the columns is
color enum("red", "blue", "black")
The distribution of values is 90% black, 8% blue, and 2% red.
I want to be able to randomly select 10 rows matching a certain color from the table.
Of course,
select * from my_table where color = "bl
I have a very large table, where one of the columns is
color enum("red", "blue", "black")
The distribution of values is 90% black, 8% blue, and 2% red.
I want to be able to randomly select 10 rows matching a certain color from
the table.
Of course,
select * from my_table where color