{"action":"opened","issue":{"url":"https://api.github.com/repos/saltstack/salt/issues/27447","labels_url":"https://api.github.com/repos/saltstack/salt/issues/27447/labels{/name}","comments_url":"https://api.github.com/repos/saltstack/salt/issues/27447/comments","events_url":"https://api.github.com/repos/saltstack/salt/issues/27447/events","html_url":"https://github.com/saltstack/salt/issues/27447","id":108570949,"number":27447,"title":"Fix mysql table size for salt_events","user":{"login":"junster1","id":6273569,"avatar_url":"https://avatars.githubusercontent.com/u/6273569?v=3","gravatar_id":"","url":"https://api.github.com/users/junster1","html_url":"https://github.com/junster1","followers_url":"https://api.github.com/users/junster1/followers","following_url":"https://api.github.com/users/junster1/following{/other_user}","gists_url":"https://api.github.com/users/junster1/gists{/gist_id}","starred_url":"https://api.github.com/users/junster1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/junster1/subscriptions","organizations_url":"https://api.github.com/users/junster1/orgs","repos_url":"https://api.github.com/users/junster1/repos","events_url":"https://api.github.com/users/junster1/events{/privacy}","received_events_url":"https://api.github.com/users/junster1/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-09-28T00:44:58Z","updated_at":"2015-09-28T00:44:58Z","closed_at":null,"body":"The default size of varchar(1024) for the data field in the salt_events table isn’t large enough to store many events including the presence events when you have lots of minions attatched to that syndic or master.  We altered the table to use mediumtext instead.\r\n\r\n> describe salt_events;\r\n+------------+--------------+------+-----+-------------------+----------------+\r\n| Field      | Type         | Null | Key | Default           | Extra          |\r\n+------------+--------------+------+-----+-------------------+----------------+\r\n| id         | bigint(20)   | NO   | PRI | NULL              | auto_increment |\r\n| tag        | varchar(255) | NO   | MUL | NULL              |                |\r\n| data       | mediumtext   | NO   |     | NULL              |                |\r\n| alter_time | timestamp    | NO   |     | CURRENT_TIMESTAMP |                |\r\n| master_id  | varchar(255) | NO   |     | NULL              |                |\r\n+------------+--------------+------+-----+-------------------+----------------+\r\n"}}