Hi all.
The load on my mysqld server is getting higher by the day and I am trying to
get a better picture of what's going on. I recompiled with the debug option
and have started a trace log.
Is there any tool available that can analyze the trace log and give me an
easy to read output? Or is ther
> Have you optimized the settings in my.cnf and checked your slow
> queries?
No, I haven't optimized my.cnf - looking at it now. Thanks.
Well, that was pretty much what I was hoping this "tool" could do; go though
the trace log and print out the slow queries. Is the only way to go manually
thoug
This is not a Mysql issue but an PHP one. The function you are using
(mysql_db_query ?) is deprecated and should therefore not be used. Try
modifying your PHP script to use
mysql_select_db("test");
mysql_query("select * from tablename");
.. instead of
mysql_db_query("test","select * from tablen
