Using MySQL: select random row, but fast

Random rows selection may be slow and there are several commonly used solutions to solve this problm could be googled. In my article I am trying to review a few algorithms and to describe benefits and limitations of them.
Let me know if I have missed some good algorithm.

Read complete article: Using MySQL: select random row, but fast

Using MySQL: ways to improve speed

As I have mentioned in one of my previous articles I am slightly disappointed in MySQL prepared statements, so I decided to look to theold and proven ways to improve the speed of the MySQL interaction. But what is even more impressive this approach allows even reduce hardware utilization.
This article describes SQL only and does not include PHP or erlang implementations, I hope publish some code soon.

Read complete article: Using MySQL: ways to improve speed

PHP MySQL prepared statement vs SQL statement

I should confess - I am already using MySQL prepared statements for some time, but very rarely and mainly because they can make certain scripts more readable. As many of us I have read a lot of articles about coolness of prepared statements and that I should use them because of security and speed improvements. Finally my сuriosity won and I decided to test prepared statements against ordinary SQL statements myself. Friendly speaking I was impressed by the results I got....

Read complete article: PHP MySQL prepared statement vs SQL statement

Scaling MySQL database with partitioning & subpartitioning

Many of us sooner or later have to scale our web applications. When we are talking about scalability we are always talking about the data and data storage. There are many options for data storage nowdays as relational databases, key-value storages and document oriented storages , but great part of web applications are using MySQL relational database as the main data storage maibly because of its flexebility. This article describes one of the MySQL scaling approaches - partitioning.

Read complete article: Scaling MySQL database with partitioning & subpartitioning

Twitter & facebook bookmarklets update

Today I am just want o anounce a bug fix update of Twitter and Facebook bokkmarklets. To explain a little to the people who are not using them yet. This bookmarklets allowing to select the texts on any web page and post it to the selected social network - twitter or facebook relatively.

Read complete article: Twitter & facebook bookmarklets bugfix update