MySQL vs SQL Server Database Migration Questions

[bellagarcia]

I’m considering switching from SQL Server to MySQL mainly because of the licensing costs. I need to know if MySQL has similar features to what I’m currently using.

My main concerns are about table partitioning and how MySQL handles memory management. In SQL Server, I have some large tables that get lots of new records added frequently. When this happens, SQL Server loads all the index pages into buffer cache which used up around 16-24GB of my RAM.

I solved this by splitting my big tables into smaller daily partitions. Since new data only goes into today’s partition, my buffer cache usage went down to less than 4GB.

Does MySQL work the same way? Can it partition tables like SQL Server does? And does MySQL also load index pages into buffer cache when it sees lots of inserts happening on a table? I want to make sure I can get similar performance improvements before making the switch.

[alexj]

yeah, mysql does do partitioning, but it’s kinda different from sql server. range partitioning by date could work for ya! the innodb buffer pool is like the buffer cache in sql svr, but gives more control over sizing. just make sure u use mysql 8.0 or newer for the best stuff.