How to tweek the max connections

Hi all! I would like know if there are any calculatios for specifying the maximum number of the 'max_connections' value. I understand that max_connections should be decided by the remaining RAM size of the system. But exactly how should it be actually calculated? I am currently using RHEL 5.3 3

Re: Need help for performance tuning with Mysql

he data files on? Raid? No raid? > >Sent from my iPad > >On May 22, 2012, at 9:08 PM, Yu Watanabe wrote: > >> Hello all. >> >> I would like to ask for advice with performance tuning with MySQL. >> >> Following are some data for my server. >> >>

Re: Need help for performance tuning with Mysql

Alex Thank you for the advice. Probably, we will put index (key) on both columns. Thanks, Yu Alex Schaft さんは書きました: >On 2012/05/24 07:37, Alex Schaft wrote: >> You are selecting a record based on the value of data_id and >> thold_enabled, but don't have an index on either? Add an index for both.

Re: Need help for performance tuning with Mysql

query. Tuning will not help. Period. > >1. There are only a few things worth tuning -- see >http://mysql.rjweb.org/doc.php/memory (they don't include the ones you tried) > >2. Instead INDEXes and schema design must be studied. Please provide: >SHOW CREATE TABLE &

Re: Need help for performance tuning with Mysql

27;s large result,i think. >if you doesn't recognize that problem causes large result, >you should approach other way,too. > >regards, > > >ts. tanaka// > >2012/5/23 Yu Watanabe : >> Also following is the free command result. >> >> total

Re: Need help for performance tuning with Mysql

5% >io 3% > >I assume that MySQL can work more but currently not. > >I am considersing to off load 1 high load database to >seperate process and make MySQL work in multiple process. > >It would be a great help if people in this forum can give >us an adivice for

Need help for performance tuning with Mysql

ocess. It would be a great help if people in this forum can give us an adivice for the tuning. Best Regards, Yu Watanabe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Setting up MySQL on D drive on Windows

Hi! I would like to ask question about the instruction fo setting up MySQL environment on D drive. I have installed MySQL on D drive using MSI installer on following platform, Windows 2008 R2 Mysql community edition 5.5.19 In this situation I would like to ask following question. 1. There ar

Re: Data file for MyISAM engine

s >key buffer is as the name says a memory-buffer for kyes > >Am 24.11.2011 10:25, schrieb Yu Watanabe: >> Hello Johan. >> >> Thank you for the reply. >> I see. So it will depend on the key buffer size. >> >> Thanks, >> Yu >> >> Johan

Re: Data file for MyISAM engine

Hello Johan. Thank you for the reply. I see. So it will depend on the key buffer size. Thanks, Yu Johan De Meersman さんは書きました: >- Original Message - >> From: "Yu Watanabe" >> >> It seems that MYD is the data file but this file size seems to be not >

Data file for MyISAM engine

Hi ! I would like to ask question regarding to the MyISAM engine. Is there any physical file that you have to be aware of its size for disk sizing, like the ibdata1 in innodb storage engine? It seems that MYD is the data file but this file size seems to be not increasing after the insert sql.