Server Log not logging all queries

[My SQL]

Hi,

I started the general query log with

mysqld --log

On my machine this command works fine and every select, update and all
statements are logged. I tried the same command on another machine and
many many queries are missing, I am running apache, PHP on that machine
and all the queries come through the web on localhost.

I wonder why this is happening?

Thanks
Rohan

[Bill Karwin]

My SQL wrote:

Hi,

I started the general query log with

mysqld --log

On my machine this command works fine and every select, update and all
statements are logged. I tried the same command on another machine and
many many queries are missing, I am running apache, PHP on that machine
and all the queries come through the web on localhost.

I wonder why this is happening?

What versions of MySQL are running on your machine and on the other
machine? Behavior of the logging or command-line options might be
different between the MySQL releases.

Is there any pattern to which queries are missing from the logs? Such
as all those after your restarted the MySQL server, or all queries from
your PHP apps, or other pattern?

Regards,
Bill K.

[My SQL]

all queries from the PHP apps are missing.The other queries from other
machines are all fine. The PHP and Mysql run on the same machine. I
think the queries from the localhost are all missing.

Help!!

[Bill Karwin]

My SQL wrote:

all queries from the PHP apps are missing.The other queries from other
machines are all fine. The PHP and Mysql run on the same machine. I
think the queries from the localhost are all missing.

Check your personal server for the queries (or stop the MySQL daemon on
your personal machine, and see if the PHP apps on the new server get
errors).

I'm wondering if the PHP apps are still configured to connect to MySQL
on your machine. It's worth double-checking.

Regards,
Bill K.

[My SQL]

yes the PHP apps stop working when the server is stopped, the PHP apps
are all connecting to the MySQL on the machine..

All the other queries are logged including the connect statements,
except for the queries from PHP on the same machine !!

Thanks

[Bill Karwin]

My SQL wrote:

yes the PHP apps stop working when the server is stopped, the PHP apps
are all connecting to the MySQL on the machine..

All the other queries are logged including the connect statements,
except for the queries from PHP on the same machine !!

I don't think you're understanding what I'm asking.

You said that you have two physical machines running these PHP
applications, called them "A" and "B". "A" is your machine. "B" is
what you describe as "another machine" in your original post on this
topic. The SQL queries are logged correctly on machine A, but
apparently are not logged correctly from PHP apps on machine B.

The PHP apps connect to a MySQL database. By doing so, they must
specify a host to which to connect. The host may be the same machine on
which the PHP apps run, but is not necessarily the same machine. PHP
can connect to MySQL running on any machine on the network. It depends
on the PHP code that makes the database connection. I'm assuming that
machines A and B are reachable to each other on your network.

My guess is that the PHP apps running on machine B are connecting to the
MySQL service on machine A. If that is the case, you'll find the
queries logged on machine A.

You can check the database connection code in your PHP apps on machine B
to verify. I suggested another way to verify was to shut off MySQL on
machine A and see if the PHP apps on machine B complain about the lack
of a database.

Regards,
Bill K.