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
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:
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
--
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
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
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
-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
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
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
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
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
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
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.
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
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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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:
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,
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
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:
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.
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
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
37 matches
Mail list logo