Transactions in wordpress database
Wordpress is using MyISAM storage engine. MyISAM does not support transactions.
How wordpress is maintaining transactions?
I mean if wordpress is having two database write operations, how does it ensure atomicity?
Well, as far as I can tell, it doesn't! The only reason there are not much problems with this is, that most write operations are done with a single insert or update (adding a comment, creating a new post...).
In general, most web applications I have seen so far, don't bother too much with transactions, atomicity or even referential integrity, which is quite sad. On the one hand it is sad that so many applications just rely on pure luck that nothing bad happens and on the other hand it might lead to the impression that all these techniques aren't that important when it comes to database stuff.
I would think the transaction would assure atomic correctness at the previous layer of abstraction. When a transaction is occurring it default locks what it is writing. I'm not sure though.
ReferenceURL : https://stackoverflow.com/questions/700423/transactions-in-wordpress-database
'sourcetip' 카테고리의 다른 글
| Jasmine을 사용한 각도 단위 테스트: spyOn 제거 또는 수정 방법 (0) | 2023.02.27 |
|---|---|
| Create nested JSON arrays using FOR JSON PATH (0) | 2023.02.27 |
| Jest: mocking console.error - tests fails (0) | 2023.02.27 |
| AngularJS : ng-click not working (0) | 2023.02.27 |
| A general linux file permissions question: Apache and WordPress (0) | 2023.02.27 |