search

hellios78 / flexviews

Automatically exported from code.google.com/p/flexviews
0 stars 0 forks source link

Force statement based logging mode when creating a view to prevent problems with max_binlog_cache_size #22

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Change the binlog format for the INSERT .. SELECT when creating the view into a 
statement based log.  Then switch back to ROW for the insert into mview_signal. 
 This will allow a slave or binlog replay to capture the creation of the 
materialized view, but will prevent a huge view (4G+) from violating 
max_binlog_cache_size.

Original issue reported on code.google.com by greenlion@gmail.com on 15 Feb 2013 at 7:16