RE: mysql max

2003-10-18 Thread nm
Hi do you mean that InnoDB have no table-size limit? Thanks. |-Original Message- |From: Tobias Asplund [mailto:[EMAIL PROTECTED] |Sent: Friday, October 17, 2003 6:04 PM |To: nm |Cc: [EMAIL PROTECTED] |Subject: Re: mysql max | | | |It depends on your filesystem's and OS's max-size

Re: mysql max

2003-10-18 Thread Stephan Lukits
do you mean that InnoDB have no table-size limit? if size is that important to you get an 64-Bit system an should be able to go for Terrabytes without Raid an MERGE. Greetings Stephan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: mysql max

2003-10-18 Thread Paul DuBois
At 8:25 +0200 10/18/03, nm wrote: Hi do you mean that InnoDB have no table-size limit? Thanks. The InnoDB tablespace size limit is 64 TB. All InnoDB tables are stored within the tablespace, so this is also the individual table size limit. http://www.innodb.com/ibman.html#InnoDB_restrictions --

Re: mysql max

2003-10-17 Thread Tobias Asplund
It depends on your filesystem's and OS's max-size of a file in its filesystem. HOWEVER, there are a few ways you can get around this. You can use InnoDB tables, or read about RAID types here: http://www.mysql.com/doc/en/CREATE_TABLE.html (almost at the bottom of the page). You can also use

Re: MySQL-Max

2003-06-13 Thread V. M. Brasseur
Jon Miller wrote: I've been asked to setup a MySQL DB for critical mass usage. The programmer is asking that I use MySQL-Max. Does this have to be installed along with the regular MySQL version or is it a single product on it's own? From the MySQL/downloads page for 4.0: The Standard

RE: MySQL-Max

2003-06-13 Thread Chris Knight
Since we are on the subject Why is mysql-max(16meg) mysql(25meg) (for x86 v4.1)? No docs or something? -Original Message- From: V. M. Brasseur [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 1:00 PM To: Jon Miller Cc: [EMAIL PROTECTED] Subject: Re: MySQL-Max Jon Miller

Re: Mysql-max 4.0.12 missing GLIBC 2.2

2003-03-19 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 19 Mar 2003, Natalino Picone wrote: can anyone tell me why the mysql-max 4.0.12 is not statically linked against Glibc 2.2 ? (the standard one is ok)... This is done intentionally, to enable the use of User Defined Functions (UDFs) - you

re: mysql MAX client

2002-12-17 Thread Egor Egorov
On Tuesday 17 December 2002 22:04, Muruganandam wrote: Dear All, Where can i find mysql client and devel .rpm files compatible for MySQL-Max-3.23.53a-1.i386.rpm You can use any recent 3.23.x version of client. -devel.rpm should be the same as -shared.rpm if it's used. -- For technical

Re: MySQL max memory usage on linux/intel

2002-11-21 Thread Joseph Bueno
You can expect that your operating system will use the remaining memory as a file cache that will speed up your databases accesses. We don't have that much memory our dedicated database server, it has only 2 Gb. mysqld itself is using around 600Mb the rest is used by the OS mainly for file

Re: MySQL max memory usage on linux/intel

2002-11-21 Thread John Chang
How do I set the cache limit? Any suggestions on optimizing mySQL? At 07:05 PM 11/21/2002 +0100, Joseph Bueno wrote: You can expect that your operating system will use the remaining memory as a file cache that will speed up your databases accesses. We don't have that much memory our dedicated

Re: MySQL-max-3.23.52-win

2002-10-16 Thread Dyego Souza do Carmo
Dobrý den, quarta-feira, 16 de outubro de 2002, 17:33:00, napsal jste: S I installed MySQL-max-3.23.52-win in the Win98 with the following S configuration S #This File was made using the WinMySQLAdmin 1.4 Tool S #16/10/2002 14:37:55 S #Uncomment or Add only the keys that you know how works. S

re: mysql-max-3.23.51-pc-linux-gnu-i686 Installation

2002-10-10 Thread Victoria Reznichenko
Perumal, Thursday, October 10, 2002, 3:01:21 PM, you wrote: P Since I need to install mysql-max , please give me an idea on P my.cnf in linux environment and tell me also other configurations in the P files to install mysql-max. If you want to use InnoDB, please read the following chapter

Re: MySQL-Max-3.23.52-1.i386.rpm is missing many files.

2002-09-21 Thread Paul DuBois
At 20:17 -0400 9/21/02, alg wrote: Description: I'm trying to install MySQL MAX 3.23.52 (MySQL, with transactions enabled). My rpm attempts goes like this... 1. Check for installed MySQL... [root@Zeke mysql]# rpm -q -a | fgrep -i mysql [root@Zeke mysql]# 2.

Re: mysql max

2002-09-05 Thread Iikka Meriläinen
Hello, As of this writing, MySQL doesn't support stored procedures. It will most probably support them in 4.x versions to come. However, there are millions of web pages that use PHP in conjunction with MySQL without stored procs, although they would certainly benefit of them, but those sites

RE: mysql max

2002-09-05 Thread Edward Peloke
So is there really any benefit to using MySql Max? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Thursday, September 05, 2002 3:53 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: mysql max Hello, As of this writing

RE: mysql max

2002-09-05 Thread Iikka Meriläinen
: Re: mysql max Hello, As of this writing, MySQL doesn't support stored procedures. It will most probably support them in 4.x versions to come. However, there are millions of web pages that use PHP in conjunction with MySQL without stored procs, although they would certainly benefit of them

RE: mysql max

2002-09-05 Thread Gurhan Ozen
Max? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Thursday, September 05, 2002 3:53 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: mysql max Hello, As of this writing, MySQL doesn't support stored procedures

RE: mysql max

2002-09-05 Thread Tam, Michael
If you're using MySQL 4.0.x, mysql max is included. -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 2:43 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: RE: mysql max Mysql-Max binaries are the binaries complied with InnodB support

Re: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html

2002-06-04 Thread Arul
Hi Heikki Tuuri I am not sure whether it's the Max version of MySql 3.23.50 Coz the URL differs for ordinary version and Max Version.In the Max version , i couldnt see anything beyond 3.23.49 -Arul - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html

2002-06-04 Thread Heikki Tuuri
PM Subject: Re: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html Hi Heikki Tuuri I am not sure whether it's the Max version of MySql 3.23.50 Coz the URL differs for ordinary version and Max Version.In the Max version , i couldnt see anything beyond

Re: MySQL-Max and Innodb

2002-05-28 Thread Heikki Tuuri
Hi! Please go through the checklist in section 3.1 in http://www.innodb.com/ibman.html. I have a faint recollection that Linux in some of these cases gives a very obscure error number 22 which in Linux means 'Invalid argument'. It might really be out of disk space/quota. Best regards, Heikki

Re: MySQL-Max database recovery crashed - Fixed!

2001-11-03 Thread Michael Widenius
Hi! Heikki == Heikki Tuuri [EMAIL PROTECTED] writes: I will have to include a warning in the comments section of the MySQL documentation to NOT CONVERT MySQL SYSTEM TABLES FROM myISAM TO INNODB TYPE! I have now added a warning about this to the manual. Regards, Monty

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, I resolved the stack dump based on the 3.23.43 symbols file. I do not understand what mysqld is trying to do here. Are you sure the stack dump is from 3.23.43? 0x807b90f init_signals__Fv + 71 0x8253c7a __tfx + 26 0x80cf21a index_prev__11ha_innobasePc + 74 0x8078693

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, I resolved now with the mysql-max-3.23.44...tar.gz distribution. I still do not understand what mysqld is trying to do here. What distribution do you use, or did you compile yourself? 0x807b90f handle_segfault__Fi + 383 0x8253c7a pthread_sighandler + 106 0x80cf21a

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Stephen Lee
Heikki, Removal of the log= option and even the log-bin statement did not help. I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't think it's a download issue because the problem originally occured with the 2.23.43 distribution. The crash occurs within seconds of

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, At 01:37 PM 11/2/01 -0800, you wrote: Stephen, At 12:38 PM 11/2/01 -0800, you wrote: Heikki, Removal of the log= option and even the log-bin statement did not help. I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't think it's a download issue because the

Re: MySQL-Max database recovery crashed - Fixed!

2001-11-02 Thread Stephen Lee
Stephen, At 01:37 PM 11/2/01 -0800, you wrote: Stephen, At 12:38 PM 11/2/01 -0800, you wrote: Heikki, Removal of the log= option and even the log-bin statement did not help. I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't think it's a download issue because the

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Jeremy Zawodny
On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote: I looked now what MySQL does when it calls lock_external at startup: it initializes MySQL system tables like 'host' and 'user'. I assume you have not converted MySQL system tables to InnoDB format? That is not allowed. They must

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Jeremy, At 11:37 PM 11/2/01 -0800, you wrote: On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote: I looked now what MySQL does when it calls lock_external at startup: it initializes MySQL system tables like 'host' and 'user'. I assume you have not converted MySQL system tables to

Re: MySQL MAx

2001-10-02 Thread Heikki Tuuri
Hi! I am forwarding the following message from the newsgroup mailing.database.mysql richarde explained that from the rpm you have to install both MySQL-... and MySQL-Max-... (As a sidenote people recently asked if there is a newsgroup on MySQL. It is the above mentioned newsgroup, but it is

Re: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))

2001-08-17 Thread Matt Wagner
Matt Wagner writes: Matt Wagner writes: Jeremy Zawodny writes: On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote: Does anyone have the latest 3.23.41 I could grab a copy of? I managed to fetch it from ftp.mysql.com. A copy is now available here as well:

Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))

2001-08-16 Thread Jeremy Zawodny
On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote: Does anyone have the latest 3.23.41 I could grab a copy of? I managed to fetch it from ftp.mysql.com. A copy is now available here as well: http://jeremy.zawodny.com/mysql/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz Thanks,

Re: MySQL-MAX 3.23.41 download link is dead... (need a download)

2001-08-16 Thread Fournier Jocelyn [Presence-PC]
Hi, Try : http://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-Max- 3.23/ http://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-Max- 3.23/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz Jocelyn Fournier Presence-PC - Original Message - From: Jeremy

Re: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))

2001-08-16 Thread Matt Wagner
Jeremy Zawodny writes: On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote: Does anyone have the latest 3.23.41 I could grab a copy of? I managed to fetch it from ftp.mysql.com. A copy is now available here as well:

Re: mysql-max-nt, missing files in the intel/windows distrib

2001-07-30 Thread Miguel Angel Solórzano
At 15:09 30/07/2001 -0500, steph wrote: Hi, The 3.23.39 distribution was substituted by 3.23.39a because the setup program doesn't rewrite the share directory. That is the reason for your error message. To fix: stop the server, remove the share directory and run again the setup program.

Re: MySQL MAX HPUX 11x depot file????

2001-06-22 Thread Sinisa Milivojevic
Intekhab Choudhury writes: Hi I have installed/configured Oracle under HPUX, but thinking of moving to mySQL. But finding that a little difficult. First of all, document talks about (including throughout the Internet) a depot file (i.e. mysql.full) to be run with swinstall

Re: mysql max size

2001-02-28 Thread Thomas Spahni
On Tue, 27 Feb 2001, Markus H. Maussner wrote: does anybody know the limitations of mysql ? i am planing to make a big database. with big i mean something like 1,5TB ... the hardware seems not to be the problem (we get a big RAID for that, and our sysadmin sais that our linux system can take