title: schedule mysql table empty every 24 hours
body: <p>I am having problem with mysql database at one of my sites, its related to database size,</p>
  
  <p>in my database i have a table that store info about every hit on the site (form which ip,time country,referrer,etc) the problem that this table get boated in size quickly and i found that when i each about 100 mb then the server load become very high and i cant even browse the site.</p>
  
  <p>i am thinking about emptying this table every 24 hour automatically but i dont know where to start.</p>
  
  <p>what do u think? is there is any thing better than this approach. </p>