RE: mysql max
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 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 MERGE tables: |http://www.mysql.com/doc/en/MERGE.html | |On Fri, 17 Oct 2003, nm wrote: | | Hi | | what's the max table size we can use with mysql-max version? | | Suggestions? | | Thanks. | | | | | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql max
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:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql max
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 -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql max
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 MERGE tables: http://www.mysql.com/doc/en/MERGE.html On Fri, 17 Oct 2003, nm wrote: Hi what's the max table size we can use with mysql-max version? Suggestions? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL-Max
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 binaries are recommended for most users, and includes the InnoDB storage engine. The Max version includes additional features such as the Berkeley DB storage engine and other features that have not been exhaustively tested or are not required for general usage, such as user-defined functions (UDFs), and BIG_TABLE support. When these features have matured and proven to be stable, they will be incorporated into future releases of the Standard binaries. http://www.mysql.com/downloads/mysql-4.0.html --V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL-Max
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 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 binaries are recommended for most users, and includes the InnoDB storage engine. The Max version includes additional features such as the Berkeley DB storage engine and other features that have not been exhaustively tested or are not required for general usage, such as user-defined functions (UDFs), and BIG_TABLE support. When these features have matured and proven to be stable, they will be incorporated into future releases of the Standard binaries. http://www.mysql.com/downloads/mysql-4.0.html --V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql-max 4.0.12 missing GLIBC 2.2
-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 need a dynamically linked binary for this to work (it uses the dlopen() system call). Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD4DBQE+eClGSVDhKrJykfIRAoAcAJY7mHU0cX2D7erCG6jzUfBmNWhTAJ9v8tfT pR/MrSUGJkHvCIeTkkbRxw== =SB8J -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysql MAX client
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 support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL max memory usage on linux/intel
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 caching. Since the total size of all databases is around 1.5 Gb they almost fit in memory and the server is happily serving around 300 queries/s with 200 concurrent connections and almost no disk I/O (no reads, just a few write every 5 seconds). Hope this helps -- Joseph Bueno [EMAIL PROTECTED] wrote: Apologies if this is off topic ... please let me know what a more appropriate forum is if so. Quick question: since there is normally a per-process limit of 4GB on 32-bit linux/intel platforms is there any point to installing more than 4gb in an sql server that is only running running 1 instance of the DB daemon? The total size of the DB is 30 GB and several tables are 4GB. -- -Chris Beck - Coradiant, Inc - Research Development - +1.514.908.6314- -- http://www.coradiant.com - Leaders in Web Performance Optimization -- --- This email represents my opinion, not that of Coradiant. --- We do not inherit the Earth from our Ancestors, we borrow it from our Children. -- Indian Proverb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL max memory usage on linux/intel
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 database server, it has only 2 Gb. mysqld itself is using around 600Mb the rest is used by the OS mainly for file caching. Since the total size of all databases is around 1.5 Gb they almost fit in memory and the server is happily serving around 300 queries/s with 200 concurrent connections and almost no disk I/O (no reads, just a few write every 5 seconds). Hope this helps -- Joseph Bueno [EMAIL PROTECTED] wrote: Apologies if this is off topic ... please let me know what a more appropriate forum is if so. Quick question: since there is normally a per-process limit of 4GB on 32-bit linux/intel platforms is there any point to installing more than 4gb in an sql server that is only running running 1 instance of the DB daemon? The total size of the DB is 30 GB and several tables are 4GB. -- -Chris Beck - Coradiant, Inc - Research Development - +1.514.908.6314- -- http://www.coradiant.com - Leaders in Web Performance Optimization -- --- This email represents my opinion, not that of Coradiant. --- We do not inherit the Earth from our Ancestors, we borrow it from our Children. -- Indian Proverb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-max-3.23.52-win
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 #Read the MySQL Manual for instructions S [WinMySQLadmin] S Server=C:/MYSQL/bin/mysqld-max.exe S user=root S [mysqld] S basedir=C:/MYSQL S datadir=C:/MYSQL/data S innodb_data_home_dir=C:/MYSQL/data S innodb_data_file_path=data_d1:50M:autoextend S innodb_log_group_home_dir=c:/mysql/data S innodb_log_arch_dir=c:/mysql/data S set-variable=key_buffer=32M S set-variable=innodb_buffer_pool_size=32M S but the startup is very slower. S Is it normal? S What's the problem? S Should I use another stableer version? S I want to use Innodb with autoextend. Yes, in = .52 is normal... use the 3.23.53 version. http://www.mysql.com - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes look: cannot open my eyes - Reply: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysql-max-3.23.51-pc-linux-gnu-i686 Installation
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 of the manual: http://www.mysql.com/doc/en/InnoDB_start.html Read info about my.cnf here: http://www.mysql.com/doc/en/Option_files.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max-3.23.52-1.i386.rpm is missing many files.
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. Nothing, so I attempt an install... [root@Zeke mysql]# rpm -i MySQL-Max-3.23.52-1.i386.rpm You're supposed to install the non-max rpm first, then install the max rpm. That's why you're seeing so many files missing. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, but those sites work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql max
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, 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 work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql max
Hello, Yes, there might be very strong reasons to use the Max version. Most people are using Max because it has InnoDB support. I'm not sure about your specific needs, but see this URL for more guidance on which version to choose: http://www.mysql.com/doc/en/mysqld-max.html Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: 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, 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 work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql max
Mysql-Max binaries are the binaries complied with InnodB support and InnoDB tables support transactions. So if you do something that has to be transaction-based, then you'd use mysql-max. Gurhan On Thu, 2002-09-05 at 16:17, Edward Peloke wrote: 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, 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 work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql max
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 and InnoDB tables support transactions. So if you do something that has to be transaction-based, then you'd use mysql-max. Gurhan On Thu, 2002-09-05 at 16:17, Edward Peloke wrote: 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, 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 work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 3.23.49 -Arul - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:22 PM Subject: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html Hi! People on the mailing list are asking where they can download MySQL-(Max)-3.23.50. It is available from http://www.mysql.com/downloads/mysql-3.23-pre.html. The release .50 is a regular stable release for all the other platforms except Linux. In the Linux version there is a bug in the custom-built glibc library. But as far as I know the bug has not caused much problems to Linux users either. Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html
Arul, you find, for example, the following binaries from that page: Binary packages (tar.gz) MySQL 3.23.50 Linux (Intel libc6 systems) Download MySQL 3.23.50 Linux (Alpha) Download MySQL 3.23.50 Linux (IA64) Download MySQL 3.23.50 Linux (Sparc) Download MySQL-Max 3.23.50 Linux (Intel libc6 systems) Download MySQL-Max 3.23.50 Linux (Alpha) Download MySQL-Max 3.23.50 Linux (IA64) Download MySQL-Max 3.23.50 Linux (Sparc) Download Regards, Heikki - Original Message - From: Arul [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 2:00 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 3.23.49 -Arul - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:22 PM Subject: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html Hi! People on the mailing list are asking where they can download MySQL-(Max)-3.23.50. It is available from http://www.mysql.com/downloads/mysql-3.23-pre.html. The release .50 is a regular stable release for all the other platforms except Linux. In the Linux version there is a bug in the custom-built glibc library. But as far as I know the bug has not caused much problems to Linux users either. Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max and Innodb
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 Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: Kent Thomas` [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, May 28, 2002 4:11 PM Subject: MySQL-Max and Innodb I am attempting to get mysql-max running with Innodb. I am using the latest version .49 on a Redhat 6.2 server. The following is my my.cnf, which I have placed in the /var/lib/mysql directory: # Example mysql config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # a important part and systems up to 128M very MySQL is used together with # other programs (like a web server) # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M log-bin server-id = 1 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase table innodb_data_file_path = ibdata1:200M innodb_data_home_dir = /var/lib/mysql/ innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout Everytime I attempt to start the MySql server I get the following error message: 020522 09:47:08 mysqld started InnoDB: The first specified data file /var/lib/mysql/ibdata1 did not exist: InnoDB: a new database to be created! 020522 9:47:09 InnoDB: Setting file /var/lib/mysql/ibdata1 size to 400 MB InnoDB: Database physically writes the file full: wait... InnoDB: Operating system error number 22 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: Look from section 13.2 at http://www.innodb.com/ibman.html InnoDB: what the error number means or use the perror program of MySQL. InnoDB: File name /var/lib/mysql/ibdata1 InnoDB: Cannot continue operation. 020522 09:47:51 mysqld ended Any suggestions would be greatly appreciated. Kent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max database recovery crashed - Fixed!
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max database recovery crashed
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 mysql_lock_remove__FP3THDP13st_mysql_lockP8st_table + 99 0x807853d mysql_lock_tables__FP3THDPP8st_tableUi + 557 0x80b202b acl_init__Fb + 795 0x807c656 main + 2678 0x82639fb __printf_fp + 5027 0x8048111 _start + 33 3.23.44 has a new my.cnf parameter. You could try set-variable = innodb_force_recovery=2 Does it now start to run? You can then try to dump your tables. See the manual at http://www.innodb.com/ibman.html section 6.1 about forcing recovery. Regards, Heikki Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max database recovery crashed
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 change_active_index__11ha_innobaseUi + 230 0x8078693 lock_external__FPP8st_tableUi + 107 0x807853d mysql_lock_tables__FP3THDPP8st_tableUi + 333 0x80b202b acl_init__Fb + 411 0x807c656 main + 2454 0x82639fb __libc_start_main + 99 0x8048111 _start + 33 Setting innodb_force_recovery to 6 does not help if the crash really comes from the above sequence. Please do not try it before we understand what the stack dump means. Have you tried taking the log=... option out from your my.cnf? Does the crash happen immediately after startup? With no database activity? Regards, Heikki At 11:56 AM 11/2/01 -0800, you wrote: 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 mysql_lock_remove__FP3THDP13st_mysql_lockP8st_table + 99 0x807853d mysql_lock_tables__FP3THDPP8st_tableUi + 557 0x80b202b acl_init__Fb + 795 0x807c656 main + 2678 0x82639fb __printf_fp + 5027 0x8048111 _start + 33 3.23.44 has a new my.cnf parameter. You could try set-variable = innodb_force_recovery=2 Does it now start to run? You can then try to dump your tables. See the manual at http://www.innodb.com/ibman.html section 6.1 about forcing recovery. Regards, Heikki Innobase Oy Sorry, the dump was from 2.23.44. The above force recovery statement did not help. mysqld-max produced the following: InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 212830477 011102 11:48:59 InnoDB: Started mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=268431360 record_buffer=1044480 sort_buffer=1048568 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 466539 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xb138, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x807b90f 0x8253c7a 0x80cf21a 0x8078693 0x807853d 0x80b202b 0x807c656 0x82639fb 0x8048111 New value of fp=(nil) failed sanity check, terminating stack trace! Would it hurt to try set-variable = innodb_force_recovery = 6 ? Thanks, Stephen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max database recovery crashed
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 starting mysqld-max so the server never really runs. I did read the Forcing recovery section of the manual and it suggests that I might have to reboot to clear some memory condition. I will give that a try. Thanks, Stephen 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 change_active_index__11ha_innobaseUi + 230 0x8078693 lock_external__FPP8st_tableUi + 107 0x807853d mysql_lock_tables__FP3THDPP8st_tableUi + 333 0x80b202b acl_init__Fb + 411 0x807c656 main + 2454 0x82639fb __libc_start_main + 99 0x8048111 _start + 33 Setting innodb_force_recovery to 6 does not help if the crash really comes from the above sequence. Please do not try it before we understand what the stack dump means. Have you tried taking the log=... option out from your my.cnf? Does the crash happen immediately after startup? With no database activity? Regards, Heikki At 11:56 AM 11/2/01 -0800, you wrote: 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 mysql_lock_remove__FP3THDP13st_mysql_lockP8st_table + 99 0x807853d mysql_lock_tables__FP3THDPP8st_tableUi + 557 0x80b202b acl_init__Fb + 795 0x807c656 main + 2678 0x82639fb __printf_fp + 5027 0x8048111 _start + 33 3.23.44 has a new my.cnf parameter. You could try set-variable = innodb_force_recovery=2 Does it now start to run? You can then try to dump your tables. See the manual at http://www.innodb.com/ibman.html section 6.1 about forcing recovery. Regards, Heikki Innobase Oy Sorry, the dump was from 2.23.44. The above force recovery statement did not help. mysqld-max produced the following: InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 212830477 011102 11:48:59 InnoDB: Started mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=268431360 record_buffer=1044480 sort_buffer=1048568 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 466539 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xb138, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x807b90f 0x8253c7a 0x80cf21a 0x8078693 0x807853d 0x80b202b 0x807c656 0x82639fb 0x8048111 New value of fp=(nil) failed sanity check, terminating stack trace! Would it hurt to try set-variable = innodb_force_recovery = 6 ? Thanks, Stephen -- SPL Linux Systems www.spl-linux.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max database recovery crashed
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 problem originally occured with the 2.23.43 distribution. The crash occurs within seconds of starting mysqld-max so the server never really runs. I did read the Forcing recovery section of the manual and it suggests that I might have to reboot to clear some memory condition. I will give that a try. Thanks, Stephen 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 change_active_index__11ha_innobaseUi + 230 0x8078693 lock_external__FPP8st_tableUi + 107 0x807853d mysql_lock_tables__FP3THDPP8st_tableUi + 333 0x80b202b acl_init__Fb + 411 0x807c656 main + 2454 0x82639fb __libc_start_main + 99 0x8048111 _start + 33 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 be MyISAM type. Maybe the MySQL system tables are corrupt? Running inside gdb could reveal if it really crashes there. Please make a copy of MySQL tables in the mysql directory so that they are preserved and we can check if they are ok. Regards, Heikki Ummm...I think I did convert the system db tables to InnoDB. Now what? How do I convert them back to MyISAM? Thanks, Stephen if you have good copies of system tables in the MyISAM format - I think they do not even need to be from the current database - then you can just copy them to the mysql directory (.frm, .MYI, .MYD files). mysqld will then use them in startup. But please make first a backup of your current mysql directory, and look if you have host.MYI and host.MYD etc. files there. An InnoDB table only has the .frm file. So we see if you had really converted system tables to InnoDB. Regards, Heikki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max database recovery crashed - Fixed!
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 problem originally occured with the 2.23.43 distribution. The crash occurs within seconds of starting mysqld-max so the server never really runs. I did read the Forcing recovery section of the manual and it suggests that I might have to reboot to clear some memory condition. I will give that a try. Thanks, Stephen 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 change_active_index__11ha_innobaseUi + 230 0x8078693 lock_external__FPP8st_tableUi + 107 0x807853d mysql_lock_tables__FP3THDPP8st_tableUi + 333 0x80b202b acl_init__Fb + 411 0x807c656 main + 2454 0x82639fb __libc_start_main + 99 0x8048111 _start + 33 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 be MyISAM type. Maybe the MySQL system tables are corrupt? Running inside gdb could reveal if it really crashes there. Please make a copy of MySQL tables in the mysql directory so that they are preserved and we can check if they are ok. Regards, Heikki Ummm...I think I did convert the system db tables to InnoDB. Now what? How do I convert them back to MyISAM? Thanks, Stephen if you have good copies of system tables in the MyISAM format - I think they do not even need to be from the current database - then you can just copy them to the mysql directory (.frm, .MYI, .MYD files). mysqld will then use them in startup. But please make first a backup of your current mysql directory, and look if you have host.MYI and host.MYD etc. files there. An InnoDB table only has the .frm file. So we see if you had really converted system tables to InnoDB. Regards, Heikki Hi Heikki, I backed up the existing mysql system directory (containing only .frm files) and copied the mysql system databases from another operational server to the dead one. Mysqld fired-up nicely upon restarting with skip-innodb in my.cnf. After changing a few permissions, I restarted the server with innodb and my databases reappeared! I'll have a closer look but they appear untainted by my screw-up. 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! Thanks for your generous help! Regards, Stephen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max database recovery crashed
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 be MyISAM type. I once converted ALL the databases and tables on a machine from MyISAM to Gemini. And I seem to remember it working. Hmm. Sounds like we need a big red warning in the docs about this. Maybe even something in the code to make it impossible. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 58 days, processed 1,299,168,985 queries (258/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max database recovery crashed
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 InnoDB format? That is not allowed. They must be MyISAM type. I once converted ALL the databases and tables on a machine from MyISAM to Gemini. And I seem to remember it working. in theory it could work. But since it has not been tested, in practice it probably will not. I do not what kind of a 'thd' handle mysqld uses when accessing its system tables, and I think it is best to leave the freedom to MySQL AB to change the access pattern as they like. Also, the system tables are managed in a non-transactional fashion, using table level locks. I do not know what happens if the tables are transactional and are managed with row level locking. Hmm. Sounds like we need a big red warning in the docs about this. Maybe even something in the code to make it impossible. Yes, I think I will ban table names 'mysql/host', 'mysql/user', 'mysql/db' internally inside InnoDB code. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 58 days, processed 1,299,168,985 queries (258/sec. avg) Regards, Heikki http://www.innodb.com/ibman.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL MAx
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 not a good idea to post there, because newsgroup messages are not sent to the mailing list, though mails appear in the newsgroup.) Regards, Heikki http://www.innodb.com/ibman.html [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: In article 9pcalq$244g$[EMAIL PROTECTED], robertc [EMAIL PROTECTED] wrote: I have had a similar problem - you must make sure you install all the RPM's including the normal mysql. Doing an rpm -qa|grep My must yeild something like this: MySQL-devel-3.23.41-1 MySQL-Max-3.23.41-1 MySQL-shared-3.23.41-1 MySQL-client-3.23.41-1 MySQL-3.23.41-1 Note this one too! MySQL max is only a binary and nothing else. I do not think MySQL max RPM check for which version of MySQL is actually installed and also does not do a dependancy check for the standard mysql rpm. Heikki, The only ones I found were in /usr/share/mysql. Did a find starting in root. Robert Heikki Tuuri [EMAIL PROTECTED] wrote: Robert, the installation program obviously failed to put the new errmsg files to the right place. Look for the new errmsg files somewhere, usually the directory is something like .../share/english, and copy them to /usr/share/mysql/english Regards, Heikki http://www.innodb.com/ibman.html Just installed MySQL Max 3.23.43 on a LInux box from the rpm. When starting get the following message: /usr/sbin/mysqld-max: Fatal error: Error message file '/usr/share/mysql/english/errmsg.sys' had only 205 error messages, but it should have at least 213 error messages. Check that the above file is the right version for thisprogram! The system previously had a normal version of 3.23. Any ideas as to what might have gone wrong?ThanksRobert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))
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: http://jeremy.zawodny.com/mysql/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz Hi, Thanks Jeremy for providing the quick work-around. I have temporarily fixed this by redirecting to the ftp.sunet.se mirror. Er.. I have been schnookered by some sunet.se automatching-closest-filename thing (when you click on the .41 links, sunet.se auto-redirects you to .40 files!). Turns out they only have .40 also. :( Fixing... will mail back soon. Done. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))
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, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.29: up 61 days, processed 622,840,968 queries (116/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-MAX 3.23.41 download link is dead... (need a download)
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 Zawodny [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 17, 2001 3:00 AM Subject: MySQL-MAX 3.23.41 download link is dead... (need a download) The link here: http://www.mysql.com/downloads/mysql-max-3.23.html points here: http://www.mysql.com/Downloads/MySQL-Max-3.23/mysql-max-3.23.41-pc-linux-gnu -i686.tar.gz But that URL 404s. Does anyone have the latest 3.23.41 I could grab a copy of? Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.29: up 61 days, processed 622,471,510 queries (116/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))
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: http://jeremy.zawodny.com/mysql/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz Hi, Thanks Jeremy for providing the quick work-around. I have temporarily fixed this by redirecting to the ftp.sunet.se mirror. The problem is because SourceForge (sometime recently) changed their rsync frequency with us; from every hour to something on the order of days(!) now. :( I have mailed the SourceForge admins to ask if they can fix this. Sorry for the inconvenience! Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql-max-nt, missing files in the intel/windows distrib
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. Regards, Miguel Hello, I am working on a windows 2000 server, SP 1. Until now, I used mysql 3.23. 2? with no problem I just downloaded 3.23.39 max, I stop the mysql service, then I installed it in the same directory: c:\mysql Last, I tried to start again the service (so mysqld-nt.exe) But it doesn't want to start, with no error message Then, I used winmysqdadmin to change it to mysqld-max-nt. I tried also the mysqld-max-nt --remove mysqld-max-nt --install -- that works well but mysqld-max-nt doesn't show me anything, and mysql is not running. finally, I tried: mysqld-max-nt --standalone And I got: mysqld-max-nt: Fatal error: Error message file 'c:\mysql\share\english\errmsg.sy s' had only 198 error messages, but it should have at least 208 error messages. Check that the above file is the right version for this program! I checked the last time this file has been changed, and it was 6 months ago, so it seems that these files are missing in the binary? By the way, in the binary distribution, there is no mysqlbug program I would appreciate your help Stephane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL MAX HPUX 11x depot file????
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 utility. But I have yet to find it. I want to install mySQL Max with support for BDB, but where's a hpuX binary? Secondly, documentation do not go to specific, but very generic. I strongly recommend working on OS specific documentation. I wouldn't mind working on HPUX specific doc (with right assistance from mySQL folks) Regards I __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ HI! If you follow instructions on building MySQL on HP-UX 11 as specified in HP-UX section of our manual, you would have no major problems. Next release of MySQL will contain some additional info, and they may come a contributed binary too ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql max size
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 that much hdd space (told me something of a special kernel)).. Markus, a quote from the very fine manual: How Big MySQL Tables Can Be === *MySQL* Version 3.22 has a 4G limit on table size. With the new `MyISAM' in *MySQL* Version 3.23 the maximum table size is pushed up to 8 million terabytes (2 ^ 63 bytes). Note, however, that operating systems have their own file size limits. Here are some examples: *Operating System* *File Size Limit* Linux-Intel 32 bit 2G, 4G or bigger depending on Linux version Linux-Alpha 8T (?) Solaris 2.5.12G (possible 4G with patch) Solaris 2.6 4G Solaris 2.7 Intel4G Solaris 2.7 ULTRA-SPARC 8T (?) On Linux 2.2 you can get bigger tables than 2G by using the LFS patch for the ext2 file system. On Linux 2.4 there exists also patches for ReiserFS to get support for big files. snip You can go around the operating system file limit for `MyISAM' data files by using the `RAID' option. *Note CREATE TABLE::. -- end of quote --- Big tables have been discussed frequently the last few weeks. It might be worth to dig into the archives. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
