Re: cluster
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
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
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]
Re: migration from 4.0 to 5.0
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]
migration from 4.0 to 5.0
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
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]