RE: Optimal MySQL server -- opinions?

2008-04-28 Thread Francisco Rodrigo Cortinas Maseda
Hi, My experience shows me that RAM and disk is fundamental for any database, especially MySQL. As much IO load, much more disk preading you have to take with. Personally, i have 2 databases with 11 millions Inserts / day (2GB / day), so my advise is that you spend as much money as you can in

RE: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)

2008-04-28 Thread Francisco Rodrigo Cortinas Maseda
Hi, I have experienced similar problems to the one you have; the problem you have is that the time gap between the failure and now is so big that you cannot resume replication, because of the big data portion you have to replicate. When this happens to me, increasing the value of the variable

RE: Performance problem

2008-04-21 Thread Francisco Rodrigo Cortinas Maseda
17:34 CC: mysql@lists.mysql.com Asunto: RE: Performance problem On Fri, 18 Apr 2008, Francisco Rodrigo Cortinas Maseda [EMAIL PROTECTED] wrote: im new on the performance tuning of this database (MySQL 5.0.45, rpm-based installation), and i have one performance problem on our new

RE: Performance problem

2008-04-18 Thread Francisco Rodrigo Cortinas Maseda
I`ve resolved my problems without hardware manipulation. Thanks to all. -Mensaje original- De: Francisco Rodrigo Cortinas Maseda Enviado el: miƩrcoles 16 de abril de 2008 18:57 Para: mysql@lists.mysql.com Asunto: RV: Performance problem Hi all, im new on the performance tuning

RV: Performance problem

2008-04-16 Thread Francisco Rodrigo Cortinas Maseda
Hi all, im new on the performance tuning of this database (MySQL 5.0.45, rpm-based installation), and i have one performance problem on our new installation: - The radius servers (that are written on perl) we have are writing the auth and acct log to one mysql database. The conn we have is