The original problem is traditionally resolved by partitioning the tables by historical range and creating a database job/event to drop older partitions and add the new ones. Depending on the environment, some might prefer shell scripts to do essentially the same.
On Jan 27, 2012, at 3:08 AM, Johan De Meersman wrote: > ----- Original Message ----- >> From: "Halász Sándor" <h...@tbbs.net> >> >> Therefore, it well may be easier to do it all in PHP, since therewith > > I agree with the assessment, but I take issue with this whole "do it in > PHP/Python/language-of-the-month". > > Why would I want to install PHP, Python or whatever on a database server? The > art of Bash programming is far from dead, and it behooves any decent > administrator to have at least some basic knowledge. Bash is literally on > almost every system you're likely to run MySQL on, and it's capabilities > probably far exceed what you think it can do. > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
