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" <hsv@stripped>
>>
>> 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
>
