Hi,
I need your help. I've got a problem with my MySQL binary logs, each 5 mins Drupal create a new log file (100Mo), and I'm scary for my Mysql hard drive.
I remove my log each 48h, and I disable dblog in Drupal. When I open my log file, I've got a many request, but the big request is for the table cache_menu and watchdog :
UPDATE cache_menu SET data = 'a:2:{s:4:\"tree\";a:84:{i:9273;a:2:{s:4:\"link\";a:38:{s:14:\"load_functions\";s:26:\"a:1:{i:1;s:9:\"node_load\";}\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:27:\"_publishcontent_view_access\";s:16:\"access_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:13:\"page_callback\";s:14:\"node_page_view\";s:14:\"page_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:5:\"title\";s:0:\"\";s:14:\"title_callback\";s:15:\"node_page_title\";s:15:\"title_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:4:\"type\";s:1:\"4\";s:11:\"description\";s:0:\"\";s:9:\"menu_name\";s:17:\"menu-main-menu-de\";s:4:\"mlid\";s:4:\"9273\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path\";s:8:\"node/767\";s:11:\"router_path\";s:6:\"node/%\";s:10:\"link_title\";s:9:\"Lösungen\";s:7:\"options\";s:30:\"a:1:{s:8:\"langcode\";s:2:\"de\";}\";s:6:\"module\";s:4:\"menu\";s:6:\"hidden\";s:1:\"0\";s:8:\"external\";s:1:\"0\";s:12:\"has_children\";s:1:\"1\";s:8:\"expanded\";s:1:\"0\";s:6:\"weight\";s:3:\"-49\";s:5:\"depth\";s:1:\"1\";s:10:\"customized\";s:1:\"1\";s:2:\"p1\";s:4:\"9273\";s:2:\"p2\";s:1:\"0\";s:2:\"p3\";s:1:\"0\";s:2:\"p4\";s:1:\"0\";s:2:\"p5\";s:1:\"0\";s:2:\"p6\";s:1:\"0\";s:2:\"p7\";s:1:\"0\";s:2:\"p8\";s:1:\"0\";s:2:\"p9\";s:1:\"0\";s:7:\"updated\";s:1:\"0\";s:15:\"in_active_trail\";b:1;s:6:\"access\";b:0;}s:5:\"below\";a:6:{i:8740;a:2:{s:4:\"link\";a:38:{s:14:\"load_functions\";s:26:\"a:1:{i:1;s:9:\"node_load\";}\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:27:\"_publishcontent_view_access\";s: .........
This request has got 800 lignes, but I've got 20 request insert into cache_menu or update cache_menu with the same size.
I don't know how I can resolve it. Maybe, if I could exclude tables as cache_menu, cache_views, sessions, watchdog.... in my log bin, I don't know if it's possible or not?
I hope we could find a solution. Thanks for you help.
