… get there, it can change the lifecycle of your application in advance. What about partitioning in MySQL…can have the clicks column record the total, and the blue_clicks column record only blue clicks; …Table scans can be better than the alternative, if the alternatives are limited, but they’re still …
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…get a recording once it is over? A: Yes, we will email a link to all webinar attendees with a recording… the data would exist only on the master. Alternatively, you can filter on the slaves. Each slave … Even the official manual page for MySQL Proxy 0.8.2 still says: “MySQL Proxy is currently an Alpha…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…if you have 3 nodes, and if 1 node gets isolated (2 nodes can see each others and ….01 sec) and on node2 you can also add records: percona2 mysql> insert into percona values (0,’percona2′,’jay’); …nodes, using the galera arbitrator is a very good alternative then. On a third node, instead of running …
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… it uses (Galera) is an exciting alternative to traditional MySQL replication. For those who don’t …`.`autoinc` trx id 83B lock mode IX RECORD LOCKS space id 0 page no 823… mysql> commit; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction node1 mysql> select…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
…proceed with deletion you may kiss your data goodbye. Alternative would be not to drop the table but … rows affected (0.01 sec) Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 mysql> rename table rep_maint to rep…besides same data loaded to “rep” table you will get the copy of old table in “rep_old” – …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…position, we need to know the whole record R. Also, a gzip compression potentially compresses…behavior in the cases when self tuning gets it wrong. Q10: When Innodb decides to…MySQL. There are two solutions here. Memlock and O_DIRECT. Memlock is apparently unstable on Linux. O_DIRECT is an alternative…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql…it more later. Another alternative is to dump …Records: 200 Duplicates: 100 Warnings: 0 mysql> insert ignore into test2 select * from test limit 300; ERROR 2013 (HY000): Lost connection to MySQL…
Post: AUTO_INCREMENT and MERGE TABLES
September 11, 2008 By Leave a Comment
… which does not seems to be the case. Alternatively I would expect AUTO_INCREMENT to be … in CREATE TABLE to get different auto_increment values ? I guess not: mysql> alter table am …Records: 1 Duplicates: 0 Warnings: 0 mysql> insert into am values(null); Query OK, 1 row affected (0.00 sec) mysql…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
…’ -project_name = None +#project_name = None defaults = get_defaults(qp_rootdir,project_name) variables…mysql> insert into t1 values (),(),(),(),(); Query OK, 5 rows affected (0.06 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql… INFO Stopping all running servers… Alternately, you can just let the…
Comment: Beware of MyISAM Key Cache mutex contention
August 15, 2008 By 10 Comments
…400M (ten files and each 40M). From the mysql manual, mysql only cache index, and the data will use …performance get worse. Today I also tested that reduce the data stored in DB, each table has 40M records, …matter I access one tables or access 10 tables alternately. This time, the wa is always 10. r …
