Re: Doubts tuning MySQL Percona Server 5.5

2014-07-07 Thread Johan De Meersman
- Original Message - > From: "Antonio Fernández Pérez" > 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 by

Re: Doubts tuning MySQL Percona Server 5.5

2014-07-06 Thread Antonio Fernández Pérez
​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

2014-07-05 Thread Johan De Meersman
2014 8:00:31 PM CEST, "Antonio Fernández Pérez" 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_buffe

Doubts tuning MySQL Percona Server 5.5

2014-07-04 Thread Antonio Fernández Pérez
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

2004-10-05 Thread Diogo O VASCONCELLOS
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. tha

MySQL aplha, production release doubts...

2004-02-10 Thread Arunachalam
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 mysqld-m

How MySQL is handling unicode() some doubts

2004-02-04 Thread Karam Chand
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 file

Re: Doubts with mysql update,delete queries

2003-12-03 Thread Joakim Ryden
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) > name_of_date_

Re: Doubts with mysql update,delete queries

2003-12-03 Thread irinchiang
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 kep

Doubts with mysql update,delete queries

2003-12-03 Thread irinchiang
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 kep

doubts

2003-08-04 Thread abbas reji
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 don'