… database: mysql> CREATE DATABASE sakila2; Query OK, 1 row affected (0.00 sec) $ mysql sakila2 < schema.sql $ mysql sakila2 < data.sql ERROR 1235 (42000) at line 86: This version of MySQL doesn’t yet…-data sakila > schema.sql # Export data $ mysqldump –no-create-info –skip-triggers sakila > data.sql I’m quite surprised that such…
Comment: The story of one MySQL Upgrade
October 24, 2010 By 8 Comments
… does it cause an error in the slave? â‘¡I check the mysql document,the option name is slave-skip-errors both in 5.1 and 5.0 â‘¢according to mysql test,”To… Server 5.1 back to MySQL 5.0″,when I set up this,start slave,it report errors,said ‘log as be…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… unbootable server. Bug fixed #999147 (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on… with MySQL 5.0 or older, importing that table could crash Percona Server in some cases. Bug fixed #1000221 (Alexey Kopytov). Error… some time. Bug fixed #882653 (Stewart Smith). Server started with skip-innodb crashes on SELECT * FROM INNODB_TABLE_STATS or INNODB…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G…local-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-allowed-packet…size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K …
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
… rather raname them. Unfortunately you can’t rename locked tables (ERROR 1192 (HY000): Can’t execute the given command because you… clean out the table. In the applications which are error tolerant (like handle errors properly) you may rename table instead of locking… affected (0.01 sec) Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 mysql> rename table rep_maint to rep_old, rep_new…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size ========== ==== ======= ====== ======= ============ =========== Hard Disk …, not different MySQL configurations, I didn’t try out different MySQL versions or … myisam_repair_threads = 1 myisam_recover skip-grant-tables Amount of rows used…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…:20:19 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 120619 13:20:19 [Note] WSREP: Assign initial position… and the error log too. After the SSTs are done, you should check if you have a 3 node cluster. mysql> show… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
… like in an error.log: 130129 23:01:22 mysqld_safe Starting mysqld daemon with databases from /mnt/data/mysql 130129 23:01:22 mysqld_safe WSREP: Running position recovery with –log_error=/tmp/tmp.l1zf2BIDja 130129… storage engines, skipping position init 130129 23:01:45 [Note] WSREP: wsrep_load(): loading provider library ‘/usr/local/mysql/lib/libgalera_smm…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But …_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M … = 10G myisam_repair_threads = 1 myisam_recover user=root skip-grant-tables…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… broad is it. We let Slave to replicate with skip-slave-errors=1105 to see if we get any other problems spotted… being trivial. This was the best choice as with New MySQL version upgrade involves new Operating System and hardware and any… especially makes sense. The team, even if it includes skilled MySQL DBA typically does not need to go through major version…
