Re: Doubts tuning MySQL Percona Server 5.5

​Hi, I was checking MySQL performance ... Sometimes my database could be working slow. I have some queries that spend 9-10 seconds updating some columns by primary key. I'm not sure if is a data base problem ... Moreover, I have checked tuning scripts and appear these variables. Good sentence!

Re: Doubts tuning MySQL Percona Server 5.5

- Original Message - From: Antonio Fernández Pérez antoniofernan...@fabergroup.es Subject: Re: Doubts tuning MySQL Percona Server 5.5 ​I was checking MySQL performance ... Sometimes my database could be working slow. I have some queries that spend 9-10 seconds updating some columns

Re: Doubts tuning MySQL Percona Server 5.5

, Antonio Fernández Pérez antoniofernan...@fabergroup.es wrote: Hi list, I have some doubts adjusting some MySQL variables. ​ I have checked MySQL status and maybe I should to increase some variables ... For example: InnoDB log waits is 103; innodb_log_buffer_size is 8M -- Maybe the next best

Doubts tuning MySQL Percona Server 5.5

Hi list, I have some doubts adjusting some MySQL variables. ​ I have checked MySQL status and maybe I should to increase some variables ... For example: InnoDB log waits is 103; innodb_log_buffer_size is 8M -- Maybe the next best value could be 16M? Table cache hit rate is 12%; Open_tables

Doubts

Hello people, I am new in the list!! I am with a server linux red hat 9.0 with the mysql 4.0 installed server and usually rotating.Even so I don't get to connect in this server of another machine Windows that has the client of the mysql 4.0. Them machine is tied up in net it is obvious.

MySQL aplha, production release doubts...

Hi, I have used MySQL 4.0.17-max-debug for windows in win 2K SP-4 I would like to know Is there any impacts we may have to met using Alpha release before the release of production version. why we have different types of mysqld? mysqld mysqld-opt mysqld-nt mysqld-max

How MySQL is handling unicode() some doubts

Hello I am going thru the source code of MySQL client. I am not able to understand in general how MySQL is handling unicode characters. All the function take (char*) as arguments? Is it expecting all the data to be UTF8-encoded and before executing the queries (i was looking into the batch

Doubts with mysql update,delete queries

Hi all: Having some doubts with sql select queries here : Right now, I have a student and a withdraw tables. For example, when student John has withdrawn, his name will be inserted into withdraw table but John's record will be kept in student table for a period of 30 days before

Re: Doubts with mysql update,delete queries

Hi all: Having some doubts with sql select queries here : Right now, I have a student and a withdraw tables. For example, when student John has withdrawn, his name will be inserted into withdraw table but John's record will be kept in student table for a period of 30 days before

Re: Doubts with mysql update,delete queries

On 12/3/03 7:27 PM [EMAIL PROTECTED] wrote: Hi, yah that's what I'm looking for, creating a cronjob whereby this cron will automatically delete the record once 30 days is up...maybe using something like that: DELETE FROM tablename WHERE (DATA_SUB(NOW()), INTERVAL 30 DAY)

doubts

Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ Sir, My name is Reji.Iam studying for a master degree in computer applications.Iam new to mySQL.I