An article about MySQL InnoDB checkpoint-ing mechanism written by Perconna folks. Read comments as well, several PostgreSQL core committers have participated in the discussion.
“InnoDB’s checkpoint algorithm is not well documented. It is too co…
Posted in architecture, checkpoint, database, dba, innodb, mysql, postgresql, programming | Comments Off | permalink
Posted in architecture, checkpoint, database, dba, innodb, mysql, postgresql, programming | Comments Off | permalink
How MySQL InnoDB implements transaction log, aka REDO (Oracle), aka WAL (PostgreSQL)
Posted in database, databases, dba, innodb, internals, log, mysql, programming, redo, shortcut:mysql, translation, wal | Comments Off | permalink
Posted in database, databases, dba, innodb, internals, log, mysql, programming, redo, shortcut:mysql, translation, wal | Comments Off | permalink
blog posts that describes how MySQL InnoDB flushes data to disk (also see bgwriter, checkpoint_* parameters in PostgreSQL)
Posted in buffers, database, dba, inn, innodb, mysql, percona, performance, postgresql | Comments Off | permalink
Sysbench-based benchmark comparing OLTP workloads for different builds and forks of MySQL on 64-core intel machine (Quad Intel Xeon L7555 ) . Only one definitive result is that MySQL cannot scale beyond 8 or 16 cores, or in some cases beyond just 2 cor…
Posted in benchmark, intel, Linux, mariadb, mysql, percona, performance, scalability | Comments Off | permalink
[ENG] http://translate.google.com/translate?u=http%3A%2F%2Fwww.insight-it.ru%2Fmasshtabiruemost%2Farkhitektura-vkontakte%2F&sl=ru&tl=en&hl=&ie=UTF-8
some info about internals of vkontakte.ru – russian facebook clone, most popular soci…
Posted in architecture, development, highload, mysql, performance, scalability | Comments Off | permalink
An article from a well-known PostgreSQL developer comparing MySQL InnoDB and PostgreSQL table structures
Posted in architecture, article, comparison, database, dba, internals, mysql, postgresql, storage | Comments Off | permalink
Posted in jobs, mixpanel, mysql, ngixn, python, startup | Comments Off | permalink
SQL-proxy/filtering software for MySQL and PostgreSQL databases, used to prevent SQL-injection-like attacks, filter-out dangerous SQL, etc
Posted in database, firewall, mysql, opensource, Security, sql, sysadmin, tools | Comments Off | permalink
You are currently browsing the archives for the mysql category.
Konstantin Antselovich (c) 2004-2011
powered by WordPress
Entries (RSS)
and Comments (RSS).