mysql

InnoDB Data Locking – Part 4 “Scheduling” In this blog series, I’m describing how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, and how this was improved in recent releases. As we’ve already seen, the order in which server pretends transactions are happening (the serialization order) is tied to the order in which locks are granted to transactions.… Facebook Twitter LinkedIn Source: InnoDB Data Locking – Part 4 “Scheduling”

InnoDB Data Locking – Part 3 “Deadlocks” In this  blog series, I’m describing how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, and how this was improved in recent releases. In InnoDB Data Locking – Part 1 “Introduction” I’ve introduced basic concepts required to understand current post: databases, tables, rows (like files on a shared drive, spreadsheets inside a file, and rows inside a spreadsheet) serializability of transactions (ability to explain states observed over time with a convincing story about relative order of parallel operations) timeouts (for misbehaving lock owners, and to resolve deadlocks) reader-writer lock (shared/exclusive access rights) starvation (permanent inflow of readers starving a writer waiting for its turn) queueing (FIFO, or priority) read views (read-only snapshots which allow stale reads concurrent to new writes) [ more… ]

MySQL Shell 8.0.23 – What’s New? The MySQL team is proud to announce the general availability of version 8.0.23 of the MySQL Shell. In addition to a considerable number of bugs fixed, the following changes were introduced. Improved Import Table The importTable utility continues getting better, the following enhancements: Multiple file import: it is now supported to load a defined set of files into the same table, glob patterns can be used to determine the files to be loaded. … Facebook Twitter LinkedIn Source: MySQL Shell 8.0.23 – What’s New?

A 250x improvement to tablespace truncation in MySQL Server 8.0.23 In MySQL Server 8.0.23 an improvement was made to InnoDB that allows truncation and deletion of all tablespaces to be faster. In fact, making it almost instantaneous as long as AHI is disabled. This is done by allowing pages in the buffer pool to be freed lazily instead of immediately when a tablespace is deleted.… Facebook Twitter LinkedIn Source: A 250x improvement to tablespace truncation in MySQL Server 8.0.23