Search code examples
mysqlqueueinnodbmyisam

mysql db types for queue simulation

I am simulating several instruction queues using a mysql table. There is a 'mode' column which is the name for each queue and once items are taken from the queue they are deleted right afterwards. Typical queries look like 

SELECT * FROM queue_table WHERE mode='queue1' LIMIT 50.

I am currently using a MYISAM table for this but there is a lot of overhead with all the deleting and optimization takes a long time. I was just wondering if there was a more efficient way to do this and if maybe the database should be INNODB.

Solution

  • InnoDB are useful if your are implying Foreign key constraints . so one thing for optimizing you Query..

    create index onmode column and also dont use * ( may be your table have a lots of columns), write column name which you only need to retrive.