… of outages can happen? Someone runs UPDATE or DELETE and forgets the where clause or filters …the position you are in the master’s bin logs –compress option, compresses on the fly …Re-transfer files that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL I …
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
… to quickly parse the binary log files, extracting the relevant statements. mysqlbinlog bin_log.000001 | mysqlsla -lt binary – …UPDATE *************************** 2. row *************************** trigger_name: Foo_Delete event_object_table: Foo Event_Manipulation: DELETE So whats the problem with …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data…binary logging is required for replication log-bin=db1-bin log-bin-index=db1-bin.index binlog-ignore-db=chrome…of the master.info file, unless you shutdown # the slave server, delete master.info and restart…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… database with row-based logs. Take as an example a DELETE statement which does not modify any rows. No binary logging… error (many fields omitted): SHOW SLAVE STATUS\G Relay_Log_File: mysql_sandbox25162-relay-bin.000002 Relay_Log_Pos: 340718 Slave_SQL_Running: No… slave is currently executing at relay log file: mysql_sandbox25162-relay-bin.000002 at position: 340718. MySQL 5.1 ships with a new version…
Comment: xtrabackup-1.2
May 10, 2010 By 2 Comments
… a error.how to resovle it? OS: centos , MYSQL :MYSQL 5.1.30 ./bin/xtrabackup Ver 1.2 Rev undefined for 5.1… log files, shut down the InnoDB: database and make sure there were no errors in shutdown. InnoDB: Then delete the existing log files. Edit the .cnf file InnoDB: and start the database again. xtrabackup…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…workload (benchmark emulates intensive insert/delete queries). By our results …MySQL parameters: [mysqld] #mysqld options in alphabetical order user=root default_table_type=MYISAM innodb_buffer_pool_size=6G innodb_data_file…/data/vadim/benchwork/benchmarks/sysbench/bin/sysbench –num-threads 1 –max…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…had to transform files to quote each field. After that load statement is: mysql -S /tmp/mysql-ib.sock -…up with next load statement: /usr/local/monetdb/bin/mclient -lsql –database=ontime -t -s “COPY …to note that MonetDB supports all INSERT / UPDATE / DELETE statements (and space is price for that as…
