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 al
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 Linux-Apa
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 del
t; rite ?
>
> Thanks,
> Abdul.
>
> 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
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:
If the value of this variable is positive, the MySQL server synchronizes its
binary log to disk (fdatas
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
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 dump
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 mor
10 matches
Mail list logo