June 19, 2013

Post: More on MySQL transaction descriptors optimization

…we saw previously. Note that the single-node configuration used 16 threads (8 cores on a single … the list of transactions to be either empty or very short, which basically implies a fully read-only …5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and indices to…

Post: Ultimate MySQL variable and status reference list

…Com_empty_queryblogpercona…data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data…files_on_…log_short_formatblogpercona…slave_type_…

Post: Picking datatype for STATUS fields

…the stored value is often short the full specified … about two important types of these status fields…often allows to save on the storage and get…is also worth to note ENUM comes with couple … always converted to ” – empty string, the additional ENUM… with further meta data, for example descriptive help…