サクサク読めて、アプリ限定の機能も多数!
トップへ戻る
体力トレーニング
blog.koehntopp.info
This is part 5 of a series. “1974 ” on the traditional Unix Filesystem. “1984 ” on the BSD Fast File System. “1994 ” on SGI XFS. “Vnodes ” on how to have multiple filesystems in Unix. Progress is sometimes hard to see, especially when you have been part of it or otherwise lived through it. Often, it is easier to see by comparing modern educational material and the problems discussed with older mat
So you talk to a database, doing transactions. What happens actually, behind the scenes? Let’s have a look. There is a test table, and we write data into it inside a transaction: CREATE TABLE t ( id serial, data varbinary(255) ) START TRANSACTION READ WRITE INSERT INTO t ( id, data ) VALUES (NULL, RANDOM_BYTES(255)) COMMIT The MySQL test instance we are talking to is running on a Linux machine, an
MySQL speaks its own proprietary protocol. It cannot be routed by an HTTP proxy, and a MySQL connection is entire unlike an HTTP connection. Specifically, a lot of state and configuration is tied to a MySQL connection, and it cannot be recovered on disconnect. What state is tied to a connection? Transactions A disconnect implies a ROLLBACK. So if you are in a transaction, all changes to the databa
このページを最初にブックマークしてみませんか?
『Die wunderbare Welt von Isotopp | Die wunderbare Welt von Isotopp』の新着エントリーを見る
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く