Linked Questions
10 questions linked to/from Benefits of table level locking
281
votes
10
answers
286k
views
What are the main differences between InnoDB and MyISAM?
What are the main differences between InnoDB and MyISAM?
10
votes
2
answers
70k
views
way to prevent queries from waiting for table level lock
We've encountered a problem after moving the database of our customer to an extra server. This should have had positive effects on the site's performance, but there is a problem with table locking in ...
8
votes
1
answer
11k
views
Do you still use MyISAM or prefer Aria storage engine?
If Aria storage engine (previously called Maria) is the "new" MyISAM, which supports transaction and automatic crash recovery:
Why still use MyISAM ?
Should changing storage engine from MyISAM to ...
6
votes
2
answers
6k
views
mysql transaction vs lock
I have a question regarding MySQL locking and transaction management.
My Question is ..does mysql takes lock on the the tuple/table on which I am doing select/update in a transaction ?
5
votes
1
answer
1k
views
Should I use a storage engine other than MyISAM to optimise these tables or should I get better disks?
There's a production database I'm working on, whose 4 largest tables contain between 4 million and 10 million rows each and about 15 fields each, with indexes on different field types (numbers, ...
2
votes
2
answers
1k
views
Any problem will all InnoDB and one MyISAM table?
I have a MySQL 5.5 DB with all InnoDB tables. For some reason, one of the developers decided to create a MyISAM table. It is a log table for user sessions. I don't see why we should mix in a MyISAM ...
1
vote
2
answers
994
views
MySQL UPDATE Performance Issue
I'm running out of ideas on a performance bottleneck I'm seeing on one of my projects.
The table in question is pretty small, with only 5396 records. However, I'm seeing queries like this show up in ...
1
vote
1
answer
2k
views
MySQL INSERTs waiting for UPDATEs (MyISAM)?
In show processlist;, MySQL 5.5, we see that INSERTs tend to wait for UPDATEs to complete before they can proceed. This is on MyISAM tables.
We tried INSERT HIGH_PRIORITY and UPDATE LOW_PRIORITY. ...
3
votes
1
answer
594
views
Mysql takes up to 50% cpu after aborting DELETE query
I have a problem I have never met before. I was clearing yesterday client's db and table with stats of visits that had 15GB of data. I decided to delete all rows older than 1 Feb, because we have all ...
0
votes
2
answers
667
views
Should we explicitly lock MyISAM tables or is it implicit....?
Does MyISAM tables automatically lock a table for each select or insert statement ....
I mean if I query the database as select * from tablename then does the MySQL engine first lock it for read ...