Re: Warning: mysql is deprecated???

2002-02-17 Thread Bjorn Swift
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

Re: Mysqld load

2002-02-16 Thread Bjorn Swift
> 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

Mysqld load

2002-02-15 Thread Bjorn Swift
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