[Replication] Problem connecting to master
I have a strange problem setting up replication. I followed each step of setting up replication in the mysqld documentation (http://dev.mysql.com/doc/mysql/en/replication-howto.html). But there are some error messages on the salve: 050828 13:22:58 [ERROR] Slave I/O thread: error connecting to master '[EMAIL PROTECTED]:3306': Error: 'Can't connect to MySQL server on 'alturo.vlugnet.org' (13)' errno: 2003 retry-time: 60 retries: 86400 When I try to connect to the master using same hostname, same user, same password with the mysql client it works without problems. I tried to drag the problem with ethereal. It seems that the slave doesn't even try to connect to the master. There are not even connection attempts between master and slave on port 3306. Also have a look at http://forums.mysql.com/read.php?26,36766 it seems that he has the same problem. As slave I'm using mysql version 4.1.12 on Fedora Core 4. Master is 3.23.58 on Fedora Core 2. Any ideas? Regards Jan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question with rows count
Hi, I ran those two queries : mysql select count(id) from forums_data WHERE forums_data.group_id=1 AND forums_data.state=1; +---+ | count(id) | +---+ | 2385 | +---+ 1 row in set (0.11 sec) mysql explain select count(id) from forums_data WHERE forums_data.group_id=1 AND forums_data.state=1; ++-+-+--+---+---+-+-+--+---+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+-+--+---+---+-+-+--+---+ | 1 | SIMPLE | forums_data | ref | forum_id3 | forum_id3 | 2 | const,const | 2265 | | ++-+-+--+---+---+-+-+--+---+ 1 row in set (0.00 sec) CREATE TABLE `forums_data` ( `id` int(10) NOT NULL auto_increment, `group_id` tinyint(3) unsigned NOT NULL default '1', `subject` varchar(255) NOT NULL default '', `body` text, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `state` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), KEY `forum_id3` (`state`,`group_id`) ); I don't understand why the number rows analyzed returned by EXPLAIN does not match the count(*) of the query. I can understand when it's higher, but lower ? -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question with rows count
Pooly wrote: Hi, I ran those two queries : mysql select count(id) from forums_data WHERE forums_data.group_id=1 AND forums_data.state=1; +---+ | count(id) | +---+ | 2385 | +---+ 1 row in set (0.11 sec) mysql explain select count(id) from forums_data WHERE forums_data.group_id=1 AND forums_data.state=1; ++-+-+--+---+---+-+-+--+---+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+-+--+---+---+-+-+--+---+ | 1 | SIMPLE | forums_data | ref | forum_id3 | forum_id3 | 2 | const,const | 2265 | | ++-+-+--+---+---+-+-+--+---+ 1 row in set (0.00 sec) CREATE TABLE `forums_data` ( `id` int(10) NOT NULL auto_increment, `group_id` tinyint(3) unsigned NOT NULL default '1', `subject` varchar(255) NOT NULL default '', `body` text, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `state` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), KEY `forum_id3` (`state`,`group_id`) ); I don't understand why the number rows analyzed returned by EXPLAIN does not match the count(*) of the query. I can understand when it's higher, but lower ? I'm not sure why you think higher vs. lower makes a difference. To quote from the manual, The rows column indicates the number of rows MySQL believes it must examine to execute the query http://dev.mysql.com/doc/mysql/en/explain.html. Note the word believes. Your table stats may be out of sync. If this is a MyISAM table, you probably just need to run ANALYZE TABLE forums_data; then try again. See the manual for details http://dev.mysql.com/doc/mysql/en/analyze-table.html. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question with rows count
2005/8/28, Michael Stassen [EMAIL PROTECTED]: Pooly wrote: Hi, I ran those two queries : mysql select count(id) from forums_data WHERE forums_data.group_id=1 AND forums_data.state=1; +---+ | count(id) | +---+ | 2385 | +---+ 1 row in set (0.11 sec) mysql explain select count(id) from forums_data WHERE forums_data.group_id=1 AND forums_data.state=1; ++-+-+--+---+---+-+-+--+---+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+-+--+---+---+-+-+--+---+ | 1 | SIMPLE | forums_data | ref | forum_id3 | forum_id3 | 2 | const,const | 2265 | | ++-+-+--+---+---+-+-+--+---+ 1 row in set (0.00 sec) CREATE TABLE `forums_data` ( `id` int(10) NOT NULL auto_increment, `group_id` tinyint(3) unsigned NOT NULL default '1', `subject` varchar(255) NOT NULL default '', `body` text, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `state` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`), KEY `forum_id3` (`state`,`group_id`) ); I don't understand why the number rows analyzed returned by EXPLAIN does not match the count(*) of the query. I can understand when it's higher, but lower ? I'm not sure why you think higher vs. lower makes a difference. To quote from the manual, The rows column indicates the number of rows MySQL believes it must examine to execute the query http://dev.mysql.com/doc/mysql/en/explain.html. Note the word believes. Your table stats may be out of sync. If this is a MyISAM table, you probably just need to run ANALYZE TABLE forums_data; I ran OPTIMIZE TABLE forums_data juste before performing those queries. So, the rows returned int the EXPLAIN command juste indicate a rough count of how many rows MySQL think it will have to examine for running the query ? Ok, it's a bit clearer. -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Key Buffer Size
Greetings, In my database, all the tables use innodb engine. Since I don't use MYISAM, Is it safe to make the key_buffer size to 8 MB? To give you an idea of my database, I use Linux box with 6GB ram, MySQL version 4.0.15. Most of my configuration is in lines with my-huge.cnf. Thanks in advance for your help. Cheers Manoj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Key Buffer Size
Yeah, it's safe. -- Alexey Polyakov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
why is this not an error?
mysql select count(*) paths; +---+ | paths | +---+ | 0 | +---+ 1 row in set (0.00 sec) mysql select count(*) files; +---+ | files | +---+ | 0 | +---+ 1 row in set (0.00 sec) -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: why is this not an error?
Because you're asking how many rows are in those tables and it has a reply? Jason Pyeron wrote: mysql select count(*) paths; +---+ | paths | +---+ | 0 | +---+ 1 row in set (0.00 sec) mysql select count(*) files; +---+ | files | +---+ | 0 | +---+ 1 row in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: why is this not an error?
it is missing the FROM mysql select count(*) from paths; +--+ | count(*) | +--+ | 148109 | +--+ 1 row in set (0.21 sec) mysql select count(*) from files; +--+ | count(*) | +--+ | 133937 | +--+ 1 row in set (0.35 sec) On Sun, 28 Aug 2005, Chris wrote: Because you're asking how many rows are in those tables and it has a reply? Jason Pyeron wrote: mysql select count(*) paths; +---+ | paths | +---+ | 0 | +---+ 1 row in set (0.00 sec) mysql select count(*) files; +---+ | files | +---+ | 0 | +---+ 1 row in set (0.00 sec) -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]