what happen if exceed max connection in innodb

2005-02-06 Thread Chenri
my my.ini contain max_connections=100 this mean that simultaneous connection available is 100 connections, my questions are: 1. is this value for one database or for overall mysql connections? 2. i'm unable to generate 100 connections, i don't have 100 workstations yet, how do i test it? 3.

Re: How to limit database size under Windows?

2005-02-06 Thread Salama hussein
On 06.02.2005 05:26 (+0100), Mark Webber wrote: What version of Windows? XP and Windows 2000, 2003 have built-in Quota functions if you are using NTFS. Right click on the drive, choose properties, click on the Quota tab. That won't help him, and he know I think. It won't work because the quota i

Re: Hierarchial Data Structure

2005-02-06 Thread Daniel Kasak
Auyon Bhattacharya wrote: I am new to this. I have been trying to implement a hierarchial data structure in Mysql 5.0, on Windows NT with PHP. Can anyone tell me if I wish to retrieve an information such as the list of fore-fathers from a family tree how do I go about it in MySQL. I think MySQL sti

Re: Hierarchial Data Structure

2005-02-06 Thread Michael Dykman
In my experience with similar models, it is usually up to the application, rather than mysql, to perform the recursion - michael dykman On Sun, 2005-02-06 at 14:34, Andy wrote: > Hi all > > Did anybody reply to this thread? If so I am interested in obtaining those > replies. > > With kind r

Re: upgrading from 4.1.8 to 4.1.9

2005-02-06 Thread Robert L Cochran
I'm using Fedora Core 3 and just did an upgrade from 4.1.7 to 4.1.9, using Linux AMD64 rpms from the MySQL web site. It looks like everything went well. For me, the hard part was backing up my databases with mysqldump -- see my comments under the thread "MySQL upgrading" on this list. I shut d

Re: MySQL upgrading

2005-02-06 Thread Robert L Cochran
I myself want to go from version 4.1.7 to 4.1.9, so I read the upgrade page, which advises you to back up your databases. You do that with mysqldump, and that is briefly explained here: http://dev.mysql.com/doc/mysql/en/upgrading-to-arch.html I added this "user comment" to the page:

Re: Hierarchial Data Structure

2005-02-06 Thread Andy
Hi all Did anybody reply to this thread? If so I am interested in obtaining those replies. With kind regards Andy On Sat February 5 2005 09:43, Auyon Bhattacharya wrote: > I am new to this. I have been trying to implement a hierarchial data > structure in Mysql 5.0, on Windows NT with PHP. C

Re: Compiling MySQL from source

2005-02-06 Thread Michael Dykman
Helena, Visual Studio setups up some unpredicatable (to my mind) project configurations If left to it's own devices. Did you follow the directions in the file '/INSTALL-WIN-SOURCE'? The steps are fairly specific. For best results, if you are just trying to get a production server up, is to use

Re: Comparing bug in 4.1.7

2005-02-06 Thread Roger Baklund
Arjen Lentz wrote: [...] While we're at it: the term "non-zero"... what does it mean? As we all know, NULL != 0, and 0 == zero, consequently NULL must be non-zero. Flawed logic. Yes, I used flawed logic to illustrate my point: "non-zero" is a bad term to use in this context. The text from the

Re: MySQL upgrading

2005-02-06 Thread Coz Web
Helena, have you tried this link: http://dev.mysql.com/doc/mysql/en/upgrade.html It starts: "2.10. Upgrading MySQL As a general rule, we recommend that when upgrading from one release series to another, you should go to the next series rather than skipping a series. For example, if you currentl

Re: How to limit database size under Windows?

2005-02-06 Thread Yves Goergen
On 06.02.2005 05:26 (+0100), Mark Webber wrote: > What version of Windows? XP and Windows 2000, 2003 have built-in Quota > functions if you are using NTFS. Right click on the drive, choose > properties, click on the Quota tab. That won't help him, and he know I think. You can limit the folder s