Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Changes to how cxtracker.pl stores sessions in MySQL #9

Open
wmesser opened this issue Jan 23, 2013 · 2 comments
Open

Changes to how cxtracker.pl stores sessions in MySQL #9

wmesser opened this issue Jan 23, 2013 · 2 comments
Milestone
1.1

Comments

@wmesser
Copy link
Owner

wmesser commented Jan 23, 2013

Change from using:

MyISAM's merge to InnoDB partitions.

This should help for a few reasons. 1) it wouldn't take too much packet data to overwhelm the maximum size of the merge table. 2) InnoDB is capable of non-blocking writes. 3) partitions should be faster than merges.

It's frankly tempting to just not keep a merged table and just pull queries over multiple days out of multiple tables.
@wmesser
Copy link
Owner Author

wmesser commented Jan 23, 2013

Original discussion: gamelinux#14

@ghost ghost assigned wmesser Jan 23, 2013
@gamelinux
Copy link

This was a no go right ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
1.1
Development

No branches or pull requests
2 participants
@gamelinux @wmesser