Reputation
993
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 13
Newest
 Critic
Impact
~110k people reached

2d
answered Mysql query larger than tmpfs (ramdisk)
Mar
31
revised mysql Query Columns to Rows
Formatting for readability
Mar
31
suggested approved edit on mysql Query Columns to Rows
Mar
31
comment mysql Query Columns to Rows
It would help in future if you posted the structure of your table, along with the content, any queries you have already tried to show that you have done some research before asking the question, and a bit of formatting doesn't hurt :)
Mar
31
answered mysql Query Columns to Rows
Mar
3
comment How do I efficiently partition a large MySQL (Aurora) table with multiple search columns?
I agree with @RickJames comments - create the new partitions as needed, which can be done through the application of via a scheduled task. In addition, older data in the earlier partitions can be archived off to another structure when necessary to keep the number of partitions down.
Mar
3
revised Multiple tables entry with current timestamp
added 55 characters in body
Mar
2
answered Multiple tables entry with current timestamp
Mar
1
answered Rename the database name through terminal
Feb
29
comment How do I efficiently partition a large MySQL (Aurora) table with multiple search columns?
Definitely, but with your volume, 5 weekly tables would still be better than 2 monthly tables - roughly 5/8 of the data to be processed.
Feb
26
comment How do I efficiently partition a large MySQL (Aurora) table with multiple search columns?
You can't create a partition for each day covering data -42 to -12, as that would mean data would need to be in multiple partitions, which is not allowed.
Feb
26
comment How do I efficiently partition a large MySQL (Aurora) table with multiple search columns?
Assume that you build the range based on calendar weeks (Mon-Sun), and today is Feb 26th. Your query will be asking for a range from Jan 14th to Feb 14th (approx), and will touch 5 weekly partitions. If you used monthly, you'd touch 2 monthly partitions which would include an additional 3 weeks of data, which at your volumes would be considerable!
Feb
25
answered How do I efficiently partition a large MySQL (Aurora) table with multiple search columns?
Feb
25
comment How do I efficiently partition a large MySQL (Aurora) table with multiple search columns?
I had one similar receiving data from a syslog service taking in this much data (and up to 10k per second when busy), it was a great deal of fun! :)
Feb
24
answered Possible aproach for MySQL replication
Feb
24
comment Which error codes are safe for `slave_skip_errors` with MySQL Innodb
Personally, I wouldn't be skipping any errors. Skipping them is asking for trouble somewhere down the line. In 15+ years of MySQL replication experience, I've only used skip-errors once, and that was a particularly curious application issue, and they were all skipped manually, and not automatically. Be careful skipping errors...
Feb
24
awarded  Critic
Feb
24
comment How to change query_cache_type to 2 in AWS RDS?
@JitinMaherchandani - I wouldn't worry too much about the cache hit ratio - see this blog post from Percona percona.com/blog/2010/02/28/…
Feb
24
comment How to change query_cache_type to 2 in AWS RDS?
@jkavalik - totally agree, and in our real workload we do have the query_cache_type set to zero, I just set it to 2 here as an example :)
Feb
24
comment at the moment mysqldump (22 minutes exec time, 5 GB Dump), when to use xtrabackup?
XtraBackup give a lot more feature than will help as you grow, such as incremental backups and significantly faster restore times. If I were you, I would invest the time in preparing XtraBackup full and incremental backups scripts and a restore script to go with them. Better now when it is quick to perform the tests, than down the line when your backup reaches 100+Gb...