database
Showing Recent authors – WordPress
While helping my friend on community blog related to travel, i faced this requirement. He owns a website/blog where people share their travel experiences. We wanted to show 5 authors who contributed last i.e. people who wrote posts very recently. We googled and did not find any thing which can address our requirement exactly. During [...]
Scaling MySQL writes through Partitioning
Scaling MySQL writes through Partitioning View more presentations from Philip Tellis.
Create read-only user – MySql
Most useful for second or third level support people where people have skills to check db directly but in case you do not want them to make changes, Read only user can be created for them in Mysql DB. Here are two simple steps: 1. Create user mysql> create user ‘user’@'host’ identified by ‘some_password’; 2. [...]
error code [1030]; Got error 28 from storage engine
This is quick thing which i wanted to share with you all and also the possible cause of this. This error started coming today afternoon on one of our production servers. We wasted some of the time searching logs and some errors which were irrelevant and finally Google for it. Quickly we got the cause [...]
Database page corruption on disk or a failed file read …. Again – Mysql
Again encountered the stopped server in the morning because of page file corruption. Reason was the bad power situation in office during night shifts and which costs us the whole day to repair the testing server. As from the last time learnings of page file corruption (previous post) we knew how to start the server [...]