Re: Mysql on linux - choosing the right filesystem
On 2/24/07, Jean-Sebastien Pilon [EMAIL PROTECTED] wrote: Hello, I would like to get some of your input on file systems to use with mysql. Should I use a journaling filesystem ? Should I choose a different one based on what I store (log files, myisam dbs, innodb datafiles, etc ) ? Is there any file system tweaks you recommend ? TIA NOTICE: This email contains privileged and confidential information and is intended only for the individual to whom it is addressed. If you are not the named addressee, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this transmission by mistake and delete this communication from your system. E-mail transmission cannot be guaranteed to be secured or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. AVIS: Le présent courriel contient des renseignements de nature privilégiée et confidentielle et n'est destiné qu'à la personne à qui il est adressé. Si vous n'êtes pas le destinataire prévu, vous êtes par les présentes avisés que toute diffusion, distribution ou reproduction de cette communication est strictement interdite. Si vous avez reçu ce courriel par erreur, veuillez en aviser immédiatement l'expéditeur et le supprimer de votre système. Notez que la transmission de courriel ne peut en aucun cas être considéré comme inviolable ou exempt d'erreur puisque les informations qu'il contient pourraient être interceptés, corrompues, perdues, détruites, arrivées en retard ou incomplètes ou contenir un virus. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Founder/CEO Tailrank.com Location: San Francisco, CA AIM/YIM: sfburtonator Skype: burtonator Blog: feedblog.org Cell: 415-637-8078
Re: MySQL on Linux
%% Dan Nelson [EMAIL PROTECTED] writes: dn That is because although Linux binaries can access files over 2gb, dn they do not do so by default. Apache was probably not compiled dn with the required defines (-D_LARGEFILE_SOURCE dn -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even though dn both the kernel and filesystem most likely do support larger dn files. Just to point out this (needing extra compile flags to get large file support) is not unique to Linux. Most OSs require these kinds of flags; Solaris for example also requires special flags to get LFS. -- --- Paul D. Smith [EMAIL PROTECTED] HASMAT--HA Software Mthds Tools Please remain calm...I may be mad, but I am a professional. --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Linux
Perhaps stated a bit more correctly: Apache is NOT unique to Linux, so any system using Apache would need this configuration, that would include windows, MAC OS, Solaris, Irix, etc. Can't blame the OS on a softwares requirements... Dan. At 08:07 AM 4/9/2004, Paul Smith wrote: %% Dan Nelson [EMAIL PROTECTED] writes: dn That is because although Linux binaries can access files over 2gb, dn they do not do so by default. Apache was probably not compiled dn with the required defines (-D_LARGEFILE_SOURCE dn -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even though dn both the kernel and filesystem most likely do support larger dn files. Just to point out this (needing extra compile flags to get large file support) is not unique to Linux. Most OSs require these kinds of flags; Solaris for example also requires special flags to get LFS. -- --- Paul D. Smith [EMAIL PROTECTED] HASMAT--HA Software Mthds Tools Please remain calm...I may be mad, but I am a professional. --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. -- 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 on Linux
Just to be complete, linux does have limitations depending upon limitations of the file-system, and the kernel. All modern filesystems (XFS, EXT3, ...) all allow files over a terabyte is size. On Tue, 2004-04-06 at 13:39, Ronan Lucio wrote: Uhm, what are you talking about?!? When I put our site on a Linux system, apache stop working when it´s logfile get major than 2 Gb. I was afraid of it´d happen with MySQL, too. Linux has no such limitation. you can grow files as large as you like. right now I have an InnoDB dbase with Mysql on a linux system and the file is over 60 GIGS in size! Great!!! So, I don´t need to worry about it... :-) Thanks Dan, Ronan Benjamin Arai Araisoft Email: [EMAIL PROTECTED] Website: http://www.araisoft.com
Re: MySQL on Linux
I ran into the same issues on RH8, with a default implmentation. It can be overcome, but the mysql failed to write to the table after 2gb or so. It turned out to be a filesystem limitation issue, which was fixable. I am not sure, but given the size of files nowadays, RH9 defaults probably take care of it. I am currently running several very large tables on RH8 (5-30G) and it is stable. One should always beware that large tables can easily be corrupted, and are not a joy to recover though :-/ P Alan Williamson [EMAIL PROTECTED] 04/06/2004 05:57 PM To: Dan Nelson [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject:Re: MySQL on Linux Thank you, a much reasoned and sensible reply. This is information people can use, as oppose to the posts that 'say well its okay for me, you must be stupid' types. ;) Dan Nelson wrote: In the last episode (Apr 06), Alan Williamson said: the most popular would have been Red Hat, which doesn't have this limit you speak of, even plain vanilla install (no twiddling needed). Not to spoil a perfectly good pontification ... but i have to say that we have a Redhat8 distribution running on a Dell PowerEdge Server and when Apache gets to the 2GB size on its access file, it does indeed stop. This is not old hardware (12months old). That is because although Linux binaries can access files over 2gb, they do not do so by default. Apache was probably not compiled with the required defines (-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even though both the kernel and filesystem most likely do support larger files. So the question still remains. What would happen in MySQL when that file isn't allowed to grow any further? Mysql's configure script checks for systems that require special flags to access large files, so no mysql binaries should have this problem on modern Linux systems (i.e. any 2.4 kernel) -- 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 on Linux
Well I guess it depends on what is meant by Default. I was using RH8 and had no such issues, even with RH7... I think it's important to note the filesystem chosen can make a huge difference. as of RH8 and onward I'd suggest EXT3, especially for Peter's issue of possible corruption - because it is a fully journalling filesystem. of course, a filesystem cannot (and will not) overcome issues with the software or OS itself. It's always best to use the latest stable Mysql (4.0.18 as of last I checked), and don't always upgrade just because. too many admins will upgrade just because the latest thing is out, if it's working, stable, etc, leave it alone. don't fix it if it aint broke. the point is, choosing the right options during install. myself, I never had an issue with the defaults, even back as far as RH7, using files larger than 2gigs with mysql. perhaps because I always choose the best file system available at the time. I chose journalling as soon as it was available, things like ReiserFS come to mind. for me, large files was always the default, never had to choose it manually or change any settings. oh well... Dan. On Wed, 7 Apr 2004, Peter J Milanese wrote: I ran into the same issues on RH8, with a default implmentation. It can be overcome, but the mysql failed to write to the table after 2gb or so. It turned out to be a filesystem limitation issue, which was fixable. I am not sure, but given the size of files nowadays, RH9 defaults probably take care of it. I am currently running several very large tables on RH8 (5-30G) and it is stable. One should always beware that large tables can easily be corrupted, and are not a joy to recover though :-/ P Alan Williamson [EMAIL PROTECTED] 04/06/2004 05:57 PM To: Dan Nelson [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject:Re: MySQL on Linux Thank you, a much reasoned and sensible reply. This is information people can use, as oppose to the posts that 'say well its okay for me, you must be stupid' types. ;) Dan Nelson wrote: In the last episode (Apr 06), Alan Williamson said: the most popular would have been Red Hat, which doesn't have this limit you speak of, even plain vanilla install (no twiddling needed). Not to spoil a perfectly good pontification ... but i have to say that we have a Redhat8 distribution running on a Dell PowerEdge Server and when Apache gets to the 2GB size on its access file, it does indeed stop. This is not old hardware (12months old). That is because although Linux binaries can access files over 2gb, they do not do so by default. Apache was probably not compiled with the required defines (-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even though both the kernel and filesystem most likely do support larger files. So the question still remains. What would happen in MySQL when that file isn't allowed to grow any further? Mysql's configure script checks for systems that require special flags to access large files, so no mysql binaries should have this problem on modern Linux systems (i.e. any 2.4 kernel) -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Linux
The 2GB (not 2 Mb) file size limitation on Linux went away years ago. Unless your distribution is very old you won't have a problem. --Pete On Tue, Apr 06, 2004 at 05:05:59PM -0300, Ronan Lucio wrote: Hi All, I always worked with MySQL on FreeBSD systems. Now I need to install am MySQL with InnoDB and MyISAM tables in ta Linux RH system. So, do I need to care about the Linux file size limitation of 2 Mb? Or MySQL deal this situation with Linux FS? In other words, will my MySQL stop working when the database get major then 2 Mb? Or such situation won?t happen? thanks Ronan -- 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 on Linux
Uhm, what are you talking about?!? When I put our site on a Linux system, apache stop working when it´s logfile get major than 2 Gb. I was afraid of it´d happen with MySQL, too. Linux has no such limitation. you can grow files as large as you like. right now I have an InnoDB dbase with Mysql on a linux system and the file is over 60 GIGS in size! Great!!! So, I don´t need to worry about it... :-) Thanks Dan, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Linux
On Tuesday 06 April 2004 16:31, dan wrote: Uhm, what are you talking about?!? Linux has no such limitation. you can grow files as large as you like. right now I have an InnoDB dbase with Mysql on a linux system and the file is over 60 GIGS in size! maybe you meant 2 Tb? and if you did, let's see you make one that big. Dan. He's talking about a 32 bit filesystem w/o large file support. There is indeed a 2GB limit on such systems. You may want to read this before speaking up again: http://www.suse.de/~aj/linux_lfs.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Linux
nice flame! :) btw- Doesnt exist in out-of-the-box Linux distros, or any distro you can currently download. or any distro you could download (or buy) over the last few years. it doesnt occur in vanilla distributions or any other retail, commercial, or otherwise distribution... well maybe Suse, since I stopped looking at it once it went commercial. but SUSE is NOT the linux standard. Neither are any of them actually. the most popular would have been Red Hat, which doesn't have this limit you speak of, even plain vanilla install (no twiddling needed). contrary to your statement, SUSE is not the bar by which other linux's are measured. Did you even read that document you're referring to? I think you should at least READ it before speaking up on stuff you know nothing about. Look at it, it refers to linux kernel 2.4.0-test7, not even a release kernel. and glibc 2.1 and all the way back to SUSE 7.0 running the 2.2 kernel! It also refers to Red Hat 6.2, I mean, come on man... taking a document like that, which has been sparsely updated to reflect new versions of Linux and just says now has support for those versions is hardly a decent reference... any current linux in any format will support large files out of the box as they say. so yes, I know what I'm talking about, thanks. sheesh. He's talking about a 32 bit filesystem w/o large file support. There is indeed a 2GB limit on such systems. You may want to read this before speaking up again: http://www.suse.de/~aj/linux_lfs.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Linux
On Tuesday 06 April 2004 17:28, dan wrote: nice flame! :) btw- Doesnt exist in out-of-the-box Linux distros, or any distro you can currently download. or any distro you could download (or buy) over the last few years. it doesnt occur in vanilla distributions or any other retail, commercial, or otherwise distribution... Sorry, didn't mean to sound flameish. Just wanted to point out that 32 bit systems have limitations. 2^32 = 4 billion that's the max. Addressing more space than that requires a bit of black magic. That's why IPv4 only has 4 billion IP addresses... why x86 systems only support 4GB of RAM... why linux systems w/o the LFS black magic are limited to 2GB file sizes. For addressable space more than that one needs 64 bits... no black magic there. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Linux
dan wrote: the most popular would have been Red Hat, which doesn't have this limit you speak of, even plain vanilla install (no twiddling needed). Not to spoil a perfectly good pontification ... but i have to say that we have a Redhat8 distribution running on a Dell PowerEdge Server and when Apache gets to the 2GB size on its access file, it does indeed stop. This is not old hardware (12months old). So don't be spouting any sweeping statements. If your distribution doesn't have that limitation, then fantastic, good for you. But for others it is indeed a real limitation. The original question was indeed a geniue one, and while the poster accidently typed in the wrong size, i wouldn't be so quick to jump all over him. So the question still remains. What would happen in MySQL when that file isn't allowed to grow any further? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Linux
I have had this happen on 2 boxes one running Redhat 7.2 and the other running Redhat 8. I can tell MySQL does not like not being able to write to the file anymore. We were using MySQL 3.23 on one box and 4 on the other box. The table crashed. Causing a lot of corruption. In one instance it actually took the table and zeroed it out leaving me with no data, and having to recover the 2 gig table, then watching it happen again. Eric Gunnett System Administrator Zoovy, Inc. [EMAIL PROTECTED] Alan Williamson [EMAIL PROTECTED] 04/06/04 02:47PM dan wrote: the most popular would have been Red Hat, which doesn't have this limit you speak of, even plain vanilla install (no twiddling needed). Not to spoil a perfectly good pontification ... but i have to say that we have a Redhat8 distribution running on a Dell PowerEdge Server and when Apache gets to the 2GB size on its access file, it does indeed stop. This is not old hardware (12months old). So don't be spouting any sweeping statements. If your distribution doesn't have that limitation, then fantastic, good for you. But for others it is indeed a real limitation. The original question was indeed a geniue one, and while the poster accidently typed in the wrong size, i wouldn't be so quick to jump all over him. So the question still remains. What would happen in MySQL when that file isn't allowed to grow any further? -- 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 on Linux
Brad Tilley wrote: On Tuesday 06 April 2004 17:28, dan wrote: Just wanted to point out that 32 bit systems have limitations. 2^32 = 4 billion that's the max. Addressing more space than that requires a bit of black magic. All it takes a some arbitrary precision math. Since we are talking about integers, that's not all that hard, and far from black magic. But I digress :) Chris W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Linux
In the last episode (Apr 06), Alan Williamson said: the most popular would have been Red Hat, which doesn't have this limit you speak of, even plain vanilla install (no twiddling needed). Not to spoil a perfectly good pontification ... but i have to say that we have a Redhat8 distribution running on a Dell PowerEdge Server and when Apache gets to the 2GB size on its access file, it does indeed stop. This is not old hardware (12months old). That is because although Linux binaries can access files over 2gb, they do not do so by default. Apache was probably not compiled with the required defines (-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even though both the kernel and filesystem most likely do support larger files. So the question still remains. What would happen in MySQL when that file isn't allowed to grow any further? Mysql's configure script checks for systems that require special flags to access large files, so no mysql binaries should have this problem on modern Linux systems (i.e. any 2.4 kernel) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Linux
Thank you, a much reasoned and sensible reply. This is information people can use, as oppose to the posts that 'say well its okay for me, you must be stupid' types. ;) Dan Nelson wrote: In the last episode (Apr 06), Alan Williamson said: the most popular would have been Red Hat, which doesn't have this limit you speak of, even plain vanilla install (no twiddling needed). Not to spoil a perfectly good pontification ... but i have to say that we have a Redhat8 distribution running on a Dell PowerEdge Server and when Apache gets to the 2GB size on its access file, it does indeed stop. This is not old hardware (12months old). That is because although Linux binaries can access files over 2gb, they do not do so by default. Apache was probably not compiled with the required defines (-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even though both the kernel and filesystem most likely do support larger files. So the question still remains. What would happen in MySQL when that file isn't allowed to grow any further? Mysql's configure script checks for systems that require special flags to access large files, so no mysql binaries should have this problem on modern Linux systems (i.e. any 2.4 kernel) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL on Linux
What we've done on Red Hat 7.3, 8.0 and 9.0 boxes, then on a SuSE 9.0 box is to set up InnoDB and have multiple files defined at 2GB. We just keep adding additional files as we need them and performance seems to be holding okay. -Original Message- From: Eric Gunnett [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 4:54 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL on Linux I have had this happen on 2 boxes one running Redhat 7.2 and the other running Redhat 8. I can tell MySQL does not like not being able to write to the file anymore. We were using MySQL 3.23 on one box and 4 on the other box. The table crashed. Causing a lot of corruption. In one instance it actually took the table and zeroed it out leaving me with no data, and having to recover the 2 gig table, then watching it happen again. Eric Gunnett System Administrator Zoovy, Inc. [EMAIL PROTECTED] Alan Williamson [EMAIL PROTECTED] 04/06/04 02:47PM dan wrote: the most popular would have been Red Hat, which doesn't have this limit you speak of, even plain vanilla install (no twiddling needed). Not to spoil a perfectly good pontification ... but i have to say that we have a Redhat8 distribution running on a Dell PowerEdge Server and when Apache gets to the 2GB size on its access file, it does indeed stop. This is not old hardware (12months old). So don't be spouting any sweeping statements. If your distribution doesn't have that limitation, then fantastic, good for you. But for others it is indeed a real limitation. The original question was indeed a geniue one, and while the poster accidently typed in the wrong size, i wouldn't be so quick to jump all over him. So the question still remains. What would happen in MySQL when that file isn't allowed to grow any further? -- 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-4.0.5a+linux+FLUSH QUERY CACHE = crash
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 5 Dec 2002, Andrew Sitnikov wrote: after FLUSH QUERY CACHE key_buffer_size=402649088 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=115 max_connections=200 threads_connected=6 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211610 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8a7e870 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=0xbfd1f2a8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806eedb 0x8268018 0x80de403 0x80de1ab 0x80dcbd9 0x807dc27 0x807bdb3 0x807cad5 0x8077d4b 0x8077795 0x8077007 0x82657cc 0x829ad6a New value of fp=(nil) failed sanity check, terminating stack trace! Unfortunately this info is not very helpful - we would need some more background info and a repeatable test case to be able to resolve this :( The command above is part or our test suites and passed fine during the build phase. Can you reliably reproduce this? If yes, please describe in more detail, how. Thanks! 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.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE97yxMSVDhKrJykfIRAmGcAJ4wrh3hm5m1KnUcllsyfLuKEGofdwCfcX2K UaBYB6ofrEzb7h9p4W3sCHY= =cQlM -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 on Linux Clustering..?
You could set up a clustering configuration using our replication. Just take a look at the replication section of our online docs: http://www.mysql.com/documentation/index.html Kerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 9:09 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: MySql on Linux Clustering..? I want to run MySql on Linux Clustering Sever. But I can't find about that. Would you tell me , Where can I get MySql Clustering HOW-TO Docs? - 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 on Linux Clustering..?
Replication, however, is no good for scaling update load. What happens when you're update load is too much for the box? Are you just meant to buy a bigger box? What happens if you already have the biggest box and the update load is too high? Is there no way to scale the update load wide in MySQL? --Mike - Original Message - From: Kerry Ancheta [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 02, 2002 9:37 PM Subject: RE: MySql on Linux Clustering..? You could set up a clustering configuration using our replication. Just take a look at the replication section of our online docs: http://www.mysql.com/documentation/index.html Kerry - 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 on Linux Clustering..?
I should clarify that you could have a cluster of MySQL servers using our replication. However for clustering you should consider the following: Maybe the most powerful project in this area is Beowulf (not Linux only) http://www.beowulf.org, but there are many such projects like: Cplant http://www.cs.sandia.gov/cplant/ Legion http://legion.virginia.edu Linux Virtual Server Project: http://www.linuxvirtualserver.org MOSIX: http://www.mosix.cs.huji.ac.il/ High-Availability Linux Project: http://www.linux-ha.org Kerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 9:09 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: MySql on Linux Clustering..? I want to run MySql on Linux Clustering Sever. But I can't find about that. Would you tell me , Where can I get MySql Clustering HOW-TO Docs? - 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 on Linux
I know in at least 2 e-mails I did indeed mention that I executed safe_mysqld -u root, So I did it using your syntax, safe_mysqld --user=root, I had the same text returned which again said the following. Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended I presume that means that mysqld ended Basically the mysql started then abruptly stopped. Again the error in the ONLY error log linux.err said the exact same text that was displayed on my screen, making that no help. There is no mysql.sock on my system because the server is not running, anyone have any REAL ideas? The documentation is of NO help whatsoever and I am getting very frustrated with it. Trying mysqp -u root -ppassword was a desperate attempt to try it another way. As I have done numerous different ways. I don't know how many different ways I can try to get mysqld daemon running. Mark - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: 'Mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 8:14 PM Subject: Re: mysql on Linux When I execute mysqld -u root -p password I am presented with the default variables. The manual says to use safe_mysqld to properly start mysqld. Also, --user=root is clearer for that option. And, what are you doing with -p password in starting the daemon? This is not an option, it is an error. http://www.mysql.com/doc/s/a/safe_mysqld.html Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 on Linux
try running safe_mysqld without any options I wouldn't know why you would need to specify a user name to start the daemon -Original Message- From: Intrex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 5:55 AM To: [EMAIL PROTECTED]; 'Mysql' Subject: Re: mysql on Linux I know in at least 2 e-mails I did indeed mention that I executed safe_mysqld -u root, So I did it using your syntax, safe_mysqld --user=root, I had the same text returned which again said the following. Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended I presume that means that mysqld ended Basically the mysql started then abruptly stopped. Again the error in the ONLY error log linux.err said the exact same text that was displayed on my screen, making that no help. There is no mysql.sock on my system because the server is not running, anyone have any REAL ideas? The documentation is of NO help whatsoever and I am getting very frustrated with it. Trying mysqp -u root -ppassword was a desperate attempt to try it another way. As I have done numerous different ways. I don't know how many different ways I can try to get mysqld daemon running. Mark - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: 'Mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 8:14 PM Subject: Re: mysql on Linux When I execute mysqld -u root -p password I am presented with the default variables. The manual says to use safe_mysqld to properly start mysqld. Also, --user=root is clearer for that option. And, what are you doing with -p password in starting the daemon? This is not an option, it is an error. http://www.mysql.com/doc/s/a/safe_mysqld.html Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 on Linux
Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended This is written by safe_mysqld. It seems that mysqld was never started successfully. I've had this issue before. Every time it was a permissions issue. When I execute mysqld -u root -p password I am presented with the default variables. Which are? Also, what is in /var/lib/mysql? Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 on Linux
The /var/lib/mysql contains the following files: linux-bin.001 linux-bin.002 linux-bin.003 linux-bin.004 linux-bin.005 linux-bin.006 linux-bin.007 linux-bin.008 linux-bin.009 linux-bin.index linux-bin.err the directory mysql the directory test directory mysql contains columns_priv.MYD columns_priv.MYI columns_priv.frm db.MYD db.MYI db.frm func.MYD func.MYI fun.frm host.MYD host.MYI host.frm tables_priv.MYD tables_priv.MYI tables_frm user.MYD user.MYI user.frm Directory test contains nothing When I remove all the files and recreate the directory using mysql_install_db then follow the directions for installing the privileges I get the same files, and the same errors. I am unable to use mysqladm create databasename since the mysql daemon is not running. It is my understanding that the database it is looking for is the permission files located in the /var/lib/mysql directories. Mark Mark - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: 'Intrex' [EMAIL PROTECTED] Cc: Mysql [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 1:07 PM Subject: RE: mysql on Linux Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended This is written by safe_mysqld. It seems that mysqld was never started successfully. I've had this issue before. Every time it was a permissions issue. When I execute mysqld -u root -p password I am presented with the default variables. Which are? Also, what is in /var/lib/mysql? Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 on Linux
When I execute mysqld -u root -p password I am presented with the default variables. Which are? How about showing what mysqld --user=root displays? Also, you see linux-bin.* files? That indicates that mysqld was running at some point (maybe nine times). Can you get the directory listings with ls -l ? Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 on Linux
when you run mysqld -u root -p password and it gives you the list of default variables. You can get this same message by typing mydqld --help, which might indicate some error in the command line arguments. This file also shows you configurations supplied on the command line as well as configurations found in files such as my.cnf (this may help you). It wont tell you where the value came from, but it will show them. the few lines after the following line might show something of importance: The default values (after parsing the command line arguments) are: It also shows which command line options are allowed. -u or --user are valid, -p however is not listed in those options -Original Message- From: Steven Roussey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 3:13 PM To: 'Intrex' Cc: 'Mysql' Subject: RE: mysql on Linux When I execute mysqld -u root -p password I am presented with the default variables. Which are? How about showing what mysqld --user=root displays? Also, you see linux-bin.* files? That indicates that mysqld was running at some point (maybe nine times). Can you get the directory listings with ls -l ? Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 on Linux
Today I migrated my system to RH7.1. I had been running mysql on Mandrake 7.2 but I wanted to use the newer versions which require kernel 2.4.x. I experienced exactly the same problems as you with the RPM of mysql which came with the RH distro. I looked at everything and then some that had been pointed out in this thread and was having equally poor results. No amount of fiddling caused the symptoms to change in the slightest. I solved the problem by downloading the 3.23.49a RPM from mysql.com and installing that. First time I tried the new version, it worked exactly like it is supposed to. I was both surprised and pleased with this outcome. Fixes for such nasty problems aren't supposed to be so easy. 8-) I'm not going to try to guess what the exact problem is. I'm just letting you know how I resolved it. Hope you have as much good luck, Doug The On Wed, 06 Mar 2002 10:07:12 -0800, Steven Roussey wrote: Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended This is written by safe_mysqld. It seems that mysqld was never started successfully. I've had this issue before. Every time it was a permissions issue. When I execute mysqld -u root -p password I am presented with the default variables. Which are? Also, what is in /var/lib/mysql? Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 on Linux
Hi, Download the binary distribution that suits your system and read the INSTALL-BINARY file. Also, make sure the online documentation at http://www.mysql.com/documentation/index.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 09, 2001 12:34 AM To: mysql Subject: mysql on Linux Hello I want to install mysql on Linux. What are the basic step followed at the time of installation. pl. gave any suitable idea. Manish Mehta E-mail: [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 on Linux
Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100 TIMES is NO help. I have read this file, I have used the appropriate .tar.gz, I have reinstalled, I have used the most current RPM's How about contributing something USEFUL, like a REAL answer, that anyone can follow. No cryptic mumbo jumbo, no PhD CRAPOLA. I mean REALLY. Mark - Original Message - From: Jorge del Conde [EMAIL PROTECTED] To: 'Manish Mehta' [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, October 09, 2001 1:48 AM Subject: RE: mysql on Linux Hi, Download the binary distribution that suits your system and read the INSTALL-BINARY file. Also, make sure the online documentation at http://www.mysql.com/documentation/index.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 09, 2001 12:34 AM To: mysql Subject: mysql on Linux Hello I want to install mysql on Linux. What are the basic step followed at the time of installation. pl. gave any suitable idea. Manish Mehta E-mail: [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 - 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 on Linux
No need to get all snarky. People are confused because there's a whole section in the manual that covers the installation, step-by-step, with no cryptic mumbo jumbo. This is at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Linux-RPM and basically tells you to download the RPM and then install it using rpm -i. Alternatively, if you have a .tar.gz file, you can follow the install directions given therein. We _CANNOT_ help you further without you telling us what part of the install you are having problems with. The step-by-step instructions are available as people have pointed out. So what are you asking for? On Tuesday 05 March 2002 4:23 pm, Intrex wrote: Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100 TIMES is NO help. I have read this file, I have used the appropriate .tar.gz, I have reinstalled, I have used the most current RPM's How about contributing something USEFUL, like a REAL answer, that anyone can follow. No cryptic mumbo jumbo, no PhD CRAPOLA. I mean REALLY. Mark - Original Message - From: Jorge del Conde [EMAIL PROTECTED] To: 'Manish Mehta' [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, October 09, 2001 1:48 AM Subject: RE: mysql on Linux Hi, Download the binary distribution that suits your system and read the INSTALL-BINARY file. Also, make sure the online documentation at http://www.mysql.com/documentation/index.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 09, 2001 12:34 AM To: mysql Subject: mysql on Linux Hello I want to install mysql on Linux. What are the basic step followed at the time of installation. pl. gave any suitable idea. Manish Mehta E-mail: [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 - 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 on Linux
Mark, This probably won't get you the response you wanted. How about letting us know where you have gotten to and where things seem to be breaking. A generalized request for what do I do often recieves little or no help. Some basic system information would also be much appreciated; what distro are you using, what type of hardware PPC, Intel, etc. Scott - Original Message - From: Intrex [EMAIL PROTECTED] To: Jorge del Conde [EMAIL PROTECTED]; 'Manish Mehta' [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 6:23 PM Subject: Re: mysql on Linux Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100 TIMES is NO help. I have read this file, I have used the appropriate .tar.gz, I have reinstalled, I have used the most current RPM's How about contributing something USEFUL, like a REAL answer, that anyone can follow. No cryptic mumbo jumbo, no PhD CRAPOLA. I mean REALLY. Mark - Original Message - From: Jorge del Conde [EMAIL PROTECTED] To: 'Manish Mehta' [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, October 09, 2001 1:48 AM Subject: RE: mysql on Linux Hi, Download the binary distribution that suits your system and read the INSTALL-BINARY file. Also, make sure the online documentation at http://www.mysql.com/documentation/index.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 09, 2001 12:34 AM To: mysql Subject: mysql on Linux Hello I want to install mysql on Linux. What are the basic step followed at the time of installation. pl. gave any suitable idea. Manish Mehta E-mail: [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 - 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 on Linux
Ok. SuSE 7.3 Digital HiNote VP745 mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47 for SuSE I have installed the .tar.gz and followed those instructions I have installed the RPM's using the -i, and also installed the RPM's using Yast1 package installer. Each time I have reformatted my system and re-installed in order to insure I did not have stray variables hanging around from the previous installation. When I execute mysqld -u root -p password I am presented with the default variables. When I execute safe_mysqld the following message is given Starting mysqld daemon with databases from /var/lib/mysql 020305 07:36:44 mysql ended I have insured that the mysql_install_db has indeed placed the permission databases in that directory, and that the variables listed in the my.cnf are indeed correct. After starting the safe_mysqld and trying to run mysqladmin create databasename I get the message: mysqladmin:connect to server at 'localhost' failed error: 'Can't connect to MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Running locate mysql.sock returns no such file, which would be correct since the mysqld daemon never started. has anyone had this particular problem. I can assure you I have followed the instructions in the documentation I have been repetedly poited to numerous times. What I am also sure, is that the documentation is also more than likely 'assuming' something that is NOT in the docs. Any ideas what I am missing? I do not know what I am missing here, that is causing the - Original Message - From: Scott Helms [EMAIL PROTECTED] To: 'mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 6:54 PM Subject: Re: mysql on Linux Mark, This probably won't get you the response you wanted. How about letting us know where you have gotten to and where things seem to be breaking. A generalized request for what do I do often recieves little or no help. Some basic system information would also be much appreciated; what distro are you using, what type of hardware PPC, Intel, etc. Scott - Original Message - From: Intrex [EMAIL PROTECTED] To: Jorge del Conde [EMAIL PROTECTED]; 'Manish Mehta' [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 6:23 PM Subject: Re: mysql on Linux Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100 TIMES is NO help. I have read this file, I have used the appropriate .tar.gz, I have reinstalled, I have used the most current RPM's How about contributing something USEFUL, like a REAL answer, that anyone can follow. No cryptic mumbo jumbo, no PhD CRAPOLA. I mean REALLY. Mark - Original Message - From: Jorge del Conde [EMAIL PROTECTED] To: 'Manish Mehta' [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, October 09, 2001 1:48 AM Subject: RE: mysql on Linux Hi, Download the binary distribution that suits your system and read the INSTALL-BINARY file. Also, make sure the online documentation at http://www.mysql.com/documentation/index.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 09, 2001 12:34 AM To: mysql Subject: mysql on Linux Hello I want to install mysql on Linux. What are the basic step followed at the time of installation. pl. gave any suitable idea. Manish Mehta E-mail: [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 - 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
Re: mysql on Linux
On Tue, 5 Mar 2002, Intrex wrote: Ok. SuSE 7.3 Digital HiNote VP745 mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47 for SuSE I have installed the .tar.gz and followed those instructions I have installed the RPM's using the -i, and also installed the RPM's using Yast1 package installer. Each time I have reformatted my system and re-installed in order to insure I did not have stray variables hanging around from the previous installation. When I execute mysqld -u root -p password I am presented with the default variables. When I execute safe_mysqld the following message is given Starting mysqld daemon with databases from /var/lib/mysql 020305 07:36:44 mysql ended What does the error log say at this point? It probably has a lot more detail on exactly what caused it to end. This log is probably in /var/lib/mysql/hostname.err (this is the default behavior). Possible problems are there is no mysql user, or the data directory or the mysql table isn't owned by the mysql user. This will be spelled out clearly in the error log. james montebello - 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 on Linux
I do have a mysql user, and have used the commands to assigne rights for the mysql user per the instructions. I have no hostname.err, only linux.err which displays the exact same errors I typed out. Mark - Original Message - From: James Montebello [EMAIL PROTECTED] To: Intrex [EMAIL PROTECTED] Cc: Scott Helms [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 10:59 AM Subject: Re: mysql on Linux On Tue, 5 Mar 2002, Intrex wrote: Ok. SuSE 7.3 Digital HiNote VP745 mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47 for SuSE I have installed the .tar.gz and followed those instructions I have installed the RPM's using the -i, and also installed the RPM's using Yast1 package installer. Each time I have reformatted my system and re-installed in order to insure I did not have stray variables hanging around from the previous installation. When I execute mysqld -u root -p password I am presented with the default variables. When I execute safe_mysqld the following message is given Starting mysqld daemon with databases from /var/lib/mysql 020305 07:36:44 mysql ended What does the error log say at this point? It probably has a lot more detail on exactly what caused it to end. This log is probably in /var/lib/mysql/hostname.err (this is the default behavior). Possible problems are there is no mysql user, or the data directory or the mysql table isn't owned by the mysql user. This will be spelled out clearly in the error log. james montebello - 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 on Linux
When I execute mysqld -u root -p password I am presented with the default variables. The manual says to use safe_mysqld to properly start mysqld. Also, --user=root is clearer for that option. And, what are you doing with -p password in starting the daemon? This is not an option, it is an error. http://www.mysql.com/doc/s/a/safe_mysqld.html Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 on Linux, Athlon MP stability?
Tobias Lind - Telia Internet [EMAIL PROTECTED] writes: Hello! I'm in the process of upgrading my Linux-server (currently a dual P2-400MHz), and have been thinking about getting a system with dual Athlons (maybe 2x Athlon MP 1800+). Does anyone have any experience (good or bad) with a dual Athlon system with Linux running MySQL 3.23.x, and maybe Apache under HEAVY load? Our kernel people love them - Athlon goodness, no VIA chipset. Good performance, good stability. Since the Athlon MP's haven't been around for very long, I'm a bit concerned about the stability under heavy load on the 2.4 kernel... Ve've supported it since RHL 7.1 (which was released before the Athlon MP, if memory serves :). So please, if you have a success- or disaster-story I'd like to know! :) I'm also very interested in what mainboard you are using for the Athlons, and what Linux-kernel version you're running... Red Hat Linux, various release and test versions (kernel and surrounding OS). -- Trond Eivind Glomsrød Red Hat, Inc. - 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 on Linux, Athlon MP stability?
Well, I don't have anything yet, but I've got a server in the mail coming to me that is a dual Athlon MP 1900+. I'll be getting it either today, or tomorrow with any luck, and I'll let you know how things go. Gonna be running SuSE 7.3, PHP, MySQL, Apache, BIND9 and various other packages on it. Oh, and SETI@Home, to burn in the processors. ;) Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Tobias Lind - Telia Internet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 9:32 AM To: [EMAIL PROTECTED] Subject: MySQL on Linux, Athlon MP stability? Hello! I'm in the process of upgrading my Linux-server (currently a dual P2-400MHz), and have been thinking about getting a system with dual Athlons (maybe 2x Athlon MP 1800+). Does anyone have any experience (good or bad) with a dual Athlon system with Linux running MySQL 3.23.x, and maybe Apache under HEAVY load? Since the Athlon MP's haven't been around for very long, I'm a bit concerned about the stability under heavy load on the 2.4 kernel... So please, if you have a success- or disaster-story I'd like to know! :) I'm also very interested in what mainboard you are using for the Athlons, and what Linux-kernel version you're running... Thanks in advance! /Tobias Lind - 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 - 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 on Linux, Athlon MP stability?
On Wednesday 13 February 2002 12:10 pm, Trond Eivind Glomsrød wrote: Our kernel people love them - Athlon goodness, no VIA chipset. Good performance, good stability. Note that the Via kt266a (_not_ SMP chipset) is quite good these days. If I was building a dual-processor machine, there's no doubt I'd go for an Athlon system at the moment. For a quad-processor machine, I'd look much more closely at the P3 Xeon chip (the P4 Xeon has no 4-processor motherboards afaik). ObMySQL: Make sure you are CPU-limited before considering SMP machines. If you are hard drive limited, you aren't likely to see any advantage going for more CPUs. SELECT MySQL PostGreSQL, UPDATE, INSERT, terrorism, world trade centre, replication, etc. - 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 on Linux 2.4 question
On Thu, Jan 10, 2002 at 12:59:01AM +0200, Heikki Tuuri wrote: Walt, The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer. Somewhere in about version 2.4.10 Linus changed the virtual memory. I am not sure how stable kernels 2.4.10 - .17 are, but at least some people are running them with success. 2.4.xx is stable, but you probably want the 'xx' to be as high as possible. The VM on the lower values really starts to suck. :-( 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 7 days, processed 187,489,138 queries (287/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 on Linux 2.4 question
600,000 row table? what are you storing on that bad boy? - Original Message - From: Weaver, Walt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 09, 2002 2:17 PM Subject: MySQL on Linux 2.4 question Anyone else out there been playing with the new Linux 2.4 kernel? I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB tests. The results were dramatic; updating a 600,000 row table went from 21 minutes and change to 6 minutes and change. Haven't tried 2.4 and MyISAM tables yet; on 2.2 the same update ran in about 8 minutes. This is obviously a big improvement, if my tests are valid. It's SUCH a big improvement that I'm wondering if I messed something up. Any comments/statement of support/snide remarks will all be appreciated. Thanks, --Walt Weaver Bozeman, Montana - 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 on Linux 2.4 question
Amazing! I've not had a chance to upgrade a server to 2.4 yet, though I've long imagined that the results would be similar. I imagine the biggest performance boost you received is due to the built-in multi-threading that the 2.4 kernel enjoys which is currently lacking in the 2.2 kernel. Linux is becoming more robust all the time along with a pretty hard kernel. It's come a long way in a short time. Linux is developing along a more solid path than Windoze. Even the big boys are turning to open source to handle the high-traffic/high-availability jobs. Yahoo saved somewhere around 17 million dollars by switching needed infrastructure over to linux/open source. I just read today that MySQL is their big database that handles 800 transactions a second for their stock quotes and financial handlings. In the year that M$ wants to rent the OS to you, linux will only continue to grow in it's usage as the desktop gets more friendly and the applications are developed to make people want to use linux instead of windoze. Tyler -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 5:18 PM To: [EMAIL PROTECTED] Subject: MySQL on Linux 2.4 question Anyone else out there been playing with the new Linux 2.4 kernel? I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB tests. The results were dramatic; updating a 600,000 row table went from 21 minutes and change to 6 minutes and change. Haven't tried 2.4 and MyISAM tables yet; on 2.2 the same update ran in about 8 minutes. This is obviously a big improvement, if my tests are valid. It's SUCH a big improvement that I'm wondering if I messed something up. Any comments/statement of support/snide remarks will all be appreciated. Thanks, --Walt Weaver Bozeman, Montana - 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 on Linux 2.4 question
Walt, Yup, we use Innodb with 3.23.46 on Linux 2.4.2. I can't tell you whether things are better than they were on 2.2 kernels but we're updating tables just about that quickly I'd say. Largest table we have is a log table which has 50 million rows in it so far. Thanks to Innodb row locking, we've significantly improved insert versus select query performance. I've heard (I think I read this in a magazine) that prior to 2.4.4 kernel, there are some virtual memory issues with Mysql, so I'd be interesetd to know what kernel version you have... memory management changed a lot between 2.2 and 2.4, so that would probably account for the changes you're seeing. JOhn Weaver, Walt wrote: Anyone else out there been playing with the new Linux 2.4 kernel? I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB tests. The results were dramatic; updating a 600,000 row table went from 21 minutes and change to 6 minutes and change. Haven't tried 2.4 and MyISAM tables yet; on 2.2 the same update ran in about 8 minutes. This is obviously a big improvement, if my tests are valid. It's SUCH a big improvement that I'm wondering if I messed something up. Any comments/statement of support/snide remarks will all be appreciated. Thanks, --Walt Weaver Bozeman, Montana - 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 on Linux 2.4 question
Walt, a possible reason is that fsync is much faster in Linux-2.4 than in 2.2. Check that the combined size of your log files is 50 % - 100% of the buffer pool size. Small log files cause more disk i/o and more fsyncs. The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer. Somewhere in about version 2.4.10 Linus changed the virtual memory. I am not sure how stable kernels 2.4.10 - .17 are, but at least some people are running them with success. 2.5.1 seems to be unstable. Regards, Heikki . Anyone else out there been playing with the new Linux 2.4 kernel? I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB tests. The results were dramatic; updating a 600,000 row table went from 21 minutes and change to 6 minutes and change. Haven't tried 2.4 and MyISAM tables yet; on 2.2 the same update ran in about 8 minutes. This is obviously a big improvement, if my tests are valid. It's SUCH a big improvement that I'm wondering if I messed something up. Any comments/statement of support/snide remarks will all be appreciated. Thanks, --Walt Weaver Bozeman, Montana - 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, innodb, linux problems
Prabhu, 4.0.x is the development version. 3.23.xx is better tested. But 4.0.1 looks good now that it has been out a couple of weeks. Upgrading to 4.0.1 is another possibility. Regards, Heikki Tuuri Innobase Oy --- MySQL/InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com At 11:55 AM 1/7/02 +0530, you wrote: Hi Heikki, There is 4.xx version available. why upgrade to 3.xx version? -- Prabhu On Fri, 4 Jan 2002, Heikki Tuuri wrote: Date: Fri, 4 Jan 2002 16:55:29 +0200 From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Mysql, innodb, linux problems Bernard, please upgrade to 3.23.47. There were several hang bugs in 3.23.39. Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Hello, Hope it is a good place for the following question I use Mysql (3.23.39) and InnoDB tables on Linux (2.2.17-14smp) and I got deadlock (In suppose it is a deadlock) when I do intensive work. intensive work = one insert + one update + 2 selects (simultaneously, with 4 differents processes, on the same table) I got deadlock = My processes went down (after the timeout I had set) and if I try an interactive request on the table (like select count(*) from ... I never got the answer. - 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 --- Beauty is bought by judgement of the eye. -- Shakespeare --- Prabhu SR. Sankhya Technologies Private Limited, Chennai-34. --- - 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, innodb, linux problems
Hi Heikki, There is 4.xx version available. why upgrade to 3.xx version? -- Prabhu On Fri, 4 Jan 2002, Heikki Tuuri wrote: Date: Fri, 4 Jan 2002 16:55:29 +0200 From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Mysql, innodb, linux problems Bernard, please upgrade to 3.23.47. There were several hang bugs in 3.23.39. Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Hello, Hope it is a good place for the following question I use Mysql (3.23.39) and InnoDB tables on Linux (2.2.17-14smp) and I got deadlock (In suppose it is a deadlock) when I do intensive work. intensive work = one insert + one update + 2 selects (simultaneously, with 4 differents processes, on the same table) I got deadlock = My processes went down (after the timeout I had set) and if I try an interactive request on the table (like select count(*) from ... I never got the answer. - 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 --- Beauty is bought by judgement of the eye. -- Shakespeare --- Prabhu SR. Sankhya Technologies Private Limited, Chennai-34. --- - 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, innodb, linux problems
Bernard, please upgrade to 3.23.47. There were several hang bugs in 3.23.39. Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Hello, Hope it is a good place for the following question I use Mysql (3.23.39) and InnoDB tables on Linux (2.2.17-14smp) and I got deadlock (In suppose it is a deadlock) when I do intensive work. intensive work = one insert + one update + 2 selects (simultaneously, with 4 differents processes, on the same table) I got deadlock = My processes went down (after the timeout I had set) and if I try an interactive request on the table (like select count(*) from ... I never got the answer. - 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, innodb, linux problems
Hello, As recommended I upgrade from 3.23.39 to 3.23.47 and now everything works very well Intensive insert with simultaneous update and several simultaneous select on the same table works perfectly on InnoDB tables Regards -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email: mailto:[EMAIL PROTECTED] Tel : 04 72 69 42 18 - 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 Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Trond Eivind Glomsrød writes: Robert Alexander [EMAIL PROTECTED] writes: I know that, but I'm pretty sure sourceforge is one of their mirrors. -- Trond Eivind Glomsrød Red Hat, Inc. Yes, it should be one of our mirrors. I truly do not know whether files are exact copy. But, this is not important now, as user's problems were solved. -- 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 Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Trond Eivind =?iso-8859-1?Q?Glomsr=F8d?= writes: Robert Alexander [EMAIL PROTECTED] writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp Try a binary from our site. The above one _is_ your site, isn't it? The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try: http://www.mysql.com/downloads/ I know that, but I'm pretty sure sourceforge is one of their mirrors. Yes, SourceForge has our *official* binaries... the same as MySQL.com. 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 Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Ron Jamison writes: Hi, I'm trying to use the available MySQL Linux Alpha binary distribution on this AlphaServer: Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST 2001 alpha unknown Running RedHat 7.1 Alpha Deluxe, Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp haev6.tar.gz Thanks in advance! Ron Jamison Hi! Try a binary from our site. If you get again illegal instruction, that will mean that CPU versions are too different. Building from source requires lot's of compiler options to tune for speed. Try using a better compiler, like GNU 3.0.2 or even better Compaq 6.3, if there is one for Linux. -- 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 Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Hi, I'm trying to use the available MySQL Linux Alpha binary distribution on this AlphaServer: Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST 2001 alpha unknown Running RedHat 7.1 Alpha Deluxe, Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp haev6.tar.gz Thanks in advance! Ron Jamison Hi! Try a binary from our site. The above one _is_ your site, isn't it? -- Trond Eivind Glomsrød Red Hat, Inc. - 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 Alpha Linux binary distribution: Core dumped onAlphaServer 1200
Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp Try a binary from our site. The above one _is_ your site, isn't it? -- Trond Eivind Glomsrød Red Hat, Inc. The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try: http://www.mysql.com/downloads/ HTH, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - 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 Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Robert Alexander [EMAIL PROTECTED] writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp Try a binary from our site. The above one _is_ your site, isn't it? The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try: http://www.mysql.com/downloads/ I know that, but I'm pretty sure sourceforge is one of their mirrors. -- Trond Eivind Glomsrød Red Hat, Inc. - 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 Alpha Linux binary distribution: Core dumped on AlphaServer 1200
After doing some more research I found out that the chip in the AS 1200 is an EV56, and made the connection between that and the EV6 binary dumping on me. Following the advice of 2.6.1.4 Linux Alpha Notes at: http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Li nux-Alpha I installed the Compaq Linux Alpha compiler (ccc and cxx) and built the latest MySQL source with configure flags: CC=ccc CFLAGS=-fast CXX=cxx CXXFLAGS=-fast -noexceptions -nortti ./configure --prefix=/usr/local/mysql --disable-shared --with-extra-charsets =complex --enable-thread-safe-client --with-mysqld-ldflags=-non_shared --wit h-client-ldflags=-non_shared Yay, it works! However I cannot benchmark it using sql-bench: [root@jive mysql]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.6.0/alpha-linu x -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: _OtsMove at /usr/lib/perl5/5.6.0/alpha-linux/DynaLoader.pm line 200. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 I've tried using Msql-Mysql-modules version 1.2216 and version 1.2218. For the latter version I've tried compiling using the ccc compaq compiler with success. However it is failing in DynaLoader.pm which to my knowledge is a module for loading C libraries into perl. So my question now is.. do I need to recompile Perl with the CCC compiler? What steps did the MySQL team take to get sql-bench running on the alpha EV6 machine? I'd prefer to continue using sql-bench as its easier imho than installing a 3rd party benchmark app. Thanks, Ron Jamison -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Trond Eivind Glomsrød Sent: Thursday, December 13, 2001 9:39 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200 Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Hi, I'm trying to use the available MySQL Linux Alpha binary distribution on this AlphaServer: Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST 2001 alpha unknown Running RedHat 7.1 Alpha Deluxe, Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp haev6.tar.gz Thanks in advance! Ron Jamison Hi! Try a binary from our site. The above one _is_ your site, isn't it? -- Trond Eivind Glomsrød Red Hat, Inc. - 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 Alpha Linux binary distribution: Core dumped on AlphaServer 1200
SourceForge is indeed one of their mirrors. Robert if you look you'll see Monty listed as a project admin. I find it easier to download direct from the sourceforge mirror than to navigate through the new download system on mysql.com. I hate it when I wget an html file instead of the tarball I'm seeking. Sorry if this message gets to you twice, Trond. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Trond Eivind Glomsrød Sent: Thursday, December 13, 2001 11:51 AM To: Robert Alexander Cc: [EMAIL PROTECTED] Subject: Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200 Robert Alexander [EMAIL PROTECTED] writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp Try a binary from our site. The above one _is_ your site, isn't it? The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try: http://www.mysql.com/downloads/ I know that, but I'm pretty sure sourceforge is one of their mirrors. -- Trond Eivind Glomsrød Red Hat, Inc. - 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 Alpha Linux binary distribution: Core dumped onAlphaServer 1200
At 14:51 -0500 2001/12/13, Trond Eivind Glomsrød wrote: I know that, but I'm pretty sure sourceforge is one of their mirrors. -- Trond Eivind Glomsrød Red Hat, Inc. At 12:04 -0800 2001/12/13, Ron Jamison wrote: SourceForge is indeed one of their mirrors. Robert if you look you'll see Monty listed as a project admin. I find it easier to download direct from the sourceforge mirror than to navigate through the new download system on mysql.com. I hate it when I wget an html file instead of the tarball I'm seeking. Ahh, OK. Didn't know about the SourceForge site. I've always just used the 'home' site. Thanks, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - 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 on linux redhat v.7
On Wed, 25 Apr 2001, george wrote: rpm -ivh mysql-3.23.36-1.i386.rpm mysql-client-3.23.36-1.i386.rpm Better approach would be to use the update switch. rpm -Uvh the output says: file /usr/bin/safe_mysqld from install of mysql-3.23-36-1 conflicts with file from package mysql-server 3.23.22-6 Seems that you have an earlier version of mysql installed. This is telling you that you have mysql 3.23.22-6 installed, and that you're replacing files that it needs. Problem might be solved using the update switch as I listed above to do the update. i then did rpm -e mysql Redhat's packages are rarely named just the application name. You can see what the exact package name is by issuing the following command: rpm -qa|grep -i mysql This will report back to you any packages containing the word mysql (upper or lower case) in the package name. Then you rpm -e full-package-name to uninstall it. which produced the output: error. package mysql is not installed See above for more details. Hope this helps. Ed - 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