Enter your email to subscribe for latest posts.

April 27, 2008

Maximum Number of Tables in MySQL

I want to know how many tables a mysql database can hold ?
When using MyISAM table, the limit will be determined by your operating system, ie. the number of files you can have in one directory.

Using InnoDB tables removes that limitation by allowing multiple tables within a single datafile (tablespace).

The maximum tablespace size is 4 billion database pages. By default, a 'page' is 16K, but it is possible to recompile with 64K pages. This will allow a single tablespace size of ... 'BIG'.

A table will obviously take up at least one database page, meaning you can theoretically have a maximum of 4 billion tables per tablespace.

April 15, 2008

Can Women use a weapon to protect herself

Question: Does a woman have to defend herself if someone wants to rape her, and is she allowed to use a weapon for that purpose?

Praise be to Allaah.

A woman who is being forced to commit zinaa [unlawful sexual activity] is obliged to defend herself and should not give in even if she kills the one who wants to do that to her. This self-defence is waajib (obligatory), and she is not at fault if she kills the one who wants to force her into zinaa. Imaam Ahmad and Ibn Hibbaan reported that the Prophet (peace and blessings of Allaah be upon him) said: “Whoever is killed defending his property is a shaheed (martyr), whoever is killed defending himself is a shaheed, whoever is killed defending his religion is a shaheed, and whoever is killed defending his family is a shaheed.” In the commentary on this hadeeth it says: “whoever is killed defending his family is a shaheed” refers to the one who defends the honour of his wife and female relatives.

What are the limitation for a boy & girl during Engagement

i searched through all the relevent sections but i could not find the answer for my question.so i am asking it here. i was engaged to my present wife. and during the engagement period (before Nikah) we used to meet and touch and kiss and fondle with each other.. etc . but we never committed an intercourse. and later on we married. now i came accross the ayat of sura Noor for which some scholars say that a couple who had committed Zinna with each other, then they can not marry each other. another related question is that in some parts of pakistan people use to renew their marraige contract (Nikah) without any sharee requirement. Is it permissible to renew ones Nikah if the earlier nikah is still valid.


Kissing your Children according to Islam

Is it true that a father should not kiss his daughter on the mouth and that a mother should not kiss her son on the lips?

Praise be to Allaah.

This is true. A man should not kiss his mother or daughter on the mouth. Similarly, a brother should not kiss his sister on the mouth, or his paternal aunt or his maternal aunt, or any of his mahrams. Kissing on the mouth is only for husband and wife. And Allaah knows best.

How to create a toolbar for your portal - Like google and Yahoo tool bar

Its very easy to create a custom toolbar for you website or blog. Just follow the link below, create an account for free, customize your toolbar and give your users a new reason to visit your Website or Blog!!! :-D

April 8, 2008

How to Check OsCommerce Version

he question of what version a shop is has been getting asked a lot lately. This is meant to give a quick way to check it.

- First look in includes/application_top.php and find this line
// define the project version
Under that will be a line that starts with define('PROJECT_VERSION'. These are the main choices:


Related Posts Plugin for WordPress, Blogger...