Re: Need help for performance tuning with Mysql

default` enum('on','off') default NULL > Did you really mean to have 3 values (on, off, NULL)? > > > > > -Original Message- > > From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com] > > Sent: Wednesday, May 23, 2012 7:10 PM > > To: my

RE: Need help for performance tuning with Mysql

('on','off') default NULL Did you really mean to have 3 values (on, off, NULL)? > -Original Message- > From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com] > Sent: Wednesday, May 23, 2012 7:10 PM > To: mysql@lists.mysql.com > Subject: Re: Need help for

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

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. > If data_id is unique, then you would only need an index on that. > > Alex > On second thought, an index on thold_enabl

Re: Need help for performance tuning with Mysql

On 2012/05/24 04:10, Yu Watanabe wrote: > 2. Instead INDEXes and schema design must be studied. Please provide: > SHOW CREATE TABLE > | thold_data | CREATE TABLE `thold_data` ( > `id` int(11) NOT NULL auto_increment, > `rra_id` int(11) NOT NULL default '0', > `data_id` int(11) NOT NU

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

BLE SIZE EXPLAIN SELECT ... > -Original Message- > From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com] > Sent: Tuesday, May 22, 2012 7:07 PM > To: mysql@lists.mysql.com > Subject: Need help for performance tuning with Mysql > > Hello all. > > I would like

Re: Need help for performance tuning with Mysql

ble_size > > >>>>max_heap_table_size > > >>>> > > >>>>but made not much difference. > > >> > > >>It is solution for only sql's large result,i think. > > >>if you doesn't recognize that problem causes large result, >

Re: Need help for performance tuning with Mysql

or only sql'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

Re: Need help for performance tuning with Mysql

nd result. >>> >>> total used free sharedbuffers cached >>> Mem: 81623807843676 318704 0 956325970892 >>> -/+ buffers/cache:17771526385228 >>> Swap: 8032492

Re: Need help for performance tuning with Mysql

used free sharedbuffers cached >> Mem: 81623807843676 318704 0 956325970892 >> -/+ buffers/cache: 17771526385228 >> Swap: 8032492 235608008932 >> >> Thanks, >> Yu >> >> >>

Re: Need help for performance tuning with Mysql

ng to give you the best performance increase. Also, what kind of hard disks do you have the 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. > > Fo

Re: Need help for performance tuning with Mysql

> -/+ buffers/cache:17771526385228 > Swap: 8032492 235608008932 > > Thanks, > Yu > > > Yu Watanabe さんは書きました: >>Hello all. >> >>I would like to ask for advice with performance tuning with MySQL. >> >>Following are some d

Re: Need help for performance tuning with Mysql

Watanabe さんは書きました: >Hello all. > >I would like to ask for advice with performance tuning with MySQL. > >Following are some data for my server. > >CPU: Xeon(TM) 2.8GHz (2CPUs - 8core total) >Memory : 8GB >OS : RHEL 4.4 x86_64 >MySQL : MySQL 5.0.50sp1-enterprise

Need help for performance tuning with Mysql

Hello all. I would like to ask for advice with performance tuning with MySQL. Following are some data for my server. CPU: Xeon(TM) 2.8GHz (2CPUs - 8core total) Memory : 8GB OS : RHEL 4.4 x86_64 MySQL : MySQL 5.0.50sp1-enterprise Attached file # my.cnf.txt : my.cnf

MySQL InnoDB memory performance tuning

Hi, I have a fairly small (data dir is 1.2GB) InnoDB database managed by MySQL 5.4.3-beta on an 8-core x86_64 Linux box with 16GB RAM. I'd like to use as much of the memory as possible, but despite specifying (e.g.) --innodb-buffer-pool-size=30, mysql only ever takes up 374M of resident mem

Performance tuning a group by with percentage

Running MySql 5.0.85, I need to be as efficient as possible about a few queries. If I could get a little review, I would appreciate it. I collect data in the millions, and need the top 50 grouped by one field, with a percentage of how much those top 50 occupy. Here is what I have come up wi

Performance tuning...

Hey guys, I'm trying to optimize our database server machine. Currently we have 5 mysql daemon running that serves between 5-20 DB each. Is it better for me to have only one mysql daemon running with all the DB ? And I will need some tips to fine tune the server it self also. It's running und

Re: Too Many Queries Have "Writing To Net" Status [mysql performance tuning]

Kishore Jalleda wrote: Hi All, We have a production Database, running mysql 4.0.17 , on a Poweredge 2650 with 3 GB RAM, and dual Xeon 2.4 GHZ, the server averages between 100 and 200 qps ( ,also and the CPU/MEM load is pretty low and is extremely fast except for once in a while may be 1

Re: innodb thread concurrency size [mysql performance tuning]

Clyde Lewis wrote: Hey guys, I'm looking for any best practices or a formula that is commonly used in setting the value for thread concurrency in the configuration file. I have 24 instances running on a sun 2900 server with 32GB or ram. Here is a sample of my configuration file. The best pr

Re: Total newb at performance tuning mysql

de and could be lower. Yours at 64 is on the low side. While I won't ignore table cache as being important, there are many many performance tuning things that need to get done to have an impact on the server. Firstly (knowing the type of things you are doing) InnoDB will likely be a

Re: Total newb at performance tuning mysql

which skips all the basic stuff and gets you into performance tuning. ISBN : 0-596-00306-4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Total newb at performance tuning mysql

Instead of your cron job, I suggest http://codenode.com/mysqlreport The mysqlreport documentation (http://codenode.com/mysqlreportdoc) is a pretty baseline introduction to comprehending server performance via a mysqlreport report, and a little bit about what you can do for certain issues. -Dani

Re: Total newb at performance tuning mysql

Hello. > I can tell, I have no my.cnf file in place, so there must be some default Create your own and the appropriate value for the table_cache. See: http://dev.mysql.com/doc/mysql/en/option-files.html http://dev.mysql.com/doc/mysql/en/program-variables.html

Total newb at performance tuning mysql

Unless I am totally off base here, the mysql docs tell very little in regards to how to performance tune mysql. So far I have found this article to help: But it still leaves me with a ton of questions. For starters, and d

Re: very slow inserts on InnoDB [InnoDB Performance Tuning]

Hi Catalin, Here are some InnoDB performance tuning tips that may boost your insert speed: Catalin Trifu wrote: ... innodb_buffer_pool_size = 256M Higher is better, in fact pushing this up to 60%-80% on a dedicated database would be good. If there are other things running like a web server

Re: Performance Tuning - Table Joins

My responses blended in Jason Johnson <[EMAIL PROTECTED]> wrote on 04/04/2005 02:19:12 PM: > The premise of the query is to return required continuing education > hours for the entire membership of the organization. Limited to one > member when providing a membership ID. > > The query is a

Re: Performance Tuning - Table Joins

j llarens wrote: 2) varchar(255) on ALL fields? That's unlikely, in-cre-di-ble. Right type for the right data, int for numbers, float for money, char for fixed string, and certainly NOT 255 for lenght! If its necesary such amount of characters, TEXT or BLOB must be used, but only if it is necesary.

RE: Performance Tuning - Table Joins

I wonder how somebody can approve such a query and tables. 1) There is no indexes, thats the main reason for the time and cpu consuming. At least, the fields used in the joins MUST be indexed. 2) varchar(255) on ALL fields? That's unlikely, in-cre-di-ble. Right type for the right data, int for

RE: Performance Tuning - Table Joins

: Monday, April 04, 2005 1:30 PM To: MySQL list Subject: Re: Performance Tuning - Table Joins At 12:22 PM 4/4/2005, you wrote: >I have been struggling to maintain decent performance on a web/database >server for a good 6 months now due to MySQL performance issues. I have >decided that my best

Re: Performance Tuning - Table Joins

At 12:22 PM 4/4/2005, you wrote: I have been struggling to maintain decent performance on a web/database server for a good 6 months now due to MySQL performance issues. I have decided that my best option at this point is to take it to the list, so in advance, I thank you all for taking a look.

Re: Performance Tuning - Table Joins

The premise of the query is to return required continuing education hours for the entire membership of the organization. Limited to one member when providing a membership ID. The query is a little bulky, and fortunately I cannot take credit for its design, but here goes (keep in mind that so

Re: Performance Tuning - Table Joins

On Apr 4, 2005, at 1:22 PM, Jason Johnson wrote: I have been struggling to maintain decent performance on a web/database server for a good 6 months now due to MySQL performance issues. I have decided that my best option at this point is to take it to the list, so in advance, I thank you all for

Performance Tuning - Table Joins

I have been struggling to maintain decent performance on a web/database server for a good 6 months now due to MySQL performance issues. I have decided that my best option at this point is to take it to the list, so in advance, I thank you all for taking a look. There is no error messages that c

Re: Performance Tuning on FreeBSD

On Sat, May 01, 2004 at 09:50:14PM -0700, Max Clark wrote: > Hi all, > > I have a db that is connection heavy running on FreeBSD 4.9. The server > was compiled with Linux Threads enabled. > > I am searching for performance tuning information. Outside of enabling > Linux T

Re: Performance Tuning on FreeBSD

At 11:50 PM 5/1/2004, you wrote: Hi all, I have a db that is connection heavy running on FreeBSD 4.9. The server was compiled with Linux Threads enabled. I am searching for performance tuning information. Outside of enabling Linux Threads I haven't been able to find much else. I am unde

Performance Tuning on FreeBSD

Hi all, I have a db that is connection heavy running on FreeBSD 4.9. The server was compiled with Linux Threads enabled. I am searching for performance tuning information. Outside of enabling Linux Threads I haven't been able to find much else. I am under the impression that I should be

Re: MySQL Performance Tuning?

currently > > > What tuning have you done to the my.cnf, and are you sure that MySQL is > > using that my.cnf (ie is it in the correct location)? > > > > Tunings that I have tweaked cuurently are > 1. join_buffer_size 131072 > > > > 2. key_buffer_size 16773120 >

Re: MySQL Performance Tuning?

Hi! We are a hardware store(similiar to usa's home depot) here in venezuela. We have 14 stores that moves a very heavy load of traffic. Many of our retails runs in a home brew POS that uses mysql. Then sales are uploaded to a bigger in-store server and then move to the central office. The prices,

Re: MySQL Performance Tuning?

. Thanks! - Original Message - From: "mysql" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 15, 2004 9:23 AM Subject: MySQL Performance Tuning? Hi Gurus, I'm currently building an application which is expected to take very high loads. Wh

MySQL Performance Tuning?

Hi Gurus, I'm currently building an application which is expected to take very high loads. What the app does is essence is to 'log' and incoming entry into MySQL, do something then updates the 'log' entry. To test MySQL in handling high load, I used siege on another server to send 1000 HTTP

Re: MySQL Performance Tuning?

have you done to the my.cnf, and are you sure that MySQL is using that my.cnf (ie is it in the correct location)? - Original Message - From: "mysql" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 15, 2004 9:23 AM Subject: MySQL Performance Tuning?

MySQL Performance Tuning?

Hi Gurus, I'm currently building an application which is expected to take very high loads. What the app does is essence is to 'log' and incoming entry into MySQL, do something then updates the 'log' entry. To test MySQL in handling high load, I used siege on another server to send 1

Re: MySQL 4.x performance tuning

Reto Baumann wrote: Is there a way to see if the key buffer size was ever reached? It's not really an issue. You can determine how frequently it has the needed index data in memory, to judge the key buffer efficiency. Key read requests 3518220013 Key reads 94807 Key reads / Key

MySQL 4.x performance tuning

Hi all I have a MySQL installation running on a Pentium3 based system with 2GB RAM... The database primarily uses MyISAM tables with 60% SELECT statements. The database is used as a backend for a PHP web application. Do the following values make any sense? set-variable= key_buffer=200M set-

Re: performance tuning (generating summary tables)

On Thu, 2002-11-21 at 09:47, Johannes Ullrich wrote: > And more difficult, try to look at your application design and try > to come up with 'cache tables' that are generated by a cron job > periodically and are used for most queries. This is an excellent suggestion and may make you think about yo

Re: performance tuning

> MySQL 3.23.51 > Linux Kernel 2.4.16 > we do have 1 GB of RAM > the main problem seems to be a table with about 8.597.146 records. Similar situation here (>100 Million rows). things I found that help: - be selective on what rows to index. Try to limit yourself to one row. - increase the ke

performance tuning

Hi I have a problem with performance for out mysql db. The docs on www.mysql.com don't really help because they arent specific enought (what is big ???). The load on our server currently is over 2 permanently and I don't think that is very good. We use: MySQL 3.23.51 Linux Kernel 2.4.16 we do

Re: Performance Tuning?

Devon Harding - GTHLA wrote: >Where can I find some info on mysql performance tuning? > > http://www.mysql.com/doc/M/y/MySQL_Optimisation.html -myk - Before posting, please check: http://www.mysql.com/manual.p

Performance Tuning?

Where can I find some info on mysql performance tuning? _ Devon Harding System Administrator Gilat Latin America 954-858-1600 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Re: Really good idea on Performance Tuning???

At 03:02 PM 1/30/2002 , you wrote: >At 12:22 PM 1/30/2002 -0600, you wrote: > >I sent a reply back to JW about his problem on performance tuning and > came up with I thought a really good idea. But there weren't any bites so > I thought I start it on a new thread. > >

Re: Really good idea on Performance Tuning???

At 02:38 PM 1/30/2002 , you wrote: >What is the best source of information about >performance tuning MySQL? I saw that Jeremy's proposed >book was to include a lot of coverage on this topic -- >are there other sources? Is the online doc the best >place so far? I would fi

RE: Really good idea on Performance Tuning???

>That is possible too: > - MySQL Training (http://www.mysql.com/training/) > - MySQL Support (http://www.mysql.com/support/) > - MySQL Consulting (http://www.mysql.com/consulting/) >However, it will never be a substitute for manual tuning. Good database >performance more than simply the result o

RE: Really good idea on Performance Tuning???

Hi Steve, On Thu, 2002-01-31 at 06:35, Steve Rapaport wrote: > I'd buy it! That is possible too: - MySQL Training (http://www.mysql.com/training/) - MySQL Support (http://www.mysql.com/support/) - MySQL Consulting (http://www.mysql.com/consulting/) See, the manual and sample cnf files alread

Re: Really good idea on Performance Tuning???

At 12:22 PM 1/30/2002 -0600, you wrote: >I sent a reply back to JW about his problem on performance tuning and came up with I >thought a really good idea. But there weren't any bites so I thought I start it on a >new thread. I'd like to point out that I'm pretty sure

Re: Really good idea on Performance Tuning???

What is the best source of information about performance tuning MySQL? I saw that Jeremy's proposed book was to include a lot of coverage on this topic -- are there other sources? Is the online doc the best place so far? --- Mike Wexler <[EMAIL PROTECTED]> wrote: > I don't t

RE: Really good idea on Performance Tuning???

I'd buy it! -steve -Original Message- From: BD [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 7:23 PM To: [EMAIL PROTECTED] Subject: Really good idea on Performance Tuning??? I sent a reply back to JW about his problem on performance tuning and came up with I thou

Re: Really good idea on Performance Tuning???

viate the problems and get us to at least a second approximation. I agree that some kind of automation here would be desirable. BD wrote: > I sent a reply back to JW about his problem on performance tuning and > came up with I thought a really good idea. But there weren't any bites

Really good idea on Performance Tuning???

I sent a reply back to JW about his problem on performance tuning and came up with I thought a really good idea. But there weren't any bites so I thought I start it on a new thread. There are a lot of threads about setting up MySQL for the best performance. This might help to solv

Performance tuning

Hello, I've just set up a MySQL server. I've installed the rpm and run the server before on multi-purpose servers (also running mail, httpd, etc) but this is the first time I've set up a dedicated SQL sever and spent any time tuning it. First, the specs: Dell PowerEdge 2450 2GB RAM 5 disk RAID

Performance tuning Mysql

Vien Huynhle writes: > I am getting this error in my log files from mysql > > (Got timeout reading communication packets) > > I'm starting safemysql with the variables > > -O key_buffer=16M -O sort_buffer=1M -O back_log=200 & Hi Vien, Please increase the 'net_write_timeout' and 'ne

Performance tuning Mysql

I am getting this error in my log files from mysql (Got timeout reading communication packets) I'm starting safemysql with the variables -O key_buffer=16M -O sort_buffer=1M -O back_log=200 & mysql> show status -> ; +--+--+ | Variable_name| Va