Hi Dan,
Noted with thanks.
As such, is there a workaround to log problematic sql queries ran against
the mysqld server ? Do I need to write separate script to do this ?
Regards,
Ryan.
On 3/10/06, Dan Nelson <dnelson@stripped> wrote:
>
> In the last episode (Mar 08), ryan lwf said:
> > I understand that the option log-errors and log-warnings only logs
> > server related internal errors. How do I enable logging errors from
> > queries executed, so that I can fix the problematic query statement
> > accordingly?
> >
> > The statement "SHOW WARNINGS" and "SHOW ERRORS" does not work on my
> > server with mysqld-4.0.25 binary version.
>
> Those commands appeared in MySQL 4.1. Before then, warnings were
> simply counted.
>
> --
> Dan Nelson
> dnelson@stripped
>
