my_log eating up /tmp-space

[JohnD@]

Hello.

Using CentOS 4 and standard mySQL-package... Now, I having trouble that with my_log eating up the space on my /tmp-paritition. It seams that my_log contains all SQL-strings executed on the server. Doesn't take more then a day to fill up the 500MB /tmp...

How can I change so taht the my_log is disabled or at least being created in /var/log or something?

Thanks.