Re: cluster

[MarisRuskulis]

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.

   



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Count total number of records in db

[MarisRuskulis]

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 you can iterate trough all tables, for that create
simple bash script. For example:

#!/bin/bash

tables=`mysql -uUser -pPass -hHost database_name --skip-column-names -e
SHOW TABLES`
total=0
for table in $tables
do
rows=`mysql -uUser -pPass -hHost database_name --skip-column-names
-e SELECT COUNT(*) from $table`
total=$(($total+rows))
done
echo $total


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Forcing import

[MarisRuskulis]

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 replaces column name timestamp with datetime, and in the same way
replace column names in INSERT statements


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

migration from 4.0 to 5.0

[MarisRuskulis]

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 passed --default-character-set=latin1 option, but
without success. I even tryed to copy data files to 5.0 and the result
is same.
hope that someone will help me.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: migration from 4.0 to 5.0

[MarisRuskulis]

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 isnt correct. On mysql 5.0 database
 charset is latin1 and SHOW TABLE STATUS shows that table is latin1.
 When I maked dump I passed --default-character-set=latin1 option, but
 without success. I even tryed to copy data files to 5.0 and the result
 is same.
 hope that someone will help me.

   
 


   


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL performance on LVM2

[MarisRuskulis]

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 takes some time. I think better solution is to use LVM
snapshots, but this performance decrease really scares me. Has anyone
some advices on this?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]