RE: Mysql Table Case
Answer is No. Case-sensitivity of table names depends on operating system you are running mysql on.MySQL stores table definitions in TABLENAME.* files. So it will always be case-sensitive on *nix and case-insensitive on windows. Nilesh -Original Message- From: James Kelty [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 12:59 PM To: [EMAIL PROTECTED] Subject: Mysql Table Case Hello, Is there a compile option or startup option to make mysql ignore table name case? So that the tables security and Security would be seen as the same table? -James James Kelty Director of Operations Everbase Systems, LLC 624 A Street Ashland, OR 97520 [EMAIL PROTECTED] 541.488.0801 - 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: Replication slave repeatedly gets error 1159 from master
Check the list. This question has been asked before many time. You can set net_read_timeout variable to bigger value to avoid this problem. Still no one knows (or answered) impact of net_read_timeout and wait_timeout. which one takes precedence. Nilesh -Original Message- From: Santiago Alba [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 11:35 AM To: Pierre Baridon; David Harper; [EMAIL PROTECTED] Subject: RE: Replication slave repeatedly gets error 1159 from master Yes, I have a cluster installed with 3.23.49 and I have any problem. Now, I am installing a new cluster with 3.23.51 version and it's appearing these problems. Could anybody help us? Thanks in advance. Santiago. - Original Message - From: Pierre Baridon [EMAIL PROTECTED] To: David Harper [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 15, 2002 4:29 PM Subject: Re: Replication slave repeatedly gets error 1159 from master i have the same probem since i ugraded my slave from 3.23.50 to 3.23.51 Pierre - Original Message - From: David Harper [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 15, 2002 1:26 PM Subject: Replication slave repeatedly gets error 1159 from master Description: Every 60 seconds, the replication slave gets an error 1159 from the master server. Thirty seconds later, it reconnects to the master. Then the cycle starts all over again. I have master-connect-retry=30 in the config file. Here is an extract of the replication slave's error log: 020715 12:05:33 Error reading packet from server: (server_errno=1159) 020715 12:06:03 Slave: Failed reading log event, reconnecting to retry, log 'mysql.001' position 73 020715 12:06:03 Slave: reconnected to master 'slave@venus:24641',replication resumed in log 'mysql.001' at position 73 020715 12:06:33 Error reading packet from server: (server_errno=1159) 020715 12:07:03 Slave: Failed reading log event, reconnecting to retry, log 'mysql.001' position 73 020715 12:07:03 Slave: reconnected to master 'slave@venus:24641',replication resumed in log 'mysql.001' at position 73 In between disconnections, replication *appears* to be occurring correctly, but it is rather disturbing that there seems to be some kind of communication problem between the master and slave servers. This problem did not occur in version 3.23.49, by the way. It appeared when we upgraded to 3.23.51. How-To-Repeat: Set up a master/slave replication pair of servers. Fix: Not known. Submitter-Id: submitter ID Originator: David Harper Organization: Wellcome Trust Sanger Institute, Hinxton, Cambridge CB10 1SA, England MySQL support: none Synopsis: Replication slave repeatedly gets error 1159 from master Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.51 (Official MySQL binary) Environment: System: OSF1 mars V5.1 732 alpha Machine: alpha Some paths: /bin/perl /bin/make /usr/local/bin/gmake /usr/local/bin/gcc /bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/alpha-dec-osf5.1/3.0.3/specs Configured with: ../configure Thread model: single gcc version 3.0.3 Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Mar 30 2001 /lib/libc.a - ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Mar 30 2001 /usr/lib/libc.a - ../ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread- safe-client --enable-local-infile --with-prefix=/usr/local/mysql --with-mysq ld-ldflags=-all-static --disable-shared '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared 'CC=cc -pthread' 'CFLAGS=-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' 'CXXFLAGS=-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' 'CXX=cxx -pthread' Perl: This is perl, version 5.005_03 built for alpha-dec_osf - 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
RE: Replication from InnoDB - MyISAM
How does transaction works in this scenario?. Is rollbacked transaction written into bin-log files?. Nilesh -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 1:30 PM To: Philip Molter; [EMAIL PROTECTED] Subject: Re: Replication from InnoDB - MyISAM Philip, - Original Message - From: Philip Molter [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, July 15, 2002 5:55 PM Subject: Replication from InnoDB - MyISAM I have a 3.23.51 server with InnoDB tables. I want to replicate one of the databases over to some 3.23.49 servers with MyISAM tables. The tables do have some auto-increment columns. I expect that only valid data is going to be written to the binlog, so there shouldn't be an issue with invalid data appearing in my MyISAM tables. Can I expect any problems with this setup? MySQL only writes committed transactions to the binlog, and consequently only replicates committed transactions. Fortunately the MySQL replication puts commands SET INSERT_ID = ... to the binlog to replicate inserts to tables with auto-increment columns. Thus small differences in auto-increment algorithms in different tables types do not cause problems in replication. Thus replication InnoDB table - MyISAM table should always work without problems. sql, query, stupid filter (perhaps the filter can be expanded to look for common MySQL words, like 'MyISAM, InnoDB, 3.23.x etc.'). * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] Best regards, Heikki Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Replication from InnoDB - MyISAM
I am sorry. I should have paid more attention to Heikki email. Nilesh -Original Message- From: Philip Molter [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:43 PM To: Nilesh Shah Cc: [EMAIL PROTECTED] Subject: Re: Replication from InnoDB - MyISAM On Mon, Jul 15, 2002 at 02:40:14PM -0400, Nilesh Shah wrote: : How does transaction works in this scenario?. Is rollbacked transaction : written into bin-log files?. To quote Heikki from below: MySQL only writes committed transactions to the binlog, and consequently only replicates committed transactions. : - Original Message - : From: Philip Molter [EMAIL PROTECTED] : Newsgroups: mailing.database.mysql : Sent: Monday, July 15, 2002 5:55 PM : Subject: Replication from InnoDB - MyISAM : : : I have a 3.23.51 server with InnoDB tables. I want to replicate : one of the databases over to some 3.23.49 servers with MyISAM tables. : The tables do have some auto-increment columns. I expect that only : valid data is going to be written to the binlog, so there shouldn't : be an issue with invalid data appearing in my MyISAM tables. Can : I expect any problems with this setup? : : MySQL only writes committed transactions to the binlog, and consequently : only replicates committed transactions. : : Fortunately the MySQL replication puts commands : : SET INSERT_ID = ... : : to the binlog to replicate inserts to tables with auto-increment : columns. : Thus small differences in auto-increment algorithms in different tables : types do not cause problems in replication. : : Thus replication InnoDB table - MyISAM table should always work without : problems. : : sql, query, stupid filter (perhaps the filter can be expanded to : look for common MySQL words, like 'MyISAM, InnoDB, 3.23.x etc.'). : : * Philip Molter : * Texas.net Internet : * http://www.texas.net/ : * [EMAIL PROTECTED] : : Best regards, : : Heikki : Innobase Oy * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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: Goodday
This is funny, but my email regarding replication slave disconnect error in 3.23.51 was bounced back as Spam and asked me to add sql,query in message. Whereas, Spam like this goes unnoticed. Nilesh -Original Message- From: Njamba [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 5:52 AM To: MySql List Subject: Fw: Goodday I wonder who to send this mail to. So I decided to send it to the list may be someone responsible for such will see it. There is someone spreading spam through the MySql List. I received this attached e-mail today If you check correctly it was originally addressed to the list. And that is how I ended up with a copy. Please someone do the necessary to prevent spam being sent through the list. I will highly appreciate if it is announced through the list that something is being done. Kind regards Harrison - Original Message - From: Oluwafunmi Gabriel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 13:08 Subject: Goodday Attn: mysql , My name is Mr. Oluwafunmi G, the manager, credit and foreign bills of Ecobank Plc. I am writing in respect of a foreign customer of my bank with account number 14-255-2004/utb/t who perished in a plane crash [Korean Air Flight 801] with the whole passengers aboard on August 6, 1997. Since the demise of this our customer, I personally has watched with keen interest to see the next of kin but all has proved abortive as no one has come to claim his funds of usd.20.5 m, [twenty million five hundred thousand united states dollars] which has been with my branch for a very long time. On this note, I decided to seek for whom his name shall be used as the next of kin as no one has come up to be the next of kin. And the banking ethics here does not allow such money to stay more than four years, because money will be recalled to the bank treasury as unclaimed after this period. In view of this I got your contact through a trade journal after realizing that your name and country is similar to the deceased. I will give you 25% of the total. Upon the receipt of your response, I will send you by fax or e-mail the application, bank's fax number and the next step to take. I will not fail to bring to your notice that this business is hitch free and that you should not entertain any fear as all modalities for fund transfer can be finalized within five banking days, after you apply to the bank as a relation to the deceased. When you receive this letter. Kindly send me an e-mail signifying Your decision including your private Tel/Fax numbers for quick communication. Respectfully submitted, Oluwafunmi G. - 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 - This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you have received this email in error you may not disclose, copy, distribute or act upon its contents without the authors prior written consent. Please can you notify the system manager at [EMAIL PROTECTED] immediately and delete this email. - Any views or opinions expressed are those of the author and do not necessarily represent those of Somak Travel Limited, Kenya. - This footnote also confirms that this email message has been swept for the presence of computer viruses. No responsibility can be accepted in the event that a virus is contained within it or any attachments. - SOMAK TRAVEL LTD - KENYA NAIROBI, PO BOX 48495. Tel: +(2542) 557832 Fax:+(2542) 535175 MOMBASA, PO BOX 90738. Tel: +(25411)486197 Fax:+(25411)487324 - 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: Replication - Error reading packet from server: (server_errno=1159)
Set variable net_read_timeout to some bigger value. http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html Nilesh Shah -Original Message- From: Mark Hughes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 3:36 AM To: [EMAIL PROTECTED] Subject: Replication - Error reading packet from server: (server_errno=1159) Hi, We updated one of our slave servers to 3.3.51 from 3.23.38 and in common with lots of other posts i've seen we're getting lots of errors where the slave loses the connection to the master: 020710 7:24:05 Error reading packet from server: (server_errno=1159) 020710 7:25:05 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 131306 020710 7:25:05 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 131306 020710 7:26:12 Error reading packet from server: (server_errno=1159) 020710 7:26:12 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 132434 020710 7:26:12 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 132434 020710 7:26:42 Error reading packet from server: (server_errno=1159) 020710 7:27:42 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 132434 020710 7:27:42 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 132434 These are happening every 60 seconds or so. Some info on our architecture System: Linux int04948-2 2.2.19-6.2.16 #1 Wed Mar 13 13:03:05 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS=' -O3' CXX='gcc' CXXFLAGS=' -O3 -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jul 9 16:49 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4105868 Dec 8 2001 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20299228 Dec 8 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Dec 8 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS= -O3' 'CXXFLAGS= -O3 -felide-constructors -fno-exceptions -fno-rtti ' CXX=gcc Perl: This is perl, version 5.005_03 built for i386-linux I couldn't find a solution to this, is it a known problem with 3.3.51 ? Thanks, Mark. - 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 replication
No. You cann't have one slave connected to more than one master. Nilesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 10:30 PM To: [EMAIL PROTECTED] Subject: mysql replication Hi All, I have 3 mysql servers with Red Hat 7.2 as the OS (Mysql-3.23.49). I am naming the 3 PCS as A,B and C. I have a table named files-info in all the 3 mysql servers. My requiremnet is I want two way replication between A to B and A to C. Now I have two way replication between A to B. I want to add Ato C also. I want to do it in the same data base engine...How can I do that... Is it possible for me to run two replication client session in the same PC, I mean one client is accessing one database server and other one is accessing other database server...is that possible...??? Thanks in advance... regds, - 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: verification upon update, help, please
What happens if you put third TIMESTAMP column.?. Will that be updated?. Just curios. Nilesh -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:42 PM To: Paul Tomsic; [EMAIL PROTECTED] Subject: Re: verification upon update, help, please At 12:07 -0400 7/3/02, Paul Tomsic wrote: Does MySQL prevent updates from occurring when the values involved are the same as the database's current state. I don't know if prevent is the word exactly. It doesn't bother to update the row unless you actually change a value. The phenonenon you're observing is that the row-count value means rows actually changed from their current values rather than rows select to be updated. For instance, if I've got a table create table updater( id int not null primary key auto_increment, is_active int not null default 1 }; insert into updater(is_active) values (1); insert into updater(is_active) values (1); update updater set is_active = 1; Would MySQL essentially disregard this update statement b/c the values contained within the table are already 1? Now, I realize that the values wouldn't be altered, but does the dB do pre-checking and see which (if any) rows would be affected by the query, and only run the update against rows that would be changed? There seems to be some reporting that is displayed which indicates that MySQL DOES indeed to pre-checking mysql select * from updater; ++---+ | id | is_active | ++---+ | 1 | 1 | | 2 | 1 | ++---+ 2 rows in set (0.00 sec) mysql update updater set is_active = 1; Query OK, 0 rows affected (0.00 sec) Rows matched: 2 Changed: 0 Warnings: 0 mysql any thoughts? thanks, Paul - 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: er diagramming
PowerDesigner from Sybase is awesome. Nilesh -Original Message- From: Bill Bernat [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 3:25 PM To: [EMAIL PROTECTED] Subject: er diagramming ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL data types or specific MySQL code export. Do any tools? Notepad and vi look like my best physical design tools at this point, which is okay. But I wanted to be sure I wasn't missing anything out there -- along the lines of ERwin but with MySQL support. Thanks. -billb - 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
Multiple Network Interface
We are setting up three MySQL server (on separate machines) with one master and two slave servers. All the machines has two network interface. We want to create Private network between three machines only to route replication traffic. Can MySQL use multiple network interface on machine?. Thanks, Nilesh - 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: Multiple Network Interface
Thanks all -Original Message- From: Joseph Bueno [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 10:56 AM To: Nilesh Shah Cc: [EMAIL PROTECTED] Subject: Re: Multiple Network Interface Nilesh Shah wrote: We are setting up three MySQL server (on separate machines) with one master and two slave servers. All the machines has two network interface. We want to create Private network between three machines only to route replication traffic. Can MySQL use multiple network interface on machine?. Yes. It will use all interfaces by default. You can restrict it to a single interface with 'bind-address' option. Thanks, Nilesh Regards -- Joseph Bueno - 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: mysqld refusing connections while getting sloooow
I think increasing memory and giving more memory to MySQL would help. Nilesh -Original Message- From: Jared Richardson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 1:48 PM To: Stefan Hinz; [EMAIL PROTECTED] Subject: Re: mysqld refusing connections while getting slw We've seen very similar behavior when there are very long SQL queries being run that are disk intensive.. generally speaking, something is having to traverse the table (or a temp table) line by line. If he has any logging capability, see long each SQL query is taking to return to his app then clean up the bad ones. Also, look at faster disks... 7,200 rpm, bigger internal caches (some disks have 8 meg!), small raids are inexpensive, and you can put different tables on different physical disks to speed access. Oh yeah, with MySql, you can put all the temp tables on a different disk. We found this to make an amazing difference! Also, a P4 or an Athlon system is a great deal faster than your friend's system... the faster bus speeds on those architectures will again make a huge difference. We buy dual Athlons with a gig of ram for about 2 thousand dollars. - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 11, 2002 12:30 PM Subject: mysqld refusing connections while getting slw | Dear list, | | a friend of mine asked for assistance on the following problem (which I | cannot solve myself): | | He has a mysqld 3.23.38 running on Linux, with 2 cpus (400 MHz celeron) | and 512 MB ram. mysqld runs as a production server, with some | applications running about 80 queries per second. There are about 20 | concurrent connections per hour. He uses myisam tables, no innodb or | something. | | Quite often he finds that new clients (apps) cannot connect to mysqld, | the connection is refused. My friend tried to connect from localhost to | mysqld once when this happened, trying to log in as admin. Even for him, | the connection was refused by mysqld (although mysqld is supposed to | keep one connection open for the admin, in any case). To be correct | about this, mysqld didn't respond at all, for 5 minutes. | | When connections for new users (apps) are blocked by mysqld, he finds | that response times will slow down by factor 20, for users that are | connected at this time. Also, he finds that Linux will kill mysqld | *sometimes* (the server is re-started automatically). | | I did not find anything unusual using mysqladmin extended-status or | mysqladmin variables. In my.cnf however, I found something strange: | | [mysqld] | ... | skip-locking | set-variable = key_buffer=256M | set-variable = max_allowed_packet=1M | set-variable = table_cache=256 | set-variable = sort_buffer=1M | set-variable = record_buffer=1M | set-variable = myisam_sort_buffer_size=64M | set-variable = thread_cache=8 | # Try number of CPU's*2 for thread_concurrency | set-variable = thread_concurrency=8 | log-bin | server-id = 1 | | If I count these buffers and caches, this will add up to 320 MB plus | the table cache. Could this be the cause of the problem, when my friend | only has 512 MB of RAM on the machine? | | Any help is greatly appreciated. | | Regards, | -- | Stefan Hinz [EMAIL PROTECTED] | Geschäftsführer / CEO iConnect GmbH http://iConnect.de | Heesestr. 6, 12169 Berlin (Germany) | Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 | | | - | 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
MySQL DBA wanted
Sorry for Job posting. Looking at the popularity of MySQL it would be better if there is separate mailing list for Job Offered/Wanted for MySQL. We are SIP based VoIP company located in Edision,NJ,USA looking for MySQL DBA with 1-2 years of solid MySQL experience. Experience with InnoDB is must. Candidate should also have solid experience in Linux and/or Solaris. Candidate should be available for face-to-face interview. Candidate will be responsible initially for three database servers. It can grow up to 10 database servers. Please send your resumes to [EMAIL PROTECTED] mention MySQL DBA in subject. For company detail visit http://www.vonage.com . Thanks, Nilesh - 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: 45 seconds
Try using LIKE instead of regexp and create index on HOST_NAME if not present. Nilesh -Original Message- From: Chris Knipe [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:24 PM To: Elsad YUSIFLI; [EMAIL PROTECTED] Subject: Re: 45 seconds I have multiple tables on a 166MMX with 64MB ram, all containing more than 250,000 records each Mine takes less than 5 seconds I think there's something wrong at your side :-) Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: Elsad YUSIFLI [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 4:10 PM Subject: 45 seconds i have a table and 51000 records in it. it has got an index on HOST_NAME field. next query lasts 45 seconds to execute... is it normal ? server is PIII 500 double cpu SELECT b.ip as ip, b.country , b.hostname , a.HOST_NAME as host, COUNT(a.HOST_NAME) as number FROM new_raw_log as a, dns as b WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%') AND a.GID=44 AND a.SID=12 GROUP BY a.HOST_NAME ORDER BY number DESC LIMIT 0,20 - 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