… innodb_extra_rsegments=16 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=2048 sysbench parameters /data/vadim/benchwork/benchmarks…-mode complex –oltp-sp-name –oltp-read-only off –oltp-skip-trx off –oltp-range-size –oltp-point-selects –oltp-simple…-dist-pct –oltp-dist-res –db-ps-mode auto –mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…:259 ‘Aborted_clients’, ’267108′ ‘Aborted_connects’, ’25997′ ‘Binlog_cache_disk_use’, ’145′ ‘Binlog_cache_use’, ’9638599′ ‘Bytes_received’, ’2671219831′ ‘Bytes_sent’, ’2416986544…_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts‘, ’61′ ‘Com_show_slave_status’, ’13834′ ‘Com_show_status’, ’194766…_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache=512 # Default 64 was used before. skip-locking innodb…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…:59:05 [Note] WSREP: Read nil XID from storage engines, skipping position init 130221 17:59:05 [Note] WSREP: wsrep_load… existing ‘/var/lib/mysql//galera.cache‘. 130221 17:59:05 [Note] WSREP: Passing config to GCS: base_host = 192.168.14.150…; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug…
Comment: MySQL VIEW as performance troublemaker
May 6, 2010 By 57 Comments
… you do it before dumping data in the tables) 2. skip any where clause, or group by clause 3. drop off… multiple views, based on the column required 4. increase sql cache / memory (hosting providers … ahem ahem!) 5. do not mix views with…
