Otto , I did read it , many times. I did not just plugged in bigger numbers, i'd like to think that i know what i'm doing here . I increased the values acorrding to my hardware and mysql status that needed to be increased in order to improve performance. I made my login.conf and my.cnf correspond to each other also. I found this links very useful, these provide ways to monitor your mysql server, improve performance and some ways to determine when to increase some values and when to decrease some others. I know some users will benefit from these:
http://hackmysql.com/mysqlreportguide http://www.ibm.com/developerworks/linux/library/l-tune-lamp-3.html http://www.mysqlperformanceblog.com The link http://openbsdsupport.org/mysql.htm doesn't help on how to improve mysql , but just how to start it and how to handle descriptors properly. There's no problem on following those instructions. I happened to find out that the problem on this case was not related to my configuration or openbsd itself, but to a modification on the mysqld_safe script made by the previous administrator of this server, i found this: -- echo "Starting $MYSQLD daemon with databases from $DATADIR" ulimit -a echo ------------------- ulimit -n 2048 > /dev/null 2>&1 # FIX para open files echo ------------------- ulimit -a -- So that was the reason i couldn't complete a full mysqlcheck on all databases, i was limited by that ulimit on mysqld_safe which wouldn't let me open more that 2048 files despite of what i configured in my.cnf. Regards, ----- Original Message ----- From: "Otto Moerbeek" <[EMAIL PROTECTED]> To: "Marcos Laufer" <[EMAIL PROTECTED]> Cc: <misc@openbsd.org>; <[EMAIL PROTECTED]>; "Daniel Ouellet" <[EMAIL PROTECTED]> Sent: Sunday, July 15, 2007 3:54 AM Subject: Re: mysql problem On Sun, 15 Jul 2007, Marcos Laufer wrote: > Ok , i had followed the instructions at http://openbsdsupport.org/mysql.htm No you did not. You plugged in bigger numbers. That could very well be your problem. Also there should be some correspondence to the numbers in login.conf and my.cnf. Another thing to watch out for: the login.conf syntax is extremely unforgiving, an extra space or tab after a \ can ruin your day. -Otto > > And now i have this configuration: > > I start mysql with this script:
