行級鎖 的英文怎麼說
中文拼音 [hángjísuǒ]
行級鎖
英文
row-level locking-
Lock hints rowlock, updlock, and xlock that acquire row - level locks may place locks on index keys rather than the actual data rows
獲取行級別鎖的鎖提示rowlock 、 updlock和xlock ,則可能對索引鍵而不是實際的數據行採用鎖。To fundamentally change this state of affairs, from the end of play today, the city ' s ad hoc campaigns to lock objectives : county - level cities undocumented units investigated rate was 100 %, the establishment of county - level cities of food and raw materials procurement request ledger card unit 100 %, on the use of dead livestock and poultry and their products and use of drug harmful substances processed foods coverage of the supervision and inspection of 100 % ; the county - level cities of graded supervision of food hygiene management system implementation rate of 95 % ; food units and rural farmers lok food operational behavior of the basic norms
為從根本上改變這種狀況,從即日起到年底,全市專項整治行動鎖定工作目標:縣城以上城市無證單位查處率100 % ,縣城以上城市建立食品原料采購索證和臺賬的單位100 % ,對使用病死畜禽及其製品和使用有毒有害物質加工食品行為的監督檢查覆蓋率100 % ;縣城以上城市食品衛生監督量化分級管理制度實施率95 % ;農村餐飲單位和農家樂餐飲經營行為基本規范。If table locking is not used, the default uses row - level locks, unless the
如果未使用表鎖定,默認使用行級鎖定,除非Each index record contains a five - byte header that may be preceded by a variable - length header. the header is used to link together consecutive records, and also in row - level locking
每個索引記錄包含一個五位元組的頭,在它之前還有一個變長的頭。這個頭是用來連接連續的記錄,也用於行級鎖。Derby is a 100 - percent java programming language rational database, and offers stored procedures and triggers, row - level locking, can perform transaction commits and roll - backs, and supports encryption
Derby是100 %的java編程語言關系數據庫,並提供了存儲過程和觸發器,行級鎖定,可以執行事務提交和回退操作,並支持加密。When readpast is specified both row - level and page - level locks are skipped
如果指定了readpast ,則將跳過行級別鎖和頁級別鎖。Using tablock causes a table - level lock to be taken for the duration of the bulk operation and eliminates the overhead of locking individual rows
使用tablock會導致在大容量操作期間進行表級鎖定,並消除按行鎖定的開銷。If the lock escalation attempt succeeds and the full table lock is acquired, then all heap or b - tree, page page, key - range, or row - level locks held by the transaction on the heap or index are released
如果鎖升級嘗試成功並獲取全表鎖,將釋放事務在堆或索引上所持有的所有堆或b樹鎖、頁鎖( page鎖) 、鍵范圍鎖( key鎖)或行級鎖( rid鎖) 。Through the chain services of the county librarywe can integrate the document collection resources of urban and rural areas, meet the demand of the cultural life of the rural masses, promote the development of socialist new rural constuction, enhance the peoples quality and create the development form of the grass - roots library business
摘要通過縣級圖書館與鄉鎮圖書館(室)實行連鎖服務,整合城鄉文獻館藏資源,滿足農村廣大群眾文化生活的需要,推進社會主義新農村建設的發展,提高全民素質,創新基層圖書館事業發展形式舉措。Serializability may not be implemented using only row - level locks ; there must be another mechanism that prevents a newly inserted row from becoming visible to a transaction that has already executed a query that would return the row
如果僅僅通過「行級鎖」是無法實現事務序列化的,必須通過其他機制保證新插入的數據不會被剛執行查詢操作的事務訪問到。Row - level locking is automatic
行級鎖定為自動。Row - level locks used
使用行級鎖定By default, row - level locking is used for data pages, and page - level locking is used for index pages
默認情況下,行級鎖定用於數據頁,頁級鎖定用於索引頁。After acquiring the stronger lock, all page - and row - level locks held by the transaction on the table are released
得到更強的鎖后,事務在表上所持有的所有頁級及行級鎖都將予以釋放。To support multiple applications accessing the same database at the same time, sql server mobile provides row - level locking of data pages, page - level locking, and isolation levels to help ensure data integrity during concurrency
為支持多個應用程序同時對同一數據庫進行訪問, sql server mobile提供了數據頁行級鎖定、頁級鎖定和隔離級別來幫助確保並發期間的數據完整性。Article 21 in the case of an animal epidemic of class i, the animal husbandry and veterinary administrative department under the local people ' s government at or above the county level shall dispatch its personnel to the scene forthwith to delimit the epidemic point, the epidemic area and the threatened area, collect epidemic materials, investigate into the epidemic source, report in time to the people ' s government at the same level for a decision of cordoning off the epidemic area, and report the epidemic situation and the related information level by level to the animal husbandry and veterinary administrative department under the state council
第二十一條發生一類動物疫病時,當地縣級以上地方人民政府畜牧獸醫行政管理部門應當立即派人到現場,劃定疫點、疫區、受威脅區,採集病料,調查疫源,及時報請同級人民政府決定對疫區實行封鎖,將疫情等情況逐級上報國務院畜牧獸醫行政管理部門。Innodb uses a finer grain of locking mechanism, row - level locking
Innodb使用更小粒度的鎖定機制行級別的鎖定。Specifies that a bulk update table - level lock is acquired for the duration of the bulk load operation ; otherwise, a row - level lock is acquired
指定在大容量加載操作期間獲取大容量更新表級別的鎖;否則,獲取行級別的鎖。There are little tricks one can do to increase concurrency, but if your applications need table - level or row - level locks, a dbms will better suit your needs
雖然有一些增加並發的技巧,但是,如果應用程序需要的是表級別或行級別的鎖定,那麼dbms能夠更好地滿足您的需求。Importing data in parallel with table level locking
>使用表級鎖定并行導入數據分享友人