add one more innodb_data file when I do have an autoextending one?
I have an production MySQL-Max -3.23.54a server running innodb databases. I've migrated the server and data from an older Linux installation (with max filesize 2GByte). The new server is running Linux 2.4 and can deal with larger files. I have three in innodb_data files and the last one is autoextending and it's soon full. My innodb_data_file_path looks like this (wordwrapped in order to make it readable). innodb_data_file_path = disk1/innodb/ibdata/ibdata1:2000M; disk1/innodb/ibdata/ibdata2:2000M; disk1/innodb/ibdata/ibdata3:100M:autoextend:max:2000M Can I remove the autoextend option on the last data_file, and add a new one wich is autoextending? Will mysql make the ibdata3 file like the other files automatically? Does it work or will I lose data? I want to do this with as little downtime as possible. I've tried to add a ibdata4 file thats autoextending but MySQL only supports one autoextending file. /Lars sql,query - 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: restricting mysql
On Fri, 15 Nov 2002, Admin-Stress wrote: > I tried --skip-networking, but then mysqld could not be started. I got this from >google.com. Is it > the correct way? It's correct. Put this in your /etc/my.cnf and restart mysql. [mysqld] skip-networking /Lars - 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: Upgrading MySQL from 3.23.41 to 3.23.53a
At 13:47 2002-11-13 -0500, Rick Root wrote: [root@frodo MySQL]# rpm --install MySQL-3.23.53a-1.i386.rpm error: failed dependencies: MySQL conflicts with mysql-3.23.41-1 MySQL-server conflicts with mysql-server-3.23.41-1 [root@frodo MySQL]# rpm -U MySQL-3.23.53a-1.i386.rpm error: failed dependencies: MySQL-server conflicts with mysql-server-3.23.41-1 libmysqlclient.so.10 is needed by mysql-server-3.23.41-1 So what should I do? Do I need to actually remove the old MySQL first and then install the new one? You are trying to replace the redhat installed mysql with MySQL:s rpms. Do things in this order and it should work (I don't promise it will work =) 1. do a full mysqldump of all your databases. 2. shutdown and remove mysql with rpm -e 3. Install the new mysql, start it and check if your databases are intact. Else restore from dumps. regards /Lars - 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
max-3.23.53a crash?
Hi, Today I had a crash on my production server running Max-3.23.53a It has the following specifications MySQL-Max3.23.53a RedHat 7.3 Kernel 2.4.18-SMP Glibc-2.2.5-42 2GB of memory When I resolv my stack_dump I get the following. Can anyone make something useful out of this? I was not running with any other logging, I've turned it on now if this is going to be happening a lot (remembering the glibc problems...) == resolve_stack_dump -s /usr/lib/mysql/mysqld.sym -n mysqld.stack 0x806eeb4 init_signals__Fv + 16 0x82d9b38 _end + 421148 0x80ada70 test_quick_select__10SQL_SELECTUlUlUlb + 828 0x80af33c key_or__FP7SEL_ARGT0 + 316 0x80aef61 key_and__FP7SEL_ARGT0Ui + 573 0x80ae1fd get_mm_tree__FP13st_qsel_paramP4Item + 1121 0x80adead get_mm_tree__FP13st_qsel_paramP4Item + 273 0x8090ebf make_join_readinfo__FP4JOINUi + 735 0x808ce3a mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result + 3258 0x8075d90 mysql_execute_command__Fv + 1628 0x8079ecc reload_acl_and_cache__FP3THDUiP13st_table_list + 280 0x8074f34 do_command__FP3THD + 2276 0x80742e7 handle_bootstrap__FPv + 303 The complete log looks like this. = /usr/sbin/mysqld-max: ready for connections 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=402649088 record_buffer=131072 sort_buffer=2097144 max_used_connections=60 max_connections=400 threads_connected=3 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1263608 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... Stack range sanity check OK, backtrace follows: Stack range sanity check OK, backtrace follows: 0x806eeb4 0x82d9b38 0x80ada70 0x80af33c 0x80aef61 0x80ae1fd 0x80adead 0x8090ebf 0x808ce3a 0x8075d90 0x8079ecc 0x8074f34 0x80742e7 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x8c509020 is invalid pointer thd->thread_id=3282450 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 3282450 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash Number of processes running now: 0 021113 18:28:15 mysqld restarted 021113 18:28:15 Can't start server: Bind on TCP/IP port: Address already in use 021113 18:28:15 Do you already have another mysqld server running on port: 3306 ? 021113 18:28:15 Aborting /Lars - 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 fills the disk with temporary files?
Mysql is installed properly with user mysql and group mysql. What happens if I limit the maximum filesize for the mysql user? When it reches that size it will send what kind of errors to the user doing the query? Another problem is that I have quite big innodb data-files, owned by mysql, the limit would also stop the auto-increase files from growing I guess? That's the primary reason. Another reason is the normal MyISAM datafiles, some of them are quite big also. Thats a few reasons that makes me want to solve this on the mysql-server level instead of at the OS level. - lars On Thu, 31 Oct 2002, Jan Steinman wrote: > >From: Lars Andersson <[EMAIL PROTECTED]> > > > >Thanks for your advices, but I don't want to solve this problem on the > >OS/shell level. > > Assuming MySQL is installed properly, with its own user and group, I don't see why >you should not want to solve the problem this way. > > - 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 fills the disk with temporary files?
Is there any way to put a limit on the size of temporary tables? Or is it possible for my users to put the server down just by creating some kind of big cartesian product as a result of a big join? The server is used in an production environment and it would be a great releaf if there is some way I can stop the users from filling up the disks. -- lars On Thu, 31 Oct 2002, gerald_clark wrote: > You may have a malformed join that is giving you a very large result set. > These would be the temporary tables. > > Lars Andersson wrote: > > >Hi, > > > >I manage a mysql server with a few hundred users. All of a sudden mysql > >has started to put large files in /tmp > > > >I've never noticed this behavior before. The files looks like this > > > >-rw-rw1 mysqlmysql3788431360 Oct 31 17:49 #sql420e_36b82b_1.MYD > >-rw-rw1 mysqlmysql1024 Oct 31 17:39 #sql420e_36b82b_1.MYI > >-rw-rw1 mysqlmysql1094713344 Oct 31 17:49 #sql420e_36b8c6_1.MYD > >-rw-rw1 mysqlmysql1024 Oct 31 17:45 #sql420e_36b8c6_1.MYI > > > >I wonder if this is the result of someone making a heap table to big to > >fit into the servers memory? > > > >How do I stop these files from filling my diskspace. The server filled > >10GB of space in notime and forced me to halt the server and put in some > >extra disks and symlink some directories to the new disks. > >query,sql - 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 fills the disk with temporary files?
Thanks, Unfortunatley I think things will break if I remove the temporary files while they still are in use =) I want a solution that keeps the files limited in size. There must be some settings that controll this kind of stuff. /Lars On Thu, 31 Oct 2002, Black, Kelly W [PCS] wrote: > #!/usr/local/bin/perl > use strict; > my @files=(`/bin/ls /tmp/sql*.M*`); > for (@files) { > unlink; > } > exit 0; > > > shell> crontab -e > > 0 2 * * * /usr/local/bin/perl /path/to/delete/program > > :wq > > :) > -Original Message- > From: Lars Andersson [mailto:lars@;rockar.nu] > Sent: Thursday, October 31, 2002 9:56 AM > To: [EMAIL PROTECTED] > Subject: mysql fills the disk with temporary files? > > > Hi, > > I manage a mysql server with a few hundred users. All of a sudden mysql > has started to put large files in /tmp > > I've never noticed this behavior before. The files looks like this > > -rw-rw1 mysqlmysql3788431360 Oct 31 17:49 > #sql420e_36b82b_1.MYD > -rw-rw1 mysqlmysql1024 Oct 31 17:39 > #sql420e_36b82b_1.MYI > -rw-rw1 mysqlmysql1094713344 Oct 31 17:49 > #sql420e_36b8c6_1.MYD > -rw-rw1 mysqlmysql1024 Oct 31 17:45 > #sql420e_36b8c6_1.MYI > > I wonder if this is the result of someone making a heap table to big to > fit into the servers memory? > > How do I stop these files from filling my diskspace. The server filled > 10GB of space in notime and forced me to halt the server and put in some > extra disks and symlink some directories to the new disks. > > I'm running > MySQL-Max-3.23.53a > 2x1.3Ghz PIII with 2GB of ram > RedHat 7.3 > glibc-2.2.5-40. > > Could this file-thing be related to the glibc-mysql problems? > > regards > /Lars > > > query,sql > > > - > 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
mysql fills the disk with temporary files?
Hi, I manage a mysql server with a few hundred users. All of a sudden mysql has started to put large files in /tmp I've never noticed this behavior before. The files looks like this -rw-rw1 mysqlmysql3788431360 Oct 31 17:49 #sql420e_36b82b_1.MYD -rw-rw1 mysqlmysql1024 Oct 31 17:39 #sql420e_36b82b_1.MYI -rw-rw1 mysqlmysql1094713344 Oct 31 17:49 #sql420e_36b8c6_1.MYD -rw-rw1 mysqlmysql1024 Oct 31 17:45 #sql420e_36b8c6_1.MYI I wonder if this is the result of someone making a heap table to big to fit into the servers memory? How do I stop these files from filling my diskspace. The server filled 10GB of space in notime and forced me to halt the server and put in some extra disks and symlink some directories to the new disks. I'm running MySQL-Max-3.23.53a 2x1.3Ghz PIII with 2GB of ram RedHat 7.3 glibc-2.2.5-40. Could this file-thing be related to the glibc-mysql problems? regards /Lars query,sql - 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: innodb and freespace?
I have now ReadTheFineManual ;-) and learned that I can use autoextend and create a new innodb-data file by changing my.cnf and restart mysql. I've also done just that with success, now I have an autoextend database file and two static ones. Is there any simple way to monitor the free space of my databases? I can allways monitor the size of my autoextend database, if it grows to big I need to create more files. There must be some way to monitor this with mysql commands, I haven't find any. If I do a show table status now it does only show the free size in my current file, not the size it would have if it had grown to it maximum size. /Lars On Fri, 18 Oct 2002, Lars Andersson wrote: > I have a question about innodb, some of my users get an error code 1114 > saying that a table on an innodb database is full. > > When I do a show table status i get the following size comments (all > tables display one or another of these two). > Comment: InnoDB free: 5849088 kB; InnoDB free: 3072 kB > Comment: InnoDB free: 3072 kB > > How come it says InnoDB free: 3072 kB when I seem to have 5849088 kB > free? And why does the other comment say something diffrent? I use two > 2gb innodb data files. > > If I make another database file will it solve the problem? > > Can I use the autoextend option under MySQL-Max-3.23.53a? > > > - lars > > > > - > 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
innodb and freespace?
I have a question about innodb, some of my users get an error code 1114 saying that a table on an innodb database is full. When I do a show table status i get the following size comments (all tables display one or another of these two). Comment: InnoDB free: 5849088 kB; InnoDB free: 3072 kB Comment: InnoDB free: 3072 kB How come it says InnoDB free: 3072 kB when I seem to have 5849088 kB free? And why does the other comment say something diffrent? I use two 2gb innodb data files. If I make another database file will it solve the problem? Can I use the autoextend option under MySQL-Max-3.23.53a? - lars - 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
when will 3.23.53a be released?
I wonder if anyone knows when 3.23.53a will be released? I don't need an exact time, just if it's due today, tomorrow or next week. Regards /Lars -anti-spam-workaround sql query - 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: load problems on mysql 3.23.52 with and without Max
I had the same problem with 4.0.4, I downgraded to 3.23.52 because I thought it was something with the unstable version. Is 4.0.4 also built against the same static glibc? regards /Lars >This problem is due to the glibc used by mysql AB for building binary ... > >Have a look to mysql 3.23.53 change log : ><< >We've hopefully fixed the problem with spurious load spikes on Linux > > >systems when accessing the Database via TCP/IP. This was caused by >the > > >static glibc files we used to link against and should now be resolved > >> > >But 3.23.53 have other problems, so if you want to upgrade, wait some hours >for 3.23.53a binary ... > >David - 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: load problems on mysql 3.23.52 with and without Max
This problems are making me a bit tired, forgot to give you information about the systems. MySQL-3.23.52 dual pentium 700, 800MB ram RedHat 6.1 Kernel 2.2.19-6.2.1smp glibc-2.1.3-27 MySQL-3.23.52-Max dual pentium 1.4Ghz, 2 GB ram Redhat 7.3 Kernel 2.4.18-10smp glibc-2.2.5-40 regards /Lars On Wed, 16 Oct 2002, Lars Andersson wrote: > I'm managing two database servers, one 3.23.52 and one 3.23.52-Max > (using innodb tables on that one). > > They are both running along fine until they suddently start to > accumulate a lot of treads (a lot ~= 200-300), the state of these > threads is mostly "closing" and "opening" tables. This drives up the > load to amazing numbers and I'm forced to shut the mysql-server down. > > Since I'm running these servers in a shared environment I got a lot of > users using these servers, and so far I haven't got any grip on whats > causing these problems. I got these problems on both servers (one with > max and one without), both servers got diffrent users. > > I've ruled out hardware problems since I get exactly the same behaviour > on two independent servers. > > It would be great if sombody knows the answer to my questions bellow: > - is there any know problems with mysql on linux? or with 3.23.52 that > should cause this behaviour > > - what should I do to find the error, my logs shows nothing pecuilar. > I'm currently dumping a processlist each five seconds to a file. > > > regards > /Lars > > - 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
load problems on mysql 3.23.52 with and without Max
I'm managing two database servers, one 3.23.52 and one 3.23.52-Max (using innodb tables on that one). They are both running along fine until they suddently start to accumulate a lot of treads (a lot ~= 200-300), the state of these threads is mostly "closing" and "opening" tables. This drives up the load to amazing numbers and I'm forced to shut the mysql-server down. Since I'm running these servers in a shared environment I got a lot of users using these servers, and so far I haven't got any grip on whats causing these problems. I got these problems on both servers (one with max and one without), both servers got diffrent users. I've ruled out hardware problems since I get exactly the same behaviour on two independent servers. It would be great if sombody knows the answer to my questions bellow: - is there any know problems with mysql on linux? or with 3.23.52 that should cause this behaviour - what should I do to find the error, my logs shows nothing pecuilar. I'm currently dumping a processlist each five seconds to a file. regards /Lars - 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 uses 99% cpu under freebsd 4.3
My 4.2 STABLE dosent get so many queries, according to mysqladmin (Queries per second avg: 0.700) the last time it acted up. By the way, it is a dual CPU machine. On another machine with only one CPU running exactly the same code and relese of FreeBSD I havent seen this problem. /Lars Andersson _ Lars Andersson, Tekniker Cable & Wireless - pi.se http://www.pi.se On Wed, 11 Apr 2001, Andrey Kotrekhov wrote: > On Wed, 11 Apr 2001, Sinisa Milivojevic wrote: > > Hi! > > > > Hi Ken, > > > > This seems to be a problem with threads on FreeBSD, although on which > > side, yet remains to be seen. > > > > It seems to appear that it is surfacing not just under heavy load, but > > when there are many threads running. Many means more then 300 or 400. > My mysql server is not under heavy load. We have less then > 20 connection at ones. But we have the same problem under FreeBSD-4.2 STABLE > The mysqld can catch all CPU ones a day, sometimes ones a week. > IMHO it is not depend from number of threads or number of queries at ones. > > > ___ > Andrey Kotrekhov [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 uses 99% cpu under freebsd 4.3
I have experienced the same problems on a dual processor machine running 4.2-STABLE and mysql 3.23.36 from the ports tree. regards, Lars Andersson At 16:03 2001-04-09 -0400, Andrew Schmidt wrote: >Have you tried this under a 'stable' version of freebsd? > >In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. > >now, I understand RC's are generally stable; but I would still make sure >that this bug doesn't show up in a stable os. > >regards, > >-- Andrew > >- Original Message - >From: <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Monday, April 09, 2001 3:34 PM >Subject: mysql uses 99% cpu under freebsd 4.3 > > > > >Description: > > mysql uses 99% cpu and becomes extremely unresponsive under high load > > > > >How-To-Repeat: > > send about 300 simultaneous visitors to www.chicagobusiness.com and tell >them to click around. > > > > > > >Fix: > > restart mysql. this usally helps, at least for a few minutes. sometimes >it climbs back to 99% though. > > > > >Submitter-Id: > > >Originator: Jon Nathan > > >Organization: > > Chaffee Interactive > > >MySQL support: extended email support > > >Synopsis: mysql uses 99% cpu and becomes unresponsive > > >Severity: serious > > >Priority: high > > >Category: mysql > > >Class: support > > >Release: mysql-3.23.36 (Source distribution) from freebsd ports > > > > >Environment: > > System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 >GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 > > > > > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc > > GCC: Using builtin specs. > > gcc version 2.95.2 19991024 (release) > > Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' >CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-except >ions' LDFLAGS='' > > LIBC: > > -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a > > lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so -> libc.so.4 > > -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 > > Configure command: >./configure --localstatedir=/data/db --without-perl --without-debug --witho >ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low- >memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix= >/usr/local i386--freebsd4.3 > > Perl: This is perl, version 5.005_03 built for i386-freebsd > > > > - > > 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
changing mysqld variables?
I´ve got a problem. If I try to change max_connections in /etc/my.cnf the server refuses to start? Isnt I supposed to put startup variables to MySQL in this file? A file looking like this works [mysqld] #max_connections=200 log log-bin log-slow-queries server-id=1 but as soon as I remove the comment on max_connections it wont start. Not even if I set it to a lower value than the default 100. This is on a linux machine running the latest and greatest MySQL compiled from source. /Lars - 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
load balancing, high-availability setup
I want your comments regarding a replication and high-availability setup. This is the setup: Load balancer +---+ | Foundry | | ServerIron | | | +---+ / \ / \ / \ / \ Server 1Server 2 ++ +-+ | Apache | | Apache | | Tomcat | | Tomcat | | + | | + | | mysql | | mysql | || | | | Master | | Slave | ++ +-+ I going to use Server I for all queries that changes the database, and server 1 and 2 should both be used for read-only queries. I want both load balancing and redundancy with this setup. The idea is to separate all queries into two kinds, the ones that change the database should go to "inserthost.mydomain" and the read ones to "localhost". This should balance all the reads between the servers and all the inserts should go into the master (server1). I will make a script that checks if mysqld on server1 is sane, else /etc/hosts should be modified in order to make inserthost.mydomain point to Server2, and a Server2 made into a new master. Is there a smarter solution for redundancy/load balancing with MySQL. I would love to have two MySQL servers that permitted inserts/deletes/updates but since there is no locking implemented yet this is sure to cause problems. The ServerIron takes care of the distribution of the load to the web pages, and also the high-availability questions if one of the tomcat/Apache daemons should die. If anyone has implemented a solution similar to the one I am about to launch I would love to hear your comments. /Lars - 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