June 19, 2013

Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?

…to understand what’s is happening. As the GRA files contain binlog …root@node2 mysql]# ls -l GRA_3_3.log -rw-rw—-. 1 mysql mysql 106 …=0 is_null=0 */ ###   @4=1354228134 /* TIMESTAMP meta=0 nullable=0 is_null=0 */ …447′ for keyPRIMARY‘, Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the …

Comment: MySQL Partitioning - can save you or kill you

primary key consisting of 3 columns (ObjInstance (10000 types), objectClass (100 types) and timestamp of addition). All the 3 columns are also indexed as… taking longer and inserts at the same time.. I know mysql should have no problem in handling this ampunt of data…