Menu

#20 MySQL table rotation

General
open
General (24)
9
2006-03-15
2006-03-14
No

An interresting thing to be implemented is table rotation for
MySQL schema.

Larger proxies can generate hundreds of entries in db and
in one moment mysar stops reading it because table file is
too big. Rotating tables you can maintain last 4 tables
rotated and save time when querying the mysql.

Mysar can read one or more of these tables to generate an
relatory.

Discussion

  • Ioannis Stoilis

    Ioannis Stoilis - 2006-03-15

    Logged In: YES
    user_id=614087

    Yes, I noticed it too and I've implemented it on a test
    version of MySAR. It should reach the next official release
    of MySAR.

     
  • Ioannis Stoilis

    Ioannis Stoilis - 2006-03-15
    • priority: 5 --> 9
     
  • Christian Tosta

    Christian Tosta - 2006-03-16

    Logged In: YES
    user_id=306718

    Sounds good! Do you have a schedule for new release?

     
  • Ioannis Stoilis

    Ioannis Stoilis - 2006-03-16

    Logged In: YES
    user_id=614087

    Unfortunately, no.

     

Log in to post a comment.