Re: why is this not an error?

2005-08-28 Thread Dan Nelson
In the last episode (Aug 29), Jason Pyeron said: > Why is this not an error? > > mysql> select count(*) paths; > +---+ > | paths | > +---+ > | 0 | > +---+ > 1 row in set (0.00 sec) Why should it be? You've simply omitted the optional AS keyword in a standard no-table SELECT quer

Re: why is this not an error?

2005-08-28 Thread Jason Pyeron
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, Chr

Re: why is this not an error?

2005-08-28 Thread Chris
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

why is this not an error?

2005-08-28 Thread Jason Pyeron
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) -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -

Re: Key Buffer Size

2005-08-28 Thread Alexey Polyakov
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]

Key Buffer Size

2005-08-28 Thread Manoj
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.

Re: question with rows count

2005-08-28 Thread Pooly
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 | > > +--

Re: question with rows count

2005-08-28 Thread Michael Stassen
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_

question with rows count

2005-08-28 Thread Pooly
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

[Replication] Problem connecting to master

2005-08-28 Thread Jan Roehrich
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 mas