Jeremy Zawodny wrote:
< snip >
>
> Are subsequent inserts just as slow to replicate?
>
> Can you show us the output of SHOW SLAVE STATUS and maybe the my.cnf
> files of the master and a slow slave?
>
> Jeremy
>
Thanks for the response. Below is the info you requested. If there's
anything else that might be of help, please let me know and I'll do my
best to provide it.
I'm pretty sure most, if not all subsequent inserts are slow, although
it might be true that if we did a number of inserts at the same time
that they may inserted on the slaves together. We have not tried this at
this point in time.
The slave status looks like:
-------------------------------------------
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File
| Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db |
Last_errno | Last_error | Skip_counter |
| p23.hoovers.com | repl | 3306 | 60 | p23-bin.004 | 931831 | Yes
| portlets | hoovers | 0 | | 0 |
-------------------------------------------
The Master status gives:
-------------------------------------------
| File | Position | Binlog_do_db | Binlog_ignore_db |
+-------------+----------+--------------+------------------+
| p23-bin.004 | 1004808 | portlets | hoovers |
-------------------------------------------
The Master my.cnf (comments removed):
-------------------------------------------[mysqld]
skip-locking
set-variable = key_buffer=384M
set-variable = max_allowed_packet=16M
set-variable = table_cache=512
set-variable = sort_buffer=6M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=128M
set-variable = thread_cache_size=4
set-variable = thread_concurrency=4 # Try number of CPU's*2
set-variable = tmp_table_size=4M
set-variable = net_read_timeout=300
set-variable = net_write_timeout=300
# Replication
log-bin
server-id=1
binlog-do-db=portlets
binlog-ignore-db=hoovers
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
-------------------------------------------
Slave my.cnf (comments removed):
-------------------------------------------
[mysqld]
skip-locking
set-variable = key_buffer=384M
set-variable = max_allowed_packet=16M
set-variable = table_cache=512
set-variable = sort_buffer=5M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=128M
set-variable = thread_cache_size=4
set-variable = thread_concurrency=4 # Try number of CPU's*2
set-variable = tmp_table_size=3M
set-variable = net_read_timeout=300
set-variable = net_write_timeout=300
set-variable = max_connections=500
log-update
# Replication
master-host=p23.hoovers.com
master-user=repl
master-password=<removed, but correct>
master-port=3306
server-id=2
replicate-do-db=portlets
replicate-ignore-db=hoovers
log-slave-updates
log-bin
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
-------------------------------------------
Thanks again,
- Jeff
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
