Skip to content Skip to sidebar Skip to footer
Showing posts with the label Innodb
Problems With Order By Rand() And Big Tables

Problems With Order By Rand() And Big Tables

Post a Comment
Hello I asked a question this morning, and I realized that the problem was not where I was looking … Read more Problems With Order By Rand() And Big Tables
Mysql With Innodb: How To Avoid Using Count?

Mysql With Innodb: How To Avoid Using Count?

Post a Comment
So I have a table which I populated with ~700K entries for testing, and it is showing it's pain… Read more Mysql With Innodb: How To Avoid Using Count?
Does Django Create Implicit Transaction On First Query?

Does Django Create Implicit Transaction On First Query?

Post a Comment
I have django 1.3.1, python2.6 and MySQL 5.5.20. init_command in setting.py is set to SET storage_e… Read more Does Django Create Implicit Transaction On First Query?
"the Total Number Of Locks Exceeds The Lock Table Size" Deleting 267 Records

"the Total Number Of Locks Exceeds The Lock Table Size" Deleting 267 Records

Post a Comment
I'm trying to delete 267 records out of about 40 million. The query looks like: delete from pr… Read more "the Total Number Of Locks Exceeds The Lock Table Size" Deleting 267 Records
How To Guarantee Concurrent Threads Dont Get The Same Value In Mysql?

How To Guarantee Concurrent Threads Dont Get The Same Value In Mysql?

Post a Comment
Lets say the last row in my orders table is Order_ID Product 555 Apple How can I m… Read more How To Guarantee Concurrent Threads Dont Get The Same Value In Mysql?
Find Out Which Tables Were Affected By Triggers

Find Out Which Tables Were Affected By Triggers

Post a Comment
In MySQL (particularly InnoDB) is there any way to know which tables were affected (updated / delet… Read more Find Out Which Tables Were Affected By Triggers