table-locking

相关标签：javascript jquery android 多少钱 iPhone

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 分类：问答