What kind of querys there is, how many writes and reads? How complex is
querys.
Krishna Chandra Prajapati wrote:
Hi all,
Is there any way to know that mysql cluster setup is required there is a lot
of aborted clients on my production server. Every day it is increasing 150
per day.
Warren Windvogel wrote:
Hi,
Can anyone tell me how to check the total number of records in a
database in MySQL version 4.0
Googling doesn't seem to help and all previous posts assume version 5.*
Regards
Warren
for table you can use:
SELECT COUNT(*) from the_table_name;
in whole database
Warren Windvogel wrote:
Hi,
Is there a way to force mysql to import a dump which contains a mysql
reserved word as a field name?
Regards
Warren
You can use sed to replace column names with other.
for example:
sed 's/timestamp (timestamp) not null/datetime (timestamp) not null/g'
which
Hello!
I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I
maked dump from 4.0 and then restored it to 5.0, but without success
because inside the web symbols isnt correct. On mysql 5.0 database
charset is latin1 and SHOW TABLE STATUS shows that table is latin1.
When I maked dump I
Found partial sollution! Need to specify mysql_query(SET NAMES
'latin1'); for connection charset.
MarisRuskulis wrote:
Hello!
I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I
maked dump from 4.0 and then restored it to 5.0, but without success
because inside the web symbols
Hello!
I'm wondering about MySQL LVM2 preformance, but cant found any
comparisions. I know that there is some speed decrease with LVM,
something about 30%. But how this decrease impacts overal MySQL performance?
Now we are backuping replication slave server with mysqldump w full
table locks, this