Shaikh Sonny Aman’s Blog

Lets learn and share!

MySQL DBA Preparation: Mysql Architecture

Hasin bhai is one of most
encouraging persons I have ever met. Good people generally advice you
to do good, but he will support and encourage (and push) for any good
thing. He took my word(along with some others) to take preparation for
MySQL DBA exam. I don’t know if I can make it, but I will go through
the [...]

MySQL UNIX_TIMESTAMP problem while using in where clause to find out result from a date

Today my teammate Mohsin was in a funny problematic situation and discovered an interesting behavior of unix_timestamp function of MySQL.
The task:
Say, he had a table which contained data along with the timestamp of the insertion time in a column. Now, his task was to find out all the entries on  a particular date.

The query:
His query [...]

Lightwieght VOIP billing software using mysql,servlet and ajax

Though I don’t like to do extra work beside my day job, but there are some people (and some offer :P)  whom I don’t like to refuse. Surely the work must be interesting.
Before some days,  one of my ex bosses gave a project to build a VOIP billing software. I was studying SIP protocol for [...]

Select a random row from large mysql table in an optimized way.

Random — This simple pronounced and apparently gentle looking word can make your brain randomly scattered.
We often need to select a random row from a table. … cutting short.. less time.
Prob: Need a random row from a table name ‘Dim’ which has 1,000,000 rows.
{selected only pad, i am in hurry :(}
1.
Create a stored procedure:
create [...]