table-locking
MySQL select with a count query on another table
I have simple article application with three tables: article id, title,body,user_id comment id, article_id, user_id,body[详细]
2023-04-12 01:50 分类:问答How to explicitly lock a table in Microsoft SQL Server (looking for a hack - uncooperative client)
This was my original question: I am trying to figure out how to enforce EXCLUSIVE table locks in SQL Server. I need to work around uncooperative readers (beyond my control, closed source stuff) which[详细]
2023-03-19 12:57 分类:问答Oracle Data Pump Export (expdp) locks table (or something similar)
I开发者_StackOverflow must export data from a partitioned table with global index that must be online all the time, but I am having troubles in doing that.[详细]
2023-03-17 05:44 分类:问答UPDATE query in MySQL on large table
I have a MySQL database with 21M records and I\'m trying to do an update on about 1M records but the query fails with ERROR 1206 (HY000): The total number of locks exceeds the lock table size.[详细]
2023-02-08 07:18 分类:问答How innodb tables are locked when ON INSERT trigger is processed?
I have two innodb tables: articles id| title| sum_votes ------------------------------ 1| art 1| 5 2| art 2| 8[详细]
2023-02-06 00:40 分类:问答Create an index on a huge MySQL production table without table locking
I need to create an index开发者_如何学Go on a ~5M rows MySQL table. It is a production table, and I fear a complete block of everything if I run a CREATE INDEX statement...[详细]
2023-01-26 12:33 分类:问答how to lock a DB table or a range of rows for writing?
I have a simple table with a primary key. Most of the read operations fetch one row by the exact value of the key.[详细]
2023-01-24 08:14 分类:问答Possible to select...for update, do e-commerce transaction, and then call a MySQL stored procedure in PHP?
I am currently building a PHP e-commerce website for my client. Its been going smoothly but I\'ve hit a roadblock and was wondering if any MySQL/PHP experts can help me. Basically, the e-commerce site[详细]
2023-01-03 14:57 分类:问答Locking a table with a select in Entity Framework
I need to do something like this select * from my开发者_JAVA技巧Table with (xlock,holdlock) using Entity Framework. Is this possible? I\'ve opened a TransactionScope with the Serializable isolation[详细]
2022-12-09 05:44 分类:问答