June 19, 2013

Post: Ultimate MySQL variable and status reference list

…referring to the amazing MySQL manual, especially the option and variable reference table. But just as …_conversionsblogpercona.commanual Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query…

Post: MySQL Server Memory Usage

… execute queries or make operation to swap seriously slowing down. On now legacy 32bit platforms you … of tables. It also means user having CREATE TABLE privilege should be able to run MySQL server … record in the given table which is held until table is closed. Federated Storage Engine. This may …

Post: Percona Server 5.1.58-12.9

… evict and close another if the table cache is full. If the closed table was on the FEDERATED engine and a replication environment… #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused…

Post: Updated msl (microslow) patch, installation walk-through!

… ‘–with-federated-storage-engine’ ‘–without-bench’ ‘–with-zlib-dir=bundled’ ‘–with-big-tables‘ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql‘ ‘–with…time AND min_examined_row_limit AND log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults …