RE: ReiserFS vs Ext3
What about XFS? I'm considering using XFS instead of ext3 since it seems to be said that XFS is more stable and efficient than any other linux's journaling fs in the environment of large and not-so-many files. If it is true, I guess that XFS would be the best choice with InnoDB. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] SayClub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: David Brodbeck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 11:10 PM To: Nicholas Gaugler Cc: [EMAIL PROTECTED] Subject: RE: ReiserFS vs Ext3 -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] I would E-mail the reiserfs list and ask for whether ReiserFS would be better for a MySQL-only partition than ext3 and see what answers you get. In the worst case, you'll have some extreme resierfs is always better responses that don't help you decide. In the best (and what I think will happen), someone will tell you the differences in CPU usage or fast file access speeds or some such value that will mean something, or even that it is not actually going to make a difference. If Nicholas does this, I hope he'll report back here with what he finds out. I'm facing the same choice very soon, for a database that will eventually have millions of entries (but each individual entry very small.) I'm trying to decide whether to go with reiserfs or ext3. ext3's my current favorite, but only because it's more of a known, stable quantity. - 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
resize InnoDB's log file
Currently I have three InnoDB log files, whose size is 256MB and main memory is 2GB. Since I use 1GB of InnoDB buffer pool, I think log files'd better get bigger to some extent; possibly 1GB. You know, only changing the value in my.cnf cause mysqld not to start due to error. I'm wondering if deleting log files after mysqld is stopped and starting mysqld is safe. I tried this and got some look-so-serious error(or warning?) messages like following: 030121 10:18:49 mysqld ended 030121 10:27:07 mysqld started 030121 10:27:11 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 1024 MB InnoDB: Database physically writes the file full: wait... 030121 10:28:05 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 1024 MB InnoDB: Database physically writes the file full: wait... 030121 10:29:02 InnoDB: Log file ./ib_logfile2 did not exist: new to be created InnoDB: Setting log file ./ib_logfile2 size to 1024 MB InnoDB: Database physically writes the file full: wait... 030121 10:29:58 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 3205932556 InnoDB: Doing recovery: scanned up to log sequence number 0 3205932556 InnoDB: Last MySQL binlog file position 0 13846, file name ./lacrimosa- bin.003 030121 10:29:58 InnoDB: Flushing modified pages from the buffer pool... 030121 10:29:59 InnoDB: Started /austin/local/mysql/bin/mysqld: ready for connections query. sql -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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
What does this mean? : Warning: thr_alarm queue is full
query. I happened to find out that the lots of following error messages are stored error log file: Warning: thr_alarm queue is full What's this? Is it serious problem? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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: Optimize InnoDB table...
What I'd like to do is not to alter table type but to optimize table. Somewhere I read that to optimize the structure of innodb type table, I should alter table type two times: to MyISAM and back to InnoDB. Or dump load data. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 11:50 AM To: Á¤ Çϳç; [EMAIL PROTECTED] Subject: Re: Optimize InnoDB table... At 15:13 +0900 12/26/02, Chung Ha-nyung wrote: I've heard that I should periodically alter innodb table to MyISAM and back to InnoDB to optimize table structure. I guess only dropping index and recreating it is enough, but should I change table type? Dropping an index doesn't change a table's type. You can change the type like this: ALTER TABLE t TYPE = MyISAM; ALTER TABLE t TYPE = InnoDB; query. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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
Optimize InnoDB table...
I've heard that I should periodically alter innodb table to MyISAM and back to InnoDB to optimize table structure. I guess only dropping index and recreating it is enough, but should I change table type? query. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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: Two-Way Replication
MySQL does not provide conflict resolution mechanism yet. So, although two-way replication is theoretically possible, it may cause serious problems, e.g. data inconsistency between two servers. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Lou Scalpati [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 6:36 AM To: [EMAIL PROTECTED] Subject: Two-Way Replication I am new to this list and have not been able to find an answer in the searchable archive, So I am sorry if this question has been asked before. The documentation (section 4.10.7) mentions 2 way replication but does not give any information about how to set it up. I have searched the documentation and the site. Any pointers for more information would be great. MySql Version 4.05a Thanks Lou Sql query - so it passes through the spam filter. - 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: Can a big transaction cause the error in max_allowed_packet?
Thanks for your rapid reply. :) I'm using MySQL 4.0.5a binary from MySQL AB. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 7:48 PM To: [EMAIL PROTECTED] Subject: Re: Can a big transaction cause the error in max_allowed_packet? Ha-nyung, - Original Message - From: Chung Ha-nyung [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, November 29, 2002 8:25 AM Subject: Can a big transaction cause the error in max_allowed_packet? My table structure is very simple and does not use big column like text nor blub at all. But when I load several million rows into master server using mysqlimport, on slave I got the error like 021129 13:24:40 Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236) 021129 13:24:40 Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log I have two questions. First, mysqlimport does not commit until the entire data are imported? it uses LOAD DATA INFILE, which does not COMMIT before the data has been imported. Second, If the answer to the first question is Yes, it can cause the above error? I guess yes. This is the 3rd similar bug report associated with big imports. I will forward this to the replication developer of MySQL AB. What is your MySQL version? :query -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql crashed
mysql 4.0.5a binary crashed with following error messages. What's the problem? :( 021128 11:06:23 Slave I/O thread: connected to master 'austin@atis1:3306', replication started in log 'FIRST' at position 4 021128 17:35:52 Slave: received 0 length packet from server, apparent master shutdown: 021128 17:35:52 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'atis1-bin.036' position 754 021128 17:35:52 Slave I/O thread: error reconnecting to master 'austin@atis1:3306': Error: 'Can't connect to MySQL server on 'atis1' (111)' errno: 2003 retry-time: 60 retries: 86400 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 against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=268431360 read_buffer_size=1044480 sort_buffer_size=1048568 max_used_connections=1 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 466539 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x86efad0 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=0xbfe3f2d8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806eedb 0x8268018 0x80ad5a5 0x80ae086 0x80e234a 0x80e2e4a 0x82657cc New value of fp=(nil) failed sanity check, terminating stack trace! 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 (nil) is invalid pointer thd-thread_id=4 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 4 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: 2 -- Chung Ha-nyung alita@[neowiz.com|kldp.org] SayClub http://www.sayclub.com NeoWiz http://www.neowiz.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
Can a big transaction cause the error in max_allowed_packet?
My table structure is very simple and does not use big column like text nor blub at all. But when I load several million rows into master server using mysqlimport, on slave I got the error like 021129 13:24:40 Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236) 021129 13:24:40 Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log I have two questions. First, mysqlimport does not commit until the entire data are imported? Second, If the answer to the first question is Yes, it can cause the above error? :query -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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
Building mysql w/ Intel's C++ compiler...
Anyone have tried to build mysql with intel's c++ compiler? Does it build stable binaries and faster than the one built w/ gcc? query -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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: delete where column = null
You should use IS NULL or IS NOT NULL query. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] SayClub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 1:45 AM To: [EMAIL PROTECTED] Subject: delete where column = null Hi, I'm trying to delete from a table where col = null, but it doesn't seem to work. I don't see anything in the manual that says that = can't be used in the where clause of a delete statment, but: mysql select * from t; ++--+ | id | num | ++--+ | 1 | NULL | | 1 | NULL | ++--+ 4 rows in set (0.00 sec) mysql delete from t where id = 1 and num = null; Query OK, 0 rows affected (0.00 sec) mysql select * from t where id = 1 and num = null; ++--+ | id | num | ++--+ | 1 | NULL | | 1 | NULL | ++--+ 2 rows in set (0.00 sec) This behavior seems very bizarre and counter-intuitive to me, but it's such an obvious bug that I'm afraid it must be a feature and not a bug. Can anyone help/explain? Using is null in the where clause works, of course, but would be relatively cumbersome to use. Db is 3.23.53-max-nt Thanks, -David p.s. in case it's relevant, there is a unique index on (id,num): create table t ( id integer not null, num integer, unique index id_num_idx(id,num) ); - 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: relay log keeps growing. ;(
I apologize to annonying the mailing list with repeated questions. :( I'd found the variable, max_binlog_size as Jeremy said, and all seem to go well. ;) Thanks. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 2:35 AM To: Chung Ha-nyung Cc: [EMAIL PROTECTED] Subject: Re: relay log keeps growing. ;( On Fri, Nov 15, 2002 at 05:55:07PM +0900, Chung Ha-nyung wrote: Dear, I'm so sorry that nobody didn't answer for my question, which asked about the condition relay log files are deleted in replication slave server. Anyway. Although somebody said that the files will be deleted automatically, it seems NOT. It keeps growing over several hundreds MB and are likely to eat up all spaces in the partition. I think there's someone who solves this problem - if it's really a problem - and I'd like to know how. Maybe your max_binlog_size is set too high? Try setting it to a lower value. That will force MySQL to cycle it sooner. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 104 days, processed 2,259,206,656 queries (250/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
relay log keeps growing. ;(
Dear, I'm so sorry that nobody didn't answer for my question, which asked about the condition relay log files are deleted in replication slave server. Anyway. Although somebody said that the files will be deleted automatically, it seems NOT. It keeps growing over several hundreds MB and are likely to eat up all spaces in the partition. I think there's someone who solves this problem - if it's really a problem - and I'd like to know how. Thanks. query. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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
Where can I get innodb monitoring tools?
innodb manual (http://www.innodb.com/ibman.html) mentions about innodb monitoring tools, e.g. innodb_tablespace_monitor. But they don't seem to be included in mysql 4.0.4. Should I buy them or can get somewhere else, like innodb homepage? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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
Bug? mysql 4.0.4 wouldn't look for my.cnf in the right location.
I compiled mysql 4.0.4 with option --prefix=/local/mysql -- datadir=/mnt/data but it is likely that mysql still look for my.cnf file in $prefix/var directory not in /mnt/data Is it a bug? sql, query :( -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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: What is relay-bin log?
You said that old relay logs are automatically deleted. But on what condition? log file size? time? or anything else? I'd asked about when the relay logs are deleted but got no answers, so I'm asking again. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Michael Widenius [mailto:monty;mysql.com] Sent: Monday, October 21, 2002 9:25 PM To: Á¤ Çϳç Cc: 'Victoria Reznichenko'; [EMAIL PROTECTED] Subject: RE: What is relay-bin log? Hi! Chung == Chung Ha-nyung [EMAIL PROTECTED] writes: Chung It is seems that RESET SLAVE query sholud not be done while Chung replication is working. Slave forget its replication position and cannot Chung continue replication since it tries to do the queries already executed. Chung Do I need to do SLAVE STOP before RESET SLAVE? Or any Chung other means to delete replication logs during replication? Which log files is it that you want to delete ? (Please give an example for this) If you have a problem that old relay logs are not deleted, try to upgrade to MySQL 4.0.4 ; We recently fixed a bug in this code. If you want to delete all old binary log files, then the command is RESET MASTER. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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
What if binary log's suffix number exceeds 999?
Dear, By default, binary log file uses 3-digit number suffix as its counter. Then, without reseting master logs suffix number may reach 999. If so, what happens? next suffix number is 1000 or 001? Otherwise error occurres? sql. query. :( Regards, -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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: What is relay-bin log?
It is seems that RESET SLAVE query sholud not be done while replication is working. Slave forget its replication position and cannot continue replication since it tries to do the queries already executed. Do I need to do SLAVE STOP before RESET SLAVE? Or any other means to delete replication logs during replication? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Chung Ha-nyung [mailto:alita;neowiz.com] Sent: Monday, October 21, 2002 2:22 PM To: 'Victoria Reznichenko'; [EMAIL PROTECTED] Subject: RE: What is relay-bin log? If all works correctly, can I delete replication logs by RESET SLAVE safely? I'd like to configure two servers with two-master scheme, each is the master of another. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Friday, October 18, 2002 8:01 PM To: [EMAIL PROTECTED] Subject: re: What is relay-bin log? Chung, Thursday, October 17, 2002, 9:48:15 AM, you wrote: CHn At the slave server of replication there are log files like CHn environment hostname-relay-bin.xxx. Yes, these logs are used for replication: http://www.mysql.com/doc/en/Replication_SQL.html CHn For what these logs and how can I know which one I can delete safely? RESET SLAVE; -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: What is relay-bin log?
Well... Then when is the time for replication logs to be deleted? Can I change the conditions for it? I'm not able to find out related section in the official manual. No mention about auto deletion, either. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Michael Widenius [mailto:monty;mysql.com] Sent: Monday, October 21, 2002 9:22 PM To: Á¤ Çϳç Cc: 'Victoria Reznichenko'; [EMAIL PROTECTED] Subject: RE: What is relay-bin log? Hi! Chung == Chung Ha-nyung [EMAIL PROTECTED] writes: Chung If all works correctly, can I delete replication logs by RESET SLAVE Chung safely? Chung I'd like to configure two servers with two-master scheme, each is the Chung master of Chung another. relay logs should automaticly be deleted and you should never have to do RESET SLAVE to delete them. RESET SLAVE should only be used when you want the slave to not be a part of the replication anymore. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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: What is relay-bin log?
If all works correctly, can I delete replication logs by RESET SLAVE safely? I'd like to configure two servers with two-master scheme, each is the master of another. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Friday, October 18, 2002 8:01 PM To: [EMAIL PROTECTED] Subject: re: What is relay-bin log? Chung, Thursday, October 17, 2002, 9:48:15 AM, you wrote: CHn At the slave server of replication there are log files like CHn environment hostname-relay-bin.xxx. Yes, these logs are used for replication: http://www.mysql.com/doc/en/Replication_SQL.html CHn For what these logs and how can I know which one I can delete safely? RESET SLAVE; -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 user permission when using raw device instead datafile
Dear After I had mysql use raw device with innodb instead datafile, I started mysql and got an error like following; 021018 14:11:18 mysqld started 021018 14:11:19 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name /dev/rd/c0d0p3 InnoDB: Cannot continue operation. 021018 14:11:19 mysqld ended mysql and all other files' owner is root and I gave --user=mysql option to mysql. But after omitting the above option, the same error occurred again and only using --user=root option seems to solve this problem. Why mysql would not run in the root permission even thoguh it's owner is root? Or is there any other problem replating to using raw device? Can I NOT run mysql as mysql user permission not root? Thanks -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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: loggin all calls made to mysql from php
Use --log-slow-queries[=filename] option. It will log all queries which take more than long_query_time Default value of it is 10 sec and you can ascertain it by show variable like 'long_query_time' query and set in my.cnf as long_query_time = value I think you'd better refer to the MySQL's manual; http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database _Administration.html#Log_Files -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Petre Agenbag [mailto:internet;boesmanland.com] Sent: Thursday, October 17, 2002 7:27 PM To: Á¤ Çϳç Cc: [EMAIL PROTECTED] Subject: RE: loggin all calls made to mysql from php Thanks, I did it and it works. I just would like to know one more thing. You mention a slow log option, how do invoke that type specifically? I restarted mysql with safe_mysqld --log and it created a myserver.log file in the data directory, but it seems to log ALL queries and is growing pretty fast, so the slow option seems a better bet, as I *think* that the slow queries would be the ones most likely to cause the problems anyway? So do I do safe_mysqld --log-slow or how? Thanks On Thu, 2002-10-17 at 09:51, Chung Ha-nyung wrote: With --log[=filename] option to mysqld_safe, you can specify the path and name of log file. You may put the line like this to my.cnf file log = filename If absoulte path is not given, the path is considered one relative to $data directory, in my case /usr/local/mysql/var and filename is not given, `hostname-s`-slow.log will be used. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Petre Agenbag [mailto:internet;boesmanland.com] Sent: Thursday, October 17, 2002 4:39 PM To: Á¤ Çϳç Cc: [EMAIL PROTECTED] Subject: RE: loggin all calls made to mysql from php Hi Thanks for the prompt reply. Can you please tell me where the logfile will be located if I start it with the --log option? Will syslogd take over the function of the logging, ie, do the log rotation etc. and if possible, could you give me an example of how the log would look? Sorry for asking all these questions, I just want to make sure that it is what I'm looking for, as I will need to stop the mysql server to do this... Thanks On Thu, 2002-10-17 at 09:21, Chung Ha-nyung wrote: Use --log option when starting mysqld_safe(or safe_mysqld) -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Petre Agenbag [mailto:internet;boesmanland.com] Sent: Thursday, October 17, 2002 4:05 PM To: [EMAIL PROTECTED] Subject: loggin all calls made to mysql from php HI I posted this question on PHP list as well. I would like to be able to log all mysql queries made from php scripts. I have had a couple of strange mysql lockups on my RedHat server, where mysqld process won't even be killed, and since no user works with mysql except through PHP, the normal mysql logs doesn't seem to be very helpful. I have multiple virtual hosts on the server, all allowing .php and most having mysql db's, so I want to be able to see what scripts are causing the problem. Is this the right way to go about finding the problem? Are there any other ideas or methods in use by other admins out there to determine if there are poorly coded scripts/queries run on the server? Thanks - 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
What is relay-bin log?
At the slave server of replication there are log files like environment hostname-relay-bin.xxx. For what these logs and how can I know which one I can delete safely? p.s. sql, query : used to bypass spam filter. :( -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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
SHOW SLAVE HOSTS print master host also.
I set up two-way replication with two servers, A and B. Since all queries go to only one server, it seems not to matter. Anyway. When A starts it registers itself to B, and vice versa. I thought query SHOW SLAVE HOSTS to A should shows only about B and B should do about A, but both show the same result as following. +---+--+--+---+---+ | Server_id | Host | Port | Rpl_recovery_rank | Master_id | +---+--+--+---+---+ | 1 | B | 3306 | 0 | 2 | | 2 | A | 3306 | 0 | 1 | +---+--+--+---+---+ Is it right? Why does the result show both master and slave? Thanks. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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: loggin all calls made to mysql from php
Use --log option when starting mysqld_safe(or safe_mysqld) -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Petre Agenbag [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 4:05 PM To: [EMAIL PROTECTED] Subject: loggin all calls made to mysql from php HI I posted this question on PHP list as well. I would like to be able to log all mysql queries made from php scripts. I have had a couple of strange mysql lockups on my RedHat server, where mysqld process won't even be killed, and since no user works with mysql except through PHP, the normal mysql logs doesn't seem to be very helpful. I have multiple virtual hosts on the server, all allowing .php and most having mysql db's, so I want to be able to see what scripts are causing the problem. Is this the right way to go about finding the problem? Are there any other ideas or methods in use by other admins out there to determine if there are poorly coded scripts/queries run on the server? Thanks - 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: loggin all calls made to mysql from php
With --log[=filename] option to mysqld_safe, you can specify the path and name of log file. You may put the line like this to my.cnf file log = filename If absoulte path is not given, the path is considered one relative to $data directory, in my case /usr/local/mysql/var and filename is not given, `hostname-s`-slow.log will be used. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Petre Agenbag [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 4:39 PM To: Á¤ Çϳç Cc: [EMAIL PROTECTED] Subject: RE: loggin all calls made to mysql from php Hi Thanks for the prompt reply. Can you please tell me where the logfile will be located if I start it with the --log option? Will syslogd take over the function of the logging, ie, do the log rotation etc. and if possible, could you give me an example of how the log would look? Sorry for asking all these questions, I just want to make sure that it is what I'm looking for, as I will need to stop the mysql server to do this... Thanks On Thu, 2002-10-17 at 09:21, Chung Ha-nyung wrote: Use --log option when starting mysqld_safe(or safe_mysqld) -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Petre Agenbag [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 4:05 PM To: [EMAIL PROTECTED] Subject: loggin all calls made to mysql from php HI I posted this question on PHP list as well. I would like to be able to log all mysql queries made from php scripts. I have had a couple of strange mysql lockups on my RedHat server, where mysqld process won't even be killed, and since no user works with mysql except through PHP, the normal mysql logs doesn't seem to be very helpful. I have multiple virtual hosts on the server, all allowing .php and most having mysql db's, so I want to be able to see what scripts are causing the problem. Is this the right way to go about finding the problem? Are there any other ideas or methods in use by other admins out there to determine if there are poorly coded scripts/queries run on the server? Thanks - 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: What is the best suited file system for MySQL w/ InnoDB?
I've considered raw filesystem, but it seems a bit difficult, or even impossible, to copy db file to other servers, especially when making replication slave servers. Any not bad means to backup MySQL db using raw filesystem? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Harald Fuchs Sent: Tuesday, October 15, 2002 7:03 PM To: [EMAIL PROTECTED] Subject: Re: What is the best suited file system for MySQL w/ InnoDB? In article [EMAIL PROTECTED], Chung Ha-nyung [EMAIL PROTECTED] writes: Among ext3, reiserfs, ext2, and xfs, which one is the best for MySQL w/ InnoDB? Since partition size is as small(!) as 60GB, I think that ext2 could be plausible choice. But any other journaling filesystem can outperform ext2 in using MySQL? I'd say you'll get the best performance when using no filesystem or buffer cache at all. Make your 60G partition a raw device and let InnoDB use this raw device as its tablespace. - 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
Where's safe_mysqld?
Dear, I installed MySQL 4.0.4 from source tarball and I found that safe_mysqld is mentioned here and there in the manual but I can't where it, safe_mysqld, is located. All that I found with `find . -name *safe*' command is mysqld_safe script. Thanks. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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
What is the best suited file system for MySQL w/ InnoDB?
Among ext3, reiserfs, ext2, and xfs, which one is the best for MySQL w/ InnoDB? Since partition size is as small(!) as 60GB, I think that ext2 could be plausible choice. But any other journaling filesystem can outperform ext2 in using MySQL? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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