I need to create an index on a ~5M rows MySQL table. It is a production table, and I fear …
mysql indexing production alter-table table-lockingAccording to the MySQL manual: For large tables, table locking is often better than row locking, Why is this? I …
mysql locking table-lockingI have menus, categories and products tables. I am using mysql 5.5, All tables are innoDB and in all cases id …
mysql locking database-deadlocks table-lockingI use laravel5.5's database transaction for online payment application. I have a company_account table to record each payment(…
php database laravel transactions table-lockingI have a very large set of data (~3 million records) which needs to be merged with updates and new records …
performance sql-server-2008 merge table-locking large-dataThis was my original question: I am trying to figure out how to enforce EXCLUSIVE table locks in SQL Server. …
sql-server tsql table-lockingHow to know the health of the mysql db by seeing the "Table_locks_immediate" and "Table_locks_waited" values …
mysql database table-lockingI am developing an application which fetches some data from a Teradata DWH. DWH developers told me to use LOCK …
teradata rowlocking table-lockingI'm using innoDB on AWS. I keep getting a ton of the following messages in my logs: Waiting for table …
mysql innodb table-locking database-engineI must export data from a partitioned table with global index that must be online all the time, but I …
oracle oracle11g database-partitioning table-locking