Mouth
Well-known member
Using xf v1.3RC1 and getting the following in mysql-error.log for each post (and post read/view?) ...
Code:
2014-03-03 08:41:06 52412 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES ('post', '2698546', 'a:1:{i:0;s:100:\"\"I\'m a motorcyclist too. I take my 50cc scooter to tennis lessons every second Thursday in summer!\"\";}', '1393791318', '1393796465')
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Code:
mysql> DESCRIBE `xf_bb_code_parse_cache`;
+------------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+------------------+------+-----+---------+----------------+
| bb_code_parse_cache_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| content_type | varbinary(25) | NO | MUL | NULL | |
| content_id | int(10) unsigned | NO | | NULL | |
| parse_tree | mediumblob | NO | | NULL | |
| cache_version | int(10) unsigned | NO | MUL | NULL | |
| cache_date | int(10) unsigned | NO | MUL | 0 | |
+------------------------+------------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
Code:
mysql> SHOW INDEX FROM `xf_bb_code_parse_cache`;
+------------------------+------------+-----------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------------+------------+-----------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| xf_bb_code_parse_cache | 0 | PRIMARY | 1 | bb_code_parse_cache_id | A | 2752 | NULL | NULL | | BTREE | | |
| xf_bb_code_parse_cache | 0 | content_type_id | 1 | content_type | A | 9 | NULL | NULL | | BTREE | | |
| xf_bb_code_parse_cache | 0 | content_type_id | 2 | content_id | A | 2752 | NULL | NULL | | BTREE | | |
| xf_bb_code_parse_cache | 1 | cache_version | 1 | cache_version | A | 4 | NULL | NULL | | BTREE | | |
| xf_bb_code_parse_cache | 1 | cache_date | 1 | cache_date | A | 275 | NULL | NULL | | BTREE | | |
+------------------------+------------+-----------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
5 rows in set (0.00 sec)
