Re: monitoring mysql performance

2017-11-02 Thread Reindl Harald
Am 02.11.2017 um 20:09 schrieb Miguel González: I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using innodb. So I´m thinking of ways of improving MySQL performance and of course for that, you need

monitoring mysql performance

2017-11-02 Thread Miguel González
Hi, I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using innodb. So I´m thinking of ways of improving MySQL performance and of course for that, you need to measure. Currently I´m checking, there are

ANN: MySQL Performance Monitoring

2014-05-21 Thread Mick Emmett
Greetings MySQL users -- If MySQL monitoring is something you are doing with one specific tool -- or not at all -- then you might find this blog post on MySQL Performance Monitoring in SPM worth a read: http://wp.me/pwdA7-Xo We frequently hear from organizations across industries who tackle

Re: sync_binlog=0 affects MySQL performance but sync_binlog=1 works well

2012-11-28 Thread Reindl Harald
Am 29.11.2012 03:29, schrieb Dehua Yang: > Finally , when the sync_binlog=0 , the commit statement disappear in the > slow.log in the subject you say exactly the opposite and if something disappears in the slow.log it is good - so how should we help? signature.asc Description: OpenPGP digi

Re: Odd MySQL performance behaviour

2011-07-18 Thread walter harms
maybe its is obvoius but did you look at the statistics ? did you try "optimize table" ? re, wh Am 18.07.2011 18:40, schrieb A F: > [Process:] > > Importing > delimited text files from a Windows based server to a MySQL 5.1.41 instance > (multiple databases) on a single Ubuntu 10.04.2 host. >

Odd MySQL performance behaviour

2011-07-18 Thread A F
[Process:]   Importing delimited text files from a Windows based server to a MySQL 5.1.41 instance (multiple databases) on a single Ubuntu 10.04.2 host.  The process is initiated on the Windows server via the MySQL exe using ‘load data local infile’. There are 20 databases total and we import 15 f

Re: document for mysql performance improvement

2010-09-23 Thread Johnny Withers
If this is a dedicated MySQL box, i would increase the InnoDB buffer pool setting in my.cnf to at least 8GB, 12 would be even better (you did say you have 16GB of ram in the machine I believe). Also, what is the output of: show status like '%tmp%'; JW On Wed, Sep 22, 2010 at 8:01 PM, Vokern wr

Re: document for mysql performance improvement

2010-09-22 Thread Vokern
2010/9/23 Johnny Withers > > Can you show us the output of: show status like '%innodb%' > JW > Sure. mysql> show status like '%innodb%'; +---++ | Variable_name | Value | +---+---

Re: document for mysql performance improvement

2010-09-22 Thread Johnny Withers
Can you show us the output of: show status like '%innodb%' JW On Tue, Sep 21, 2010 at 10:11 PM, vokern wrote: > And this is the innodb file size, does this matter for performance? > > $ du -h ibdata* > 11G ibdata1 > 11G ibdata2 > 11G ibdata3 > 59G ibdata4 > > > > 2010/9/22 voke

Re: document for mysql performance improvement

2010-09-22 Thread Baron Schwartz
Hi, > If its an IO problem the first and easiest thing to do is (probably) look at > your disk subsystem. You can easily achieve higher disk IO by increasing the > number of disks and implementing something like RAID1+0. Or you can be logical about it and try to determine whether the IO performan

Re: document for mysql performance improvement

2010-09-21 Thread vokern
And this is the innodb file size, does this matter for performance? $ du -h ibdata* 11G ibdata1 11G ibdata2 11G ibdata3 59G ibdata4 2010/9/22 vokern : > This is piece of the setting in my.cnf: > > set-variable = innodb_buffer_pool_size=4G > set-variable = innodb_additional_mem_p

Re: document for mysql performance improvement

2010-09-21 Thread vokern
This is piece of the setting in my.cnf: set-variable = innodb_buffer_pool_size=4G set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_flush_log_at_trx_commit=2 set-variable = innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3:10G;ibdata4:10G:autoextend key_buffer

Re: document for mysql performance improvement

2010-09-21 Thread petya
Hi, Check your slow queries first. Large full scans can cause unwanted disk io. Do you use MyISAM or InnoDB? From your status, you seem to have intensive MyISAM locking. Peter On 09/21/2010 04:10 PM, Johan De Meersman wrote: Also, mailing list doesn't want to distribute attachments :-) Here

Re: document for mysql performance improvement

2010-09-21 Thread Johan De Meersman
Also, mailing list doesn't want to distribute attachments :-) Here's a link to the metrics view I was on about earlier: http://www.tuxera.be/mysqlstats.zip On Tue, Sep 21, 2010 at 4:08 PM, Johan De Meersman wrote: > > > On Tue, Sep 21, 2010 at 4:03 PM, wrote: > >> Quoting Johan De Meersman : >>

Re: document for mysql performance improvement

2010-09-21 Thread Johan De Meersman
On Tue, Sep 21, 2010 at 4:03 PM, wrote: > Quoting Johan De Meersman : > >> Your raid controller is "lying" to you - you can't have RAID10 with just >> two >> disks :-p Don't worry about that, though - it's a good enough config. >> > > Good enough? If he is genuinely saturating the disk with IO (a

Re: document for mysql performance improvement

2010-09-21 Thread a . smith
Quoting Johan De Meersman : Your raid controller is "lying" to you - you can't have RAID10 with just two disks :-p Don't worry about that, though - it's a good enough config. Good enough? If he is genuinely saturating the disk with IO (as he states the problem is IO) then it isnt good enoug

Re: document for mysql performance improvement

2010-09-21 Thread Bruce Ferrell
t; > > Jangita | +254 76 918383 | MSN & Y!: jang...@yahoo.com > Skype: jangita | GTalk: jangita.nyag...@gmail.com > > > > > -Original Message- > From: vokern [mailto:vok...@gmail.com] > Sent: 21 September 2010 2:38 PM > To: mysql@lists.mysql.com >

Re: document for mysql performance improvement

2010-09-21 Thread Giles Coochey
>>> >>> The disk is exactly Raid10. >>> The CPU is two 2.5G*4, totally 16G memory. >>> > > Two disks with SAS driver, 15K rpm. > RAID-10 with 2 disks? or do you mean RAID0 or RAID1??? Can't see how you would get RAID10, minimum of 6 disks for that, no? -- MySQL General Mailing List For list ar

Re: document for mysql performance improvement

2010-09-21 Thread a . smith
Quoting vokern : Two disks with SAS driver, 15K rpm. Ok so you have fast disks, but with only 2 disks it is normal you will be quite restricted by DISK IO. By adding more in multiples of 2 and stripping across all you achieve RAID1+0 and higher max IO... Andy. -- MySQL General Mail

Re: document for mysql performance improvement

2010-09-21 Thread vokern
2010/9/21 : > Quoting vokern : > >> >> The disk is exactly Raid10. >> The CPU is two 2.5G*4, totally 16G memory. >> > > And how many disks do you have, and what type (SATA/SAS/FC etc) what RPM? To > improve IO you can add more disks, or upgrade to faster disks. > > Two disks with SAS driver, 15K

Re: document for mysql performance improvement

2010-09-21 Thread vokern
Thank you all for the kind helps. I will check them and if still have problems I will come back. 2010/9/21 Machiel Richards : > > http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ > > > http://www.mysql.com/why-mysql/perfor

Re: document for mysql performance improvement

2010-09-21 Thread a . smith
Quoting vokern : The disk is exactly Raid10. The CPU is two 2.5G*4, totally 16G memory. And how many disks do you have, and what type (SATA/SAS/FC etc) what RPM? To improve IO you can add more disks, or upgrade to faster disks. -- MySQL General Mailing List For list archives: http://l

RE: document for mysql performance improvement

2010-09-21 Thread Jangita
kern [mailto:vok...@gmail.com] Sent: 21 September 2010 2:38 PM To: mysql@lists.mysql.com Subject: document for mysql performance improvement Hello, We are using mysql-5.1 with innodb engine for a web 2.0 application. But we found that the performance is not that good, i.e, the IO load sometime is

Re: document for mysql performance improvement

2010-09-21 Thread vokern
2010/9/21 : > If its an IO problem the first and easiest thing to do is (probably) look at > your disk subsystem. You can easily achieve higher disk IO by increasing the > number of disks and implementing something like RAID1+0. What is your > current disk configuration? > The disk is exactly Rai

Re: document for mysql performance improvement

2010-09-21 Thread a . smith
If its an IO problem the first and easiest thing to do is (probably) look at your disk subsystem. You can easily achieve higher disk IO by increasing the number of disks and implementing something like RAID1+0. What is your current disk configuration? Andy. -- MySQL General Mailing Li

Re: document for mysql performance improvement

2010-09-21 Thread Johan De Meersman
ubuntu server Linux, with apt-get for installing mysql. > So is there any good document for improving mysql performance? Thanks. > > Regards. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mys

Re: document for mysql performance improvement

2010-09-21 Thread vokern
Yes we have changed some arguments in my.cnf like key_buffer_size, sort_buffer_size etc. 2010/9/21 Machiel Richards : > Good day > >   There is quite a lot of documentation available for MySQL performance > management. > >     However, a quick question on this matter

document for mysql performance improvement

2010-09-21 Thread vokern
Hello, We are using mysql-5.1 with innodb engine for a web 2.0 application. But we found that the performance is not that good, i.e, the IO load sometime is high, the query is timeout. We run ubuntu server Linux, with apt-get for installing mysql. So is there any good document for improving mysql

Re: MySQL Performance with large data

2009-11-24 Thread Michael Dykman
gt; >>  _ >> >> From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De >> Meersman >> Sent: Tuesday, November 24, 2009 9:56 PM >> To: Manish Ranjan (Stigasoft) >> Cc: mysql@lists.mysql.com >> Subject: Re: MySQL Performance wi

Re: MySQL Performance with large data

2009-11-24 Thread Johan De Meersman
lto:vegiv...@gmail.com] On Behalf Of Johan De > Meersman > Sent: Tuesday, November 24, 2009 9:56 PM > To: Manish Ranjan (Stigasoft) > Cc: mysql@lists.mysql.com > Subject: Re: MySQL Performance with large data > > > > The amount and type of data is less the issue than the

RE: MySQL Performance with large data

2009-11-24 Thread Manish Ranjan (Stigasoft)
[mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Tuesday, November 24, 2009 9:56 PM To: Manish Ranjan (Stigasoft) Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance with large data The amount and type of data is less the issue than the amount and type of queries is :-) The machine

Re: MySQL Performance with large data

2009-11-24 Thread Johan De Meersman
The amount and type of data is less the issue than the amount and type of queries is :-) The machine you've described should be able to handle quite a bit of load, though, if well-tuned. On Tue, Nov 24, 2009 at 4:45 PM, Manish Ranjan (Stigasoft) < manish.ran...@stigasoft.com> wrote: > Hi, > > > >

MySQL Performance with large data

2009-11-24 Thread Manish Ranjan (Stigasoft)
Hi, I am using MySQL 5.0.45 in production environment. One of my tables (using MyISAM Engine) is expected to have around 4 billion records and each record will have 1867 bytes of data. All fields in this table are of character data type. I have 8 GB RAM on the server, RAID 5 with 750 GB storage

Re: mysql performance issue. pls help..

2009-11-17 Thread F.A.I.Z.A.L
hi all this is my innodb preference. i need to change anything for increasing the db performance.. innodb_additional_mem_pool_size --> 1048576 innodb_autoextend_increment --> 8 innodb_buffer_pool_awe_mem_mb --> 0 innodb_buffer_pool_size --> 8388608 innodb_checksums--

mysql performance issue. pls help..

2009-11-17 Thread F.A.I.Z.A.L
HI experts I am facing performance issue for last couple of months. it taking more time to execute query.. developers created tables on myIsam and Innodb. i have a doubts whether we can use both storage same time.. i have 2 thinks in my minds to check this performance. 1. to check innodb and myi

MySQL University session on February 5: MySQL Performance and Scalability Project - Issues and Opportunities

2009-01-30 Thread Stefan Hinz
MySQL Performance and Scalability Project - Issues and Opportunities http://forge.mysql.com/wiki/MySQL_Performance_and_Scalability_Project_-_Issues_and_Opportunities Next Thursday (February 5th), we're continuing our series of sessions on MySQL performance measuring and improvements with

Re: Improve MYSQL performance on large database

2008-11-09 Thread Salah Nait-Mouloud
Hello, Here, you can get some help: http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ Regards. Salah NAIT-MOULOUD www.echovox.com | www.m-boost.com On Sat, Nov 8, 2008 at 7:08 AM, Guillermo Nardoni <[EMAIL PROTECTED]>wrote: > Hello everyone,

Improve MYSQL performance on large database

2008-11-08 Thread Guillermo Nardoni
Hello everyone, good evening. This is my first time posting here and it is just for asking...!!! Well, we are building a project for our customer wich is basically a searcher, google style. We use mnoGoSearch as indexer, 3.2.27-mysql, to more specific.!. We already try lots of version even compi

MySQL performance

2008-08-20 Thread Hugo Kohmann
Hi, If you would like to improve the performance of your MySQL environment, you may consider the following information tobe of interest: The latest series of Dolphin Express drivers for Linux now also includes support for accelerated intra-node socket communications. Through the combination o

mysql performance report

2008-07-23 Thread sulochan acharya
Guys my mysqlreport says : Buffer used 205.00k of 16.00M %Used: 1.25 Current 2.04M%Usage: 12.76 Write hit 100.00% Read hit 97.90% __ Questions ___ Total 5.08k16.6/s * Com_ 2.68k

Re: FreeBSD MySQL Performance Tunning suggestions???

2008-06-04 Thread Antony T Curtis
Hi, FreeBSD 7 should offer much better performance for MySQL. The FreeBSD kernel developers have found ways to relieve some of the kernel bottlenecks which permit multithreaded applications to operate much better. Regards, Antony. On 3 Jun 2008, at 03:43, VeeJay wrote: Hi Guys I need

Re: FreeBSD MySQL Performance Tunning suggestions???

2008-06-04 Thread Joerg Bruehe
Hi all ! VeeJay wrote: [[...]] At my job, I am going to build a Web Server with 1. FreeBSD 7.0-RELEASE amd64 2. Apache 2.2.8 3. PHP 4.4.8 (or may be PHP5, what do you suggest?) Server's hardware configuration is as follow: 2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB 16GB (8x2GB Dua

Re: MySQL performance on LVM2

2008-05-21 Thread obed
ut 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 takes some ti

Re: MySQL performance on LVM2

2008-05-20 Thread Moon's Father
What is LVM? 2008/5/12 MarisRuskulis <[EMAIL PROTECTED]>: > 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 >

MySQL performance on LVM2

2008-05-12 Thread MarisRuskulis
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,

ANNOUNCE: Nagios Plugin for MySQL performance

2008-01-19 Thread Gerhard Lausser
Hi list, i wrote a plugin for the Nagios monitoring system which allows you to check some performance related aspects of a MySQL database. The -m option tells the plugin the desired mode. Possible keywords are: slave-lag (Check 'Seconds behind master') slave-io-running (C

Re: MySQL Performance Analysis tools

2007-11-20 Thread mark addison
EMAIL PROTECTED] WWW.ITN.CO.UK P Please consider the environment. Do you really need to print this email? -Original Message- |From: thomas Armstrong [mailto:[EMAIL PROTECTED] |Sent: Monday, November 19, 2007 6:42 AM |To: mysql@lists.mysql.com |Subject: MySQL Performance Analysis tools | |Hi. |

RE: MySQL Performance Analysis tools

2007-11-19 Thread Bernd Jagla
"sar" will give you some basic information about what happens on the system... (see e.g.: http://linux.die.net/man/1/sar)... -B |-Original Message- |From: thomas Armstrong [mailto:[EMAIL PROTECTED] |Sent: Monday, November 19, 2007 6:42 AM |To: mysql@lists.mysql.com |Subj

MySQL Performance Analysis tools

2007-11-19 Thread thomas Armstrong
Hi. Using MySQL on Linux, I'd like to analyze the performance and know how resources (memory, threads) are used during a period of time. Do you know any tool to carry it out? Thank you very much. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht

Re: MySQL Performance Degrades Significantly Over Time

2006-12-06 Thread Jason J. W. Williams
Hi Daniel, We were using a software RAID-5 on top of hardware RAID-5 across 3 4-disk volume groups. (1 LUN from each array volume group built the software RAID-5). So we were able to lose 3 disks in a worst case scenario. It seems to me that neither RAID-1 or RAID-5 can lose more than one disk w

Re: MySQL Performance Degrades Significantly Over Time

2006-12-04 Thread Daniel da Veiga
On 12/4/06, Jason J. W. Williams <[EMAIL PROTECTED]> wrote: Hi Daniel, Thank you very much for your help and advice. After some examination, we discovered a couple of things. It looks like our storage array layout was really bad for the IOPS MySQL was throwing at it, as a result the InnoDB trans

Re: MySQL Performance Degrades Significantly Over Time

2006-12-03 Thread Jason J. W. Williams
ime. Also, while you're at it: http://www.mysql.com/news-and-events/newsletter/2004-01/a000301.html http://dev.mysql.com/books/hpmysql-excerpts/ch06.html http://www.mysql.com/news-and-events/on-demand-webinars/mysql-performance-tuning.php Go for it. -- Daniel da Veiga Computer Operator - RS - Br

Re: MySQL Performance Degrades Significantly Over Time

2006-11-27 Thread Dan Buettner
Jason, in addition to Daniel's suggestions, I'll throw this out there: I had a somewhat similar problem with a database I used to own, where a handful of very hard-hit tables would become progressively slower over time, despite the fact that (due to daily archiving and purging) they were not grow

Re: MySQL Performance Degrades Significantly Over Time

2006-11-27 Thread Daniel da Veiga
bles that deal with thread launching, and your OS for limits on memory or cpu time. Also, while you're at it: http://www.mysql.com/news-and-events/newsletter/2004-01/a000301.html http://dev.mysql.com/books/hpmysql-excerpts/ch06.html http://www.mysql.com/news-and-events/on-demand-webinar

MySQL Performance Degrades Significantly Over Time

2006-11-27 Thread Jason J. W. Williams
Hi, We're running MySQL 5.0.27 under Solaris 10 on both Opteron and UltraSparc T1 machines. The performance on both boxes starts out great when the process is fresh, however over the course of a week of heavy use the performance degrades to the point where its nearly unusable. The Opteron has 2G

RE: MySQL Performance Question

2006-06-19 Thread Robinson, Eric
inson -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Monday, June 19, 2006 6:35 AM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance Question One reason you might be seeing a higher number of writes than reads is if MySQL is able to answer queries fro

Re: MySQL Performance Question

2006-06-19 Thread Dan Buettner
---Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Saturday, June 17, 2006 12:14 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance Question So, you're looking at 150-300 databases and ~31-62k tables based on your numbers? MySQL should be able to

RE: MySQL Performance Question

2006-06-17 Thread Robinson, Eric
ersions of the application.) --Eric -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Saturday, June 17, 2006 12:14 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance Question So, you're looking at 150-300 databases and ~31-62k table

Re: MySQL Performance Question

2006-06-17 Thread Atle Veka
So, you're looking at 150-300 databases and ~31-62k tables based on your numbers? MySQL should be able to handle that, as should your OS, but the most important part IMO is how your clients will be using their data(bases). What sort of queries, how many, etc. Will it be possible for one client to h

MySQL Performance Question

2006-06-16 Thread Robinson, Eric
Our server will be home to 50-100 separate clients. Each client will have their own set of databases that will be accessed by 10-60 users at each client's site. In terms of performance, is it better to have 1 instance of MySQL servicing multiple databases, or multiple instances of MySQL each serv

RE: mysql performance / ndb 5.1 performance

2006-05-25 Thread Moritz Möller
essage- > From: Dan Trainor [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 25, 2006 1:41 AM > To: Moritz Möller; mysql@lists.mysql.com > Subject: Re: mysql performance > > Moritz Möller wrote: >> Hi list, >> >> we're running some large high-traffic mysql

Re: mysql performance / ndb 5.1 performance

2006-05-25 Thread Jay Pipes
ler; mysql@lists.mysql.com Subject: Re: mysql performance Moritz Möller wrote: Hi list, we're running some large high-traffic mysql servers, and are currently reaching the limit of our machines. We're using mysql 4.1 / innodb on debian, ibdata is about 35GB. Hardware is quad xeon d

Re: mysql performance / ndb 5.1 performance

2006-05-25 Thread sheeri kritzer
e database on application level (use > server userID%numServers), which would be a [insert favourite non-swear-word > here] lot of work ;) > > Moritz > > > -Original Message- > From: Dan Trainor [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 25, 2006 1:41 AM > To: Mor

Re: mysql performance / ndb 5.1 performance

2006-05-24 Thread Dan Trainor
com Subject: Re: mysql performance Moritz Möller wrote: Hi list, we're running some large high-traffic mysql servers, and are currently reaching the limit of our machines. We're using mysql 4.1 / innodb on debian, ibdata is about 35GB. Hardware is quad xeon dualcore, 8 GB RA

RE: mysql performance / ndb 5.1 performance

2006-05-24 Thread Moritz Möller
on application level (use server userID%numServers), which would be a [insert favourite non-swear-word here] lot of work ;) Moritz -Original Message- From: Dan Trainor [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 1:41 AM To: Moritz Möller; mysql@lists.mysql.com Subject: Re: my

Re: mysql performance

2006-05-24 Thread Dan Trainor
Moritz Möller wrote: Hi list, we're running some large high-traffic mysql servers, and are currently reaching the limit of our machines. We're using mysql 4.1 / innodb on debian, ibdata is about 35GB. Hardware is quad xeon dualcore, 8 GB RAM. Disk-io is nearly zero, limiting factor is CPU. The

mysql performance

2006-05-24 Thread Moritz Möller
Hi list, we're running some large high-traffic mysql servers, and are currently reaching the limit of our machines. We're using mysql 4.1 / innodb on debian, ibdata is about 35GB. Hardware is quad xeon dualcore, 8 GB RAM. Disk-io is nearly zero, limiting factor is CPU. The queries run very fast (

Re: Quick Linux/MySQL performance questions. (fwd)

2006-05-12 Thread Pat Adams
On Fri, 2006-05-12 at 10:59 -0400, RV Tec wrote: > Yeah, I'm aware of that. Since glibc 2.4 has only NPTL, I was > wondering if it > is possible to MySQL use a threading system of its own. However, what > I want to > know, is a way to confirm that it has been compiled against NPTL. > > This appe

Re: Quick Linux/MySQL performance questions.

2006-05-12 Thread sheeri kritzer
SCSI channel and ideally with their own >> hardware RAID RAM cache, may reduce disk and I/O contention if your >> temp space is currently on the same disks with your data. Of course >> this will only be helpful if MySQL is actually using disk based temp >> tables during large que

Re: Quick Linux/MySQL performance questions.

2006-05-12 Thread Dan Buettner
he same disks with your data. Of course this will only be helpful if MySQL is actually using disk based temp tables during large queries - check your status output to see. I've done a lot of reading on and experimentation with MySQL performance and attended a MySQL training session on perform

Re: Quick Linux/MySQL performance questions.

2006-05-12 Thread Daniel da Veiga
MySQL is actually using > disk based temp tables during large queries - check your status output to > see. > > I've done a lot of reading on and experimentation with MySQL performance and > attended a MySQL training session on performance tuning, and have learned: > once you

Re: Quick Linux/MySQL performance questions.

2006-05-12 Thread Dan Buettner
course this will only be helpful if MySQL is actually using disk based temp tables during large queries - check your status output to see. I've done a lot of reading on and experimentation with MySQL performance and attended a MySQL training session on performance tuning, and have learned:

Re: Quick Linux/MySQL performance questions. (fwd)

2006-05-12 Thread RV Tec
1) Is there a way to see MySQL using both processors? Is SMP helpful in this case? (This server is dedicated to MySQL, only one instance). PS (*nix) should tell you how your processors are used. PS does show me about the CPU usage, but it doesnt tell me which processor, or if they're being use

Re: Quick Linux/MySQL performance questions.

2006-05-12 Thread RV Tec
e done a lot of reading on and experimentation with MySQL performance and attended a MySQL training session on performance tuning, and have learned: once you have reasonable hardware, the biggest thing you can do to improve speed is to optimize your SQL queries, indexes, and data structure. Whil

Re: Quick Linux/MySQL performance questions.

2006-05-12 Thread Barry
RV Tec schrieb: Folks, I had some recommendations about operating system last time I posted, and decided to follow it. It's been a couple of weeks running Gentoo Linux 2006.0 SMP 2.6.15-gentoo-r5, with glibc 2.4 (NPTL), gcc 3.4.4, XFS as my FS, deadline scheduler and this has proven to be rea

Quick Linux/MySQL performance questions.

2006-05-12 Thread RV Tec
Folks, I had some recommendations about operating system last time I posted, and decided to follow it. It's been a couple of weeks running Gentoo Linux 2006.0 SMP 2.6.15-gentoo-r5, with glibc 2.4 (NPTL), gcc 3.4.4, XFS as my FS, deadline scheduler and this has proven to be really stable -- MyS

Re: ~Mysql performance~

2006-04-30 Thread Mohammed Abdul Azeem
Hi, The insert queries are run from the localhost on both the machines. -Abdul On Fri, 2006-04-28 at 10:28 -0700, Atle Veka wrote: > On Fri, 28 Apr 2006, Mohammed Abdul Azeem wrote: > > > Hi, > > > > I have 2 mysql servers with version 5.0.15-standard-log running on > > redhat es4 installed on

Re: ~Mysql performance~

2006-04-30 Thread Mohammed Abdul Azeem
Hi, The Server2 is not a slave. Seperate inserts were done on two different mysql servers. Thanks, Abdul. On Fri, 2006-04-28 at 12:01 -0400, Kishore Jalleda wrote: > > > On 4/28/06, Mohammed Abdul Azeem <[EMAIL PROTECTED]> wrote: > Hi, > > I have 2 mysql servers with

Re: ~Mysql performance~

2006-04-28 Thread Atle Veka
On Fri, 28 Apr 2006, Mohammed Abdul Azeem wrote: > Hi, > > I have 2 mysql servers with version 5.0.15-standard-log running on > redhat es4 installed on 2 different geographic locations. The default > storage engine used is innodb on both the servers. I run an insert query > on both the servers tha

Re: ~Mysql performance~

2006-04-28 Thread Kishore Jalleda
On 4/28/06, Mohammed Abdul Azeem <[EMAIL PROTECTED]> wrote: Hi, I have 2 mysql servers with version 5.0.15-standard-log running on redhat es4 installed on 2 different geographic locations. The default storage engine used is innodb on both the servers. I run an insert query on both the servers t

Re: ~Mysql performance~

2006-04-28 Thread Mohammed Abdul Azeem
Hi, I would like to make one correction. The server one has 2 IDE hard disks and not SATA hard disks. Thanks, Abdul. On Fri, 2006-04-28 at 16:33 +0530, Mohammed Abdul Azeem wrote: > Hi, > > The following is the hard disk specs for both the servers: > > server one: ( whose performance is good )

Re: ~Mysql performance~

2006-04-28 Thread Mohammed Abdul Azeem
Hi, The following is the hard disk specs for both the servers: server one: ( whose performance is good ) --- class: HD bus: IDE detached: 0 device: hda driver: ignore desc: "ST3200822A" physical: 16383/16/63 logical: 24321/255/63 - class: HD bus: IDE detached: 0 device: hdb driver: ignor

Re: ~Mysql performance~

2006-04-28 Thread living liquid | Christian Meisinger
> Hi, > > I have 2 mysql servers with version 5.0.15-standard-log running on > redhat es4 installed on 2 different geographic locations. The default > storage engine used is innodb on both the servers. I run an insert query > on both the servers that inserts 25,00,000 records. first server takes >

~Mysql performance~

2006-04-28 Thread Mohammed Abdul Azeem
Hi, I have 2 mysql servers with version 5.0.15-standard-log running on redhat es4 installed on 2 different geographic locations. The default storage engine used is innodb on both the servers. I run an insert query on both the servers that inserts 25,00,000 records. first server takes 7.5 hrs, whil

Re: mysql performance problems.

2006-03-31 Thread Kishore Jalleda
As others have suggested , turn your slow query log on in my.cnf , and set your long-query_time, and you can view your slow queries in the *.log file in your data dir, and then try to optimize them, you could also try mytop ( http://jeremy.zawodny.com/mysql/mytop/) , and check your queries in real

Re: mysql performance problems.

2006-03-30 Thread Prasanna Raj
Is tat query is the problem ? Then turn on your slow queies and try optimizing those slow queries ? Post your queries and table description for further help :) --Praj On Wed, 29 Mar 2006 12:33:20 -0500 "Jacob, Raymond A Jr" <[EMAIL PROTECTED]> wrote: > > After a 23days of running mysql, I

Re: mysql performance problems.

2006-03-29 Thread walt
Jacob, Raymond A Jr wrote: After a 23days of running mysql, I have a 3GB database. When I use an application called base(v.1.2.2) a web based intrusion detection analysis console, the mysqld utilization shoots up to over 90% and stays there until the application times out or is terminated. Q

mysql performance problems.

2006-03-29 Thread Jacob, Raymond A Jr
After a 23days of running mysql, I have a 3GB database. When I use an application called base(v.1.2.2) a web based intrusion detection analysis console, the mysqld utilization shoots up to over 90% and stays there until the application times out or is terminated. Question: Have I made some err

Re: Bad MySQL performance with LEFT JOINS in combination with BIGINT(16)Keys

2005-09-21 Thread Alexey Polyakov
Looks like you don't have index on `lad_id` field in second table. So when you do the first query, mysql first does a full scan of 2nd table, then does eqref lookup for 1st table, which is rather fast operation. But when you do the left join, it scans first table and for each value of id does a sca

Re: Bad MySQL performance with LEFT JOINS in combination with BIGINT(16)Keys

2005-09-21 Thread Christofer Dutz
Ok ... here all the information I could find: CREATE TABLE `disco_lad` ( `id` bigint(16) unsigned NOT NULL auto_increment, `import_datum` date default NULL, `import_zeit` time default NULL, `gst` smallint(4) unsigned default '0', `gst_bez` varchar(40) default NULL, `betrieb` tinyint(2

Re: Bad MySQL performance with LEFT JOINS in combination with BIGINT(16) Keys

2005-09-21 Thread Devananda
Christofer Dutz wrote: Hi, I just ran into a very strange problem. I have two simple tables with BIGINT(16) PKs. The primary table has 7500 records and the secondars has 15000. If I execute: SELECT * FROM lad JOIN snd ON lad.id = snd.lad_id The query takes 8 seconds. If I execute this one:

Bad MySQL performance with LEFT JOINS in combination with BIGINT(16) Keys

2005-09-21 Thread Christofer Dutz
Hi, I just ran into a very strange problem. I have two simple tables with BIGINT(16) PKs. The primary table has 7500 records and the secondars has 15000. If I execute: SELECT * FROM lad JOIN snd ON lad.id = snd.lad_id The query takes 8 seconds. If I execute this one: SELECT * FROM lad LEFT

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

2005-09-11 Thread Josh Chamas
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]

2005-09-11 Thread Josh Chamas
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: mySQL Performance Problems - Help !!

2005-08-29 Thread Brent Baisley
If you suddenly are spiking in unauthenticated connections, you may be the target of a network attack. This could be just a random probe, you may be a random target or someone may be targeting you. Although if someone were specifically targeting you, you would probably be down. I would chec

Re: mySQL Performance Problems - Help !!

2005-08-29 Thread Xiaodong Deng
"my.cnf" add this: "skip-name-resolve" under "[mysqld]" On 8/29/05, Callum McGillivray <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm pretty new to the list, so please be kind :) > > I'm having serious problems with our core mysql server. > > We are running a Dell Poweredge 2850 with dual Xeon 3

mySQL Performance Problems - Help !!

2005-08-29 Thread Callum McGillivray
Hi all, I'm pretty new to the list, so please be kind :) I'm having serious problems with our core mysql server. We are running a Dell Poweredge 2850 with dual Xeon 3.0 processors, RAID 5 and 1Gb memory. There are 3 main databases running on this machine, one is a freeradius database, one i

Re: BLOB in mysql ----- performance issue.

2005-08-22 Thread Pooly
Hi, 2005/8/22, Kane Wilson <[EMAIL PROTECTED]>: > Thanx , as i understood , i have to keet the raw data in folders and has to > be stored that relavent file path's into mysql database, > > so can u kindly tel me , how it is possible to get the file path ( absolute > ot realtive ) of that cert

Re: BLOB in mysql ----- performance issue.

2005-08-20 Thread Pooly
2005/8/20, Kane Wilson <[EMAIL PROTECTED]>: > hi Friends, > > I have a WAP portal which is running based on mysql database. That's meant > that contents has been stored in the data base. > wallpapers , themes, ringtones, games ...etc data type as BLOB. upto now > now problems with the conten

BLOB in mysql ----- performance issue.

2005-08-19 Thread Kane Wilson
hi Friends, I have a WAP portal which is running based on mysql database. That's meant that contents has been stored in the data base. wallpapers , themes, ringtones, games ...etc data type as BLOB. upto now now problems with the content retrieving. WAP site hosted in REDHAT Linux BOX. I

  1   2   3   >