Log MySQL Queries

I have a database setup on my shared web hosting server. An
external
program is connecting to it and running the queries to
manage the data
and having some web page interaction too.


I want to monitor what is sending queries to the database.
Is there a
way to turn on query logging or a program that will allow me
to
monitor the database queries without having access to the
mysqld
server itself?

Thanks


--~--~---------~--~----~------------~-------~--~----~
This group is managed and maintained by the development
staff at 360 PSG. An enterprise application development
company utilizing open-source technologies for todays
small-to-medium size businesses.

For information or project assistance please visit :
http://www.360psg.com

You received this message because you are subscribed to the
Google Groups "Professional PHP Developers"
group.
To post to this group, send email to Professional-PHPgooglegroups.com
To unsubscribe from this group, send email to
Professional-PHP-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/Professional-PHP
-~----------~----~----~----~------~----~------~--~---

If you're familiar with PHPMyAdmin, you can view this
information via
the binary log that shows under "Server:
yourservername".

Susanne Bullo

On Jul 23, 1:42 pm, Boxxa <bryan.ben...gmail.com> wrote:
> I have a database setup on my shared web hosting
server. An external
> program is connecting to it and running the queries to
manage the data
> and having some web page interaction too.
>
> I want to monitor what is sending queries to the
database. Is there a
> way to turn on query logging or a program that will
allow me to
> monitor the database queries without having access to
the mysqld
> server itself?
>
> Thanks


--~--~---------~--~----~------------~-------~--~----~
This group is managed and maintained by the development
staff at 360 PSG. An enterprise application development
company utilizing open-source technologies for todays
small-to-medium size businesses.

For information or project assistance please visit :
http://www.360psg.com

You received this message because you are subscribed to the
Google Groups "Professional PHP Developers"
group.
To post to this group, send email to Professional-PHPgooglegroups.com
To unsubscribe from this group, send email to
Professional-PHP-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/Professional-PHP
-~----------~----~----~----~------~----~------~--~---

This information can be configurable using the MySQL client
and
setting variables IF you have the correct privileges.  The
slow query
log is always generated to a file and if you contact your
host they
might be able to turn it on specifically for your account
or
database.  Once again this essentially comes down to
configuration.
Another idea that you could potentially do is to create a
database
abstraction layer that times the responses and stores the
queries
after they take too long.

While that is not ideal it will provide you the information
you need.
Also make sure that you are using explain plans to see how
your query
will work and take a look at MySQL performance articles.

Regards,

Mike Willbanks


--~--~---------~--~----~------------~-------~--~----~
This group is managed and maintained by the development
staff at 360 PSG. An enterprise application development
company utilizing open-source technologies for todays
small-to-medium size businesses.

For information or project assistance please visit :
http://www.360psg.com

You received this message because you are subscribed to the
Google Groups "Professional PHP Developers"
group.
To post to this group, send email to Professional-PHPgooglegroups.com
To unsubscribe from this group, send email to
Professional-PHP-unsubscribegooglegroups.com
For more options, visit this group at http:
//groups.google.com/group/Professional-PHP
-~----------~----~----~----~------~----~------~--~---