InnoDB memcached plugin

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.

Continue reading

Best file system for Linux

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.sgi

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.

Continue reading

BP-Activity BuddyPress

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

What after PRISM

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