Re: your chance

Same here On Mon, 2006-06-26 at 06:46 -0300, João Cândido de Souza Neto wrote: I read that message and had no feelings. [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] Please, read and let me know what do you feel -- MySQL General Mailing List For list archives:

Re: Why would a SELECT COUNT(*)... WHERE... take way way longer than SELECT COUNT(primary_key)... WHERE... ?

Innodb tables do not cache the rowcount like MyISAM tables do, so mysql has to walk the entire table to get a count. If you have a unique index, it should be able to scan that instead, which will be faster. On Sat, 2006-06-17 at 20:32 +0530, Alex Arul wrote: count(*) is slow in innodb due to

Re: How to synchronize two databases

Check this out http://dev.mysql.com/tech-resources/articles/syncman/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Social Network, linking members

How about something like this Users table user_id user_name user_password user_whatever and then Relation table rel_id user_id friend_id and then selecting from relations table On Fri, 2006-04-07 at 14:47 -0700, Martin Gallagher

ORDER BY two clauses

guys, I have little question, but to make it more clear I wrote it with example of what i want on this pdf, http://www.easyhttp.net/files/query.pdf please advise. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

hostname

hi i have changed my host name now I got this when I tried to restart mysql mysql 6382 0.0 1.5 31340 3512 ?SOct25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid --skip-locking what to do ? --