replication

Hi, I enabled binlog for replication yesterday and i'm getting some problems: -Yesterday, and all last days binlog was off, and i had an only one mysqld process at top processlist. -Today I'm getting several mysql processes, instead of a single one. -I've got three hard disks, one drive for

innodb and high server load

hi,i’ve some two forum tables with abot 700Mb each one, and they was type myisam. I was getting some lock problems and i decided to switch them to innodb, but server load growed from 3 to 20. I followed your steps but i got not any server load improvements. should i back to myisam? or is

inconsistent replication?

Hi, Some hours ago i setup the replication for my cluster and it's the third time i need to reset the replication and copy the whole database from master to slave due to errors like this: 051228 17:13:35 [ERROR] Slave: Error 'Duplicate entry '9947776' for key 1' on query. Default database:

upgrading to mysql 5

hi, I've upgraded from mysql 4.1 to mysql 5 and some queries doesn't work. It's not explained on mysql changes incompatibilities... for example: SELECT yabbse_topics.ID_LAST_MSG, yabbse_topics.ID_TOPIC, yabbse_topics.numReplies, yabbse_topics.locked, yabbse_messages.posterName,

Re: upgrading to mysql 5

. - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: PaginaDeSpud [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, December 27, 2005 10:29 PM Subject: Re: upgrading to mysql 5 /I've upgraded from mysql 4.1 to mysql 5 and some queries doesn't work. It's not explained on mysql

Re: locking issues

do you use for your tables? InnoDB usually is the best choice if you have lots of concurrent updates and inserts. PaginaDeSpud [EMAIL PROTECTED] wrote: I'm getting locking issues due to tables very often updated/insert. It's splitted into two tables, one has the more updated data

locking issues

I'm getting locking issues due to tables very often updated/insert. It's splitted into two tables, one has the more updated data and the another has the more static data. I'm using queries with JOIN, would it be better for performance to use two queries instead of using JOIN? Thanks. Ivan L.

Re: locked status problem

carries over 800.000 not unique hits per day. When the mysel fall into locked state, i can see enough free RAM and swap is never used. - Original Message - From: Jigal van Hemert [EMAIL PROTECTED] To: PaginaDeSpud [EMAIL PROTECTED] Sent: Monday, November 07, 2005 9:17 AM Subject: Re: locked

Re: low speed select

try to make an index with both fields and delete the individual indexes. the cause of why it takes much less time is because mysql cache, if tue query is cached it usually takes 0 seconds, but when something is changed on this table, cache is flushed and the query takes the real time it need.

locked status problem

Hi, i've got a problem with my server because some times per day, something occurs and server load average grows until 20 due to mysql. When it occurs, with show processlist, I can see a lot of queued queries in locked state ( more than 100 queued). You can see the load average at