I have a table like so :
CREATE TABLE album_rank(
album_id INT NOT NULL,
rank INT NOT NULL,
KEY(album_id)
)
I want to query on the album_id & get the results ordered by rank but I
want to avoid doing an ORDER BY in the query because of the filesort
that it usually trigg
I recently switched to InnoDB & persistent connections from PHP.
Lately I've been getting these errors "Lock wait timeout exceeded; Try
restarting transaction" on an UPDATE on table. The system is in
development so there is at most one other user ( a back end Perl script).
When I switched PHP
I've been using InnoDB for the last week or so with good results & then
all of a sudden I started getting errors : table is full. I finally
tracked it down to the size of the IBD file which I had at the 400MB
default.
Does an IBD file expand out columns to their data type max size ? I hav
Sorry I confused read lock with locks that prevent other threads to read.
This is what I meant :
I have web sites where there are periodic inserts (& deletes ) of many
new records generated by crawlers.
In order to reduce the # of queries I do compound operations like
INSERT VALUES(a),(b),(c
I have web sites where there are periodic inserts (& deletes ) of many
new records generated by crawlers.
In order to reduce the # of queries I do compound operations like
INSERT VALUES(a),(b),(c), and DELETE FROM table WHERE record_id IN
($LONG_ID_LIST).
At the same as these operations are