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 da
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'
w
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 withou
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
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 t
