April 27, 2008 at 11:46 am (Education)
Tags: How many tables, max tables limit, Maximum Number of Tables in MySQL, mysql, mysql limitation
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.
The number of tablespaces will again be limited by your operating system. Using NTFS on NT, the limit is 4,294,967,295. I imagine UNIX will be limited by the number of inodes. However, before reaching the physical limit of files you wil probably run into an issue with the maximum number of ‘open’ files allowed.
The first limit you hit will undoubtedly be that of your wallet while buying disk drives. 
Leave a Comment
April 15, 2008 at 6:27 pm (Islam)
Tags: Defending yourself from rape attack, Female, Islam, rape attempt, Using Weapons, ہتھیار کا استعمال, Women, جنسی زیادتی, زیادتی کی کوشش
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?
Answer:
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.
Read the rest of this entry »
Leave a Comment
April 15, 2008 at 6:23 pm (Islam)
Tags: couples, engagment, fondling, hug, Islam, kiss, relationship, Relationship after Engagement, Touching and Kissing during Engagement
Question:
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.
Answer:
Read the rest of this entry »
1 Comment
April 15, 2008 at 6:21 pm (Islam)
Tags: father, Kiss childern, Kiss daughter on mouth-lips, kiss on lips, mother
Question:
Is it true that a father should not kiss his daughter on lips and that a mother should not kiss her son on the mouth, even if you childern are small.
Answer:
Praise be to Allaah.
Read the rest of this entry »
Leave a Comment
April 15, 2008 at 9:50 am (Education)
Tags: How to create a toolbar for your portal
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!!! 
http://www.conduit.com/Publishers/WebsiteSyndication.aspx
Leave a Comment
April 8, 2008 at 8:13 pm (Education)
Tags: 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:
define(‘PROJECT_VERSION’, ‘osCommerce 2.2-MS1′); //released prior to July/2003
define(‘PROJECT_VERSION’, ‘osCommerce 2.2-CVS’); //released between the above/below dates
define(‘PROJECT_VERSION’, ‘osCommerce 2.2-MS2′); //released after July/2003
define(‘PROJECT_VERSION’, ‘osCommerce Online Merchant v2.2 RC1′); //released March/2007
define(‘PROJECT_VERSION’, ‘osCommerce 3.xxx’); //not released for general use
The versions before MS2 are not compatible with MS2, which is the main version is use. Between MS2 and RC1, there were two patch updates. There isn’t a version number for those patches (in the files) so you have to compare file content to see if they are installed. First, download the patches from here. Extract the contents and compare a few of the files with those in your shop. If your shop has them installed, then you probably have the latest MS2 version.
Leave a Comment
