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 Sayclub <http://www.sayclub.com> NeoWiz <http://

mysql crashed

y 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 --

Can a big transaction cause the error in max_allowed_packet?

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 Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> -

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 Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > -Original Message- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] > Sent: Friday, Nove

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 Sayclub <http://www.sayclub.com> NeoWiz <http://www.n

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 Sayclub <http://www.sayclub.com> N

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 Sayclub <http://www.sayclub.com> NeoWiz <http://

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 Sayclub <http://www.sayclub.

resize InnoDB's log file

g 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 Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> --

RE: ReiserFS vs Ext3

-- Chung Ha-nyung 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 PROTE

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 Sayclub <h

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 Sayclub <http://www.sayclub.com&

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. Th

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 Sayclub <http://www.sayclub.com> NeoWiz

SHOW SLAVE HOSTS print master host also.

| 3306 | 0 | 1 | +---+--+--+---+---+ Is it right? Why does the result show both master and slave? Thanks. -- Chung Ha-nyung Sayclub <http://www.sayclub.com> NeoWiz <ht

RE: loggin all calls made to mysql from php

Use --log option when starting mysqld_safe(or safe_mysqld) -- Chung Ha-nyung 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 &

RE: loggin all calls made to mysql from php

not given, `hostname-s`-slow.log will be used. -- Chung Ha-nyung 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: Á¤ Çϳ

mysql user permission when using raw device instead datafile

mysql user permission not root? Thanks -- Chung Ha-nyung Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

RE: loggin all calls made to mysql from php

uot; 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 Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > -Original Message-

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 Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > ---

RE: What is relay-bin log?

? Or any other means to delete replication logs during replication? -- Chung Ha-nyung 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 > T

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 Sayclub <http://www.sayclub.com> NeoWiz <http://

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 Sayclub <h

Questions about logfile's suffix numbering.

s not return to 000? I'm making some perl script to handle, e.g. purge, move, etc, log files and cannot be sure that one log file is always prior to the one with larger suffix number. I'm using MySQL 4.0.4beta. Best Regards. -- Chung Ha-nyung Sayclub <http://www.sayclub.co

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 Sayclub <http://www.sayclub.com> NeoWiz <ht

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 Sayclub <http://www.sayclub.com> NeoWiz <http://www.n

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 Sayclub <http://www.say

relay log keeps growing. ;(

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 Sayclub <http://www.sayclub.com>

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 Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > -Original Message

RE: delete where column <=> null

You should use "IS NULL" or "IS NOT NULL" query. -- Chung Ha-nyung SayClub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, Novembe