mysqlimport with parallel threads is worth giving a try. It is similar
to 'load data infile' but with concurrent threads loading the tables.
I think , it was added in mysql-5.1.18. But it is said to work with
previous versions also according to the author :
Make sure each of the replication slaves uses different server_id.
--Ravi
Ben Clewett wrote:
MySql,
I am running 5.0.41 on a master and four replication slaves, all 64
bit Linux.
In the error.log on all four replication servers I keep seeing:
070626 8:34:23 [Note] Slave: received end
Which thread library is the mysqld linked against? Linuxthreads shows
each thread as a separate process in top or ps output. All threads
share the same memory. From your output, it is likely that you are
using linuxthreads(all pids having the same VSZ and RES memory).
Regards,
Ravi
Cabbar
How are you importing the dump into mysql? Importing by piping the dump
file to mysql may broke some chars due to shell.
Have you tried this: (with in mysql client)
SET NAMES UTF8; SET CHARACTER SET UTF8
source /pathto/dump.sql
Cheers,
--Ravi
Sean O'Hara wrote:
Hi All,
I've been googling
This blog may help,
http://www.xaprb.com/blog/2006/07/23/how-to-track-what-owns-a-mysql-connection/
Cheers,
Ravi
Rithish Saralaya wrote:
Hello people.
Is it possible to find the process that invoked the mysql thread, given a
mysql thread id?
We have a web application that runs on
Tripp,
ibdata files never shrink. You can try this to free up space:
* Take a mysqldump of all tables that you may need,
* delete the ibdata files,
* Rebuild your tables by importing the dump.
Using innodb_file_per_table, will freed the disk space whenever you
run optimize table or
.
On Tue, 2006-04-11 at 10:51 +0530, Ravi Prasad LR wrote:
Hi Abdul,
When sync_binlog is set to 1, innodb fsyncs the binary
log to disk after every single write to binary log, but not in the case
of sync_binlog=0.
From MySQL manual:
snip
If the value of this variable
Hi Abdul,
When sync_binlog is set to 1, innodb fsyncs the binary log to
disk after every single write to binary log, but not in the case of
sync_binlog=0.
From MySQL manual:
snip
If the value of this variable is positive, the MySQL server synchronizes its
binary log to disk
Luke,
Yup. Basically if I do a particular query from the command line,
I get the following error:
===
InnoDB: Error: tried to read 16384 bytes at offset 1 3469819904.
InnoDB: Was only able to read -1.
060327 8:25:41 InnoDB: Operating system error number 5 in a
Marvin,
The process is working between Master, Slave1 and Slave2 but
for some reason Slave2 is not writing bin-log information.
So Slave3 is sitting empty and not getting any data because of no data
in Slave2's bin-log.
I guess u don't have 'log-slave-updates' flag
Hi all,
Server version :4.0.26
OS: FeeBSD-4.10
The mysql server(slave) crashes with the following messages in its error
log, and gets restarted, after which rollbacks and starts replicating from
master
Page directory corruption: supremum not pointed to
051226 10:02:58 InnoDB: Page
Hi James,
If you want to configure a relay replication server, i.e. make the
replication to pass data from slave to another slave as A-B-C you need to
start B with --log-bin and --log-slave-updates.So check that
log-slave-updates has been included in your my.cnf file.
You can read more
12 matches
Mail list logo
