我在使用sphinx和mysql做搜索的时候,在mysql表中添加了sphinx引擎
show engines;
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| CSV | YES | CSV storage engine | NO | NO | NO |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| SPHINX | YES | Sphinx storage engine 0.9.9 | NO | NO | NO |然后建立了一个sphinx引擎类型的表,我往表里插入数据的时候报
/* SQL Error (1598): Binary logging not possible. Message: Statement cannot be logged to the binary log in row-based nor statement-based format */
意思是说事物日志不能被记录,sphinx表上面显示没有事物啊也需要记录事物日志吗?
可以让mysql不记录这个日志信息吗?如果我不需要记录这个日志可以解决问题不
show engines;
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| CSV | YES | CSV storage engine | NO | NO | NO |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| SPHINX | YES | Sphinx storage engine 0.9.9 | NO | NO | NO |然后建立了一个sphinx引擎类型的表,我往表里插入数据的时候报
/* SQL Error (1598): Binary logging not possible. Message: Statement cannot be logged to the binary log in row-based nor statement-based format */
意思是说事物日志不能被记录,sphinx表上面显示没有事物啊也需要记录事物日志吗?
可以让mysql不记录这个日志信息吗?如果我不需要记录这个日志可以解决问题不
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货