Re: Consolidation suggestions - some LAMP servers

2008-12-10 Thread Thomas Pundt
Hi Götz, On Dienstag, 9. Dezember 2008, Götz Reinicke wrote: | My question is, what do you think about using e.g. one server as | webserver, the other as mysql server ... so the database traffic will go | across the network. So that I have only one service running on one | server and not like now

Re: Replication

2008-12-10 Thread Chandru
Hi Marcel, Can you tell me how many slaves are connecting to the master? If there are more than one slaves, can you please check the server id's of all the slaves, if they are unique. please also enable warning using log-warnings=2 in the config file, so that warnings are logged, which can give

multiple MATCH condition

2008-12-10 Thread Yunus Bookwala
  Hi Is it possible to have multiple MATCH and WHERE conditions in a single SELECT query? e.g. SELECT * FROM books_info MATCH(books_name) AGAINST ('Mysql') OR MATCH(books_authors) AGAINST ('abc xyz') OR WHERE books_isbn LIKE %8922b238h% The table structure is as below

Re: Re: multiple MATCH condition

2008-12-10 Thread Yunus Bookwala
Thanks a lot!! On Wed, 10 Dec 2008 John Daisley wrote : Try SELECT * FROM books_info WHERE MATCH(books_name) AGAINST ('Mysql') OR MATCH(books_authors) AGAINST ('abc xyz') OR books_isbn LIKE %8922b238h % That should bring back any books with either 'Mysql' in the 'books_name', 'abc xyz' in the

MySQL University session on December 11: Random Query Generator

2008-12-10 Thread Stefan Hinz
This Thursday (December 11th), Philip Stoev will talk about the Random Query Generator, a new QA tool that generates pseudo-random queries targeted to exercise a specific part of the server being tested. It then executes those queries to check for crashes or assertions or to compare the results

Re: multiple MATCH condition

2008-12-10 Thread John Daisley
Try SELECT * FROM books_info WHERE MATCH(books_name) AGAINST ('Mysql') OR MATCH(books_authors) AGAINST ('abc xyz') OR books_isbn LIKE %8922b238h % That should bring back any books with either 'Mysql' in the 'books_name', 'abc xyz' in the 'books_authors' or where the 'books_isbn' matches the

Need help with permissions between host, db and user tables

2008-12-10 Thread Vikram Vaswani
Hi, I'm trying to customize permissions for a particular database and have run into an odd problem. I'm hoping someone on this list can suggest what I'm doing wrong. The setup is as follows: Database: property User '[EMAIL PROTECTED]' should be able to run SELECTs on this database User '[EMAIL