wamp服务器mysql存储限制,WAMP服务器。 MySQL中的数据目录很大吗？

I have problem with wammp server.

In directory "..\WampServer\bin\mysql\mysql5.5.8\data" was created files with very large size.

Full size of this directory is 50GB. What is these files? How can I fix this problem?

The names of files are:

mysql-bin.000001

mysql-bin.000002

................

mysql-bin.000227

The size of all files is 49GB

Thanks in advance!

解决方案

By default whenever you make a change to a MySQL database it creates a log of the query and stores it in a file simlare to mysql-bin.000001. The MySQL database does this so that you can recover or replicate a database. Most applications this is a good things to have enabled just like doing regular backups.

If you want to disable MySQL from creating these binary logs:

Open my.ini

Search for this line log-bin=mysql-bin

Comment this line out by adding a hash mark: # log-bin=mysql-bin

Save and restart the MySQL database

You can now safely delete these files from that directory.