ala888 Posted July 23, 2014 Share Posted July 23, 2014 in the mysql manual it states that concurrent inserts only occur when no holes are present within a table? what are these 'holes' that the developers refer to? do they mean auto increment holes? if so, if a table does not have auto increment columns, does this mean it is impossible for it to have holes? Link to comment Share on other sites More sharing options...
niche Posted July 23, 2014 Share Posted July 23, 2014 http://dba.stackexchange.com/questions/20745/how-does-mysql-decide-if-concurrent-insert-is-possible-for-a-myisam-table Link to comment Share on other sites More sharing options...
ala888 Posted July 23, 2014 Author Share Posted July 23, 2014 what are these 'holes/gaps' that the developers refer to? do they mean auto increment holes? Link to comment Share on other sites More sharing options...
justsomeguy Posted July 23, 2014 Share Posted July 23, 2014 Do you want people to just quote what the documentation says? Because it doesn't say anything about specifying auto-increment. Link to comment Share on other sites More sharing options...
niche Posted July 24, 2014 Share Posted July 24, 2014 ? Link to comment Share on other sites More sharing options...
ala888 Posted July 24, 2014 Author Share Posted July 24, 2014 so what are the holes then? when a row gets deleted, why is there a hole? If not self-increment - what on earth results in their creation ? Link to comment Share on other sites More sharing options...
justsomeguy Posted July 24, 2014 Share Posted July 24, 2014 when a row gets deleted, why is there a hole?Why wouldn't there be? There is allocated memory there, the record gets deleted, and now that memory doesn't have anything in it. Just like if you delete a file. The memory that held the file data is now free again, it's not allocated to a file. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now