Everyone who ever used MySQL under heavy load faced the performance problem. There numerous manuals and advises, tricks and “how to ?” examples. But you will definitely not find the solution which suits 100% for your project and will fix all your issues. You have to learn it. You have to spend your time.
No matter what distribution you are using now, soon or later if you job somehow depend on Linux productivity you will come to hard decision of which file system to use. Prior to start describing pros and cons of each file system and advise something, I would like do express some ideas about hardware part.
Today (Feb 2014) you have various way of keeping information. Outsource way online, special dedicated devices, rented or colocated servers, disks, flash drives, tapes and optical media (CD, DVD, BD). I’m not going to describe all the benefits of each tool. I wish to make some statements which will help you to select suitable files system on disks: HDD or SSD.
Here is small advice for those who uses buddy press plugin for WordPress. This is awesome plugin, but if your server is heavy loaded you can notice that your MySQL performance can heavily drop if you are using buddypress for a long time. I was wondering why it’s happening. I tried all possible solutions from increasing the power of MySQL server, like multi-threaded expensive Xeon CPUs, SSD disk, RAM disk later on, but the problem of various testers and performance checkers points me to DB problems issue. So I came to the point that I need some how to remove the data from bp_activity table. Continue reading
Major changing happened with Yahoo! mail since October 2013. A lot was said about it, many people complained. So I decided not stay away and express my feelings about it.
I’m using Yahoo! mail since 1997. It’s quite a lot, half of my life. Yahoo is not the only free e-mail service. There are others there. Since we all know what means “free” nowadays, thanks to Edward Snowden, e-mail is kind of thing that’s quite hard to change or more of that to quit it. I’m not sure that back in 1997 Yahoo was designed to spy on people. But we got what we got, Yahoo is number ONE by the amount of passed private information by request. Continue reading
First time I heard it from the Sky news, about some guy who traveled from Hon-Kong to Russia, and who revealed some secrets of American national security. So I did not pay much attention to this shit as UK and all western countries reporters like to attract attention with something special. After 3 days of continuous punching my brain with this occasion I sent some time to read more carefully about it. Continue reading