Let’s talk about WordPress’ advanced database classes. I’m explicitly mentioning HyperDB, but there are other alternatives/forks out there;Continue reading
useful information about restoring large databases 👍
A few weeks ago my friend Frank de Jonge told me he managed to improve an import into a MySQL server down from more than 10 hours to 16 minutes. According to him it had to do with several field types (too long fields to really small data), the amount of indexes, and constraints on the tables. We were talking about 1 million records here. He wondered if it was possible to make it even faster.
Turns out there are many ways of importing data into a database, it all depends where are you getting the data from and where you want to put it. Let me give you a bit more context: you may want to get data from a legacy application that exports into CSV to your database server or even data from different servers.
If you are pulling data from a MySQL table into another…
View original post 717 more words
Logs are the answer that when something goes wrong. When you work on an enterprise scale, you need a centralized logging mechanism. (You can’t jump one server to other and tail that streams) Continue reading
I just replaced my two and a half-year-old iPhone (6s) battery today. The fun fact that, Apple Services are refused to make replacement because I bought my phone from the USA. Continue reading
I don’t always loop the songs but when I do…
Oh my! I should update my avatar on last.fm
I was listening too much The Cranberries in the age of mp3 players. I can’t remember how many mp3 players I used to but there always a few songs from The Cranberries. Thank you for your beautiful songs.
RIP Dolores 😥