> Hardware?
> Operating System and version?
> MySql version?
> Precompiled, you compiled?
> Which compiler?
Intel Dual 1Ghz, 1Gb RAM, RedHat Linux 6.2, kernel 2.4.16, MySQL 3.23.52
from rpms (happened the same with 3.23.46). As I said before, this only
happens the last few days, we were runnin
Hi. These last days, after some months of running relatively smoothly,
I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it
just goes astray and virtually hangs. Load goes up to +200%, all
connections are occupied and it just doesn't do anything. The only way to
stop it is
> Also, what we have done is used a replicating box as a select only server.
> This requires you to write your code in such a way that only selects get
> sent to the slave. A simple function wrapper in PHP is all we needed.
I've been thinking of this idea too but it's a bit of a problem becau
> I am new to MySql. I have MySql installed in my Linux PC. How do I connect
> to MySql using Perl script and assign the result of a query to an array?
> Where could I find a sample code? Thank you.
man DBD::mysql
Cheers.
--
Luis Calero Muñoz
$email{luis} = '[EMAIL PROTECTED]'
$who
Hi. I've been testing some querys with this two versions of mysql and
found weird results. First we try with 3.23.32:
(foo)-/usr/local/mysql_3.23.32/bin# ./mysql -uroot publish
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.32-lo
Hi. We're in the process of making a database driven website for a
client and I'd like to clear one doubt. There are going to be two frontend
machines w/ apache on linux and one shared NAS on the back for the all
data (possibly a Netapp box).
My question is: is it a good idea to have the dat
> can anybody please desc
> from the scratch (user rights)
> of configuring 2 mysql servers in
> master/slave fashion for replicatiom.
http://www.mysql.com/doc/R/e/Replication.html
Not that difficult to find...
--
Luis Calero Muñoz
$email{luis} = '[EMAIL PROTECTED]'
$who{luis} = 'sys
> I assume you've done the slow-query-log review thing... making sure all your
> queries are fast, yes?
Yes, you're right. After I did the myisamchk, the box has been more or
less stable with loads from 10 to 15. Still seems a lot ot me. I've
checked slow-query-log and only seemed to have one
> There are some others with a similar problem(including me). The question
> still remain,
> if it is all caused by the same bug(?).
> What table-types do you use? (MyISAM,Merge,BDB,...)
MyISAM
> How many entries are in the tables?
Up to 145000 in some of the tables. But its not the usual
Hi all, this is my first question on this list and I hope that you can
help me. I've got one dedicated box for MySQL and it's going downhill just
by starting the DB. The box is a dual PIII 800Mhz, 1 Ghz RAM, Linux RedHat
6.2 w/ kernel 2.4.6SMP, SCSI Drives and plugged to a 100Mb internal
networ
10 matches
Mail list logo
