…can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in …port = # # binary logging – not required for slaves, but recommended #log-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…:00 /bin/sh /usr/bin/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir… http://hackmysql.com/scripts/mysqlsla perl mysqlsla -lt slow /path/to/slow.log By default, this outputs the top 10 most expensive…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…GB – RAM 12 Core Processor 1TB – Disk My.cnf ========== freehold: [client] port=3323 socket=/…log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin…:a utoextend innodb_data_file_path=innodbspace1.dbf:1073741824;innodbspace2.dbf:…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…, mv mysqld mysqld.old, cp /debug_bin_path/mysqld ./mysqld, startup). If you …path/to/mysqld {mysqld options…} Note that ‘{mysqld options}’ could for instance include –default-file=/etc/my.cnf (if this is where your my.cnf…| ->27.73% (114,084,096B) 0x728DAA: Log_event::read_log_event(st_io_cache*, …
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…, starting replication in log ‘bin.000025′ at position 12410321, relay log ‘/var/log/mysql/relay.000086′ …GNU/Linux Also currently: these config (my.cnf) were all disabled from 20 servers: #…file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb_log_…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…15″ evict_outdated_slaves=”false” \ binary=”/usr/bin/mysqld_safe” test_user=”root” \ test_passwd=”rootpass…I had to define: config: The path of the my.cnf file. Remember that Pacemaker will start… (default value). In some cases, if slaves are logging replication updates, it may cause failover issues….
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… the same set of storage engines or default paths): (garfield:~/work) % env VISUAL=/bin/cat mysqlbug | grep ‘Configure command’ Configure command: ./configure… slow log options. This is the most important one as it enables the logging. If you don’t specify it in my.cnf file, the remaining part of the configuration will not matter, because the log…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…log MySQL Enterprise Server (Commercial) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/mysql datadir = /db/mydata tmpdir = /db-logs…log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql-bin expire_logs_days = 30 # Expire logs…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…log MySQL Enterprise Server (Commercial) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/mysql datadir = /db/mydata tmpdir = /db-logs…log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql-bin expire_logs_days = 30 # Expire logs…
Comment: Btw xtrabackup is not only backup..
February 13, 2010 By 13 Comments
…path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log…: you should now edit innodb_data_file_path in my.cnf back xtrabackup: to what it was,…: ibbackup child process has died at /usr/bin/innobackupex-1.5.1 line 464. I…
