Hello.
The outputs of the following statements would be helpful, if you want that somebody helps you: SHOW MASTER STATUS; SHOW SLAVE STATUS; SHOW STATUS; Execute them on the master and the slave. "Hannes Rohde" <[EMAIL PROTECTED]> wrote: > Hi all, > > We use MySQL as a database backend on a portal site. We have a two > database server setup (one master, one slave). The master is a PIV 3,2 GHz., > 2 GB Ram and a 80GB Raid-1 system. The slave is a PIV 3.2 GHz., 4 GB Ram and > a 80GB Raid-0 system. Both run on MySQL 4.1.9 and only use InnoDB. Even > though the slave is a bigger system and is quite fast with selects, it > always falls behind in replication (Seconds behind the server keeps growing > at high-load times). > Is there any way to speed up the replication a little more? I have already > tried a whole lot of things but have never been successful, yet :-( > > Here is a snapshot of the configuration: > > skip-name-resolve > key_buffer=1M > max_allowed_packet=1M > thread_cache_size=128 > thread_stack=128K > table_cache=1024 > join_buffer_size=5M > read_buffer_size=5M > sort_buffer_size=5M > > thread_concurrency=4 > query_cache_size = 32M > query_cache_limit = 1M > query_cache_type = 2 > max_connections=900 > > innodb_data_file_path=ibdata1:2G:autoextend > > innodb_buffer_pool_size=1200M > innodb_additional_mem_pool_size=20M > > > P.S.: I hope I have given you enough information - it's my post on the > list...;-) > > I appreciate your help, > > Hannes Rohde > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]