mysql-proxy-discuss team mailing list archive

[Joshua Zhu <zhuzhaoyuan@xxxxxxxxx>]

On Sat, Feb 28, 2009 at 12:45 AM, Boehm, Matthew <mboehm@xxxxxxxxxxxxx>wrote:

>  Or should I try and modify the lua so that if I provide an ORDER BY, it
> sorts the in-memory table?
>
No, I don't think you need to do that.

In the end, if I didn't make it clear, let me say it again. You can write a
small script/program to do the following jobs periodically:
1) SELECT the analysis information from histogram.queries
2) merge (with some calculation of course) the information into
YOUR_REAL_TABLE, which has similar schema to histogram.queries
3) DELETE the content in histogram.queries

Then do whatever you want to YOUR_REAL_TABLE.

Regards,

-- 
Joshua Zhu
http://blog.zhuzhaoyuan.com