Mysql

I need quick and easy way to restore some of my MySQL databases from sql files. I don’t want to install MySQL on my machine, so I decided to use Docker. I created a simple bash script that will do all the work for me.

I have really “old” AMI Linux instances, and I need to go with more recent MySQL versions.

People quite often asking me about technology stack, and where to go with next big project. The answer isn’t simple – it depends. Usually, we have couple components which are critical for the whole system. If we are talking about a web-based solution or any API we have to decide about DATABASE, then we have STORAGE, moving on – some BACKEND service language.

From many reasons I was always using  SQL_CALC_FOUND_ROWS to get total number of records, when I was running limited query. Never especially thought about it, until i had some super performance issues with one of my projects. Obviously after quick profiling and googling  i found people complaining about FOUND_ROWS() low performance . I was not aware how big impact it was until I tested.

I’m the guy who like to test. Benchmark is my… middle name. You can find dozens articles about speed one or other solution. I mean MongoDB and MySQL . I tried MongoDB couple times, and each time I wasn’t  moved by it speed. Got project coming in, when I have to deal with large amount of concurrent connection. It’s not very big, but bigger then casual MySQL load.

So… how did I test – very dump way. Got 2 tables, one around 11k records, second one close to 200k record. Not much. Fields were indexed in both MySQL and MongoDB. And then i run benchmarks. First one had string fields, second one numeric.