CODEWITHSUNDEEP
mysqlmariadb
DroidOS
DroidOS

Reputation: 8900

MariaDB help_topic.* files

I have noticed that MariaDB (10) creates a stack of files bearing the name help_topic.* in /var/lib/mysql/mysql/performance_schema. What purpose, if any do these files serve? I ask because I am using MariaDB in a Docker container and want to try to trim all the fat. If they are used to deliver help in any form I might be able to dispense with them.

Upvotes: 1

Views: 206

Answers (1)

Michael - sqlbot
Michael - sqlbot

Reputation: 179364

Those tables provide the content used by the HELP statement.

http://dev.mysql.com/doc/refman/5.6/en/server-side-help-support.html

Since they are MyISAM tables, you could try simply stopping the server, moving the files elsewhere (so the server can't see them), then starting it back up, and checking the logs for warnings or errors. Additionally, you may want to try using the HELP command to be sure this doesn't cause any kind of internal panic if they are missing. It shouldn't, of course, but you may want to verify.

Testing this on MySQL Server 5.6.14, there were no ill effects. Using the HELP command just returns an error.

ERROR 1146 (42S02): Table 'mysql.help_topic' doesn't exist.

Nothing was written in the error log, either on startup or coinciding with the client error, above.

You should be okay without them.

Upvotes: 1

Related Questions