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
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
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
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
[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
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.
The
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
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
performance
Can you show us the output of: show status like '%innodb%'
JW
On Tue, Sep 21, 2010 at 10:11 PM, vokern vok...@gmail.com 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/23 Johnny Withers joh...@pixelated.net
Can you show us the output of: show status like '%innodb%'
JW
Sure.
mysql show status like '%innodb%';
+---++
| Variable_name | Value |
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
Yes we have changed some arguments in my.cnf like key_buffer_size,
sort_buffer_size etc.
2010/9/21 Machiel Richards machiel.richa...@gmail.com:
Good day
There is quite a lot of documentation available for MySQL performance
management.
However, a quick question on this matter
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/mysql?unsub=vegiv...@tuxera.be
--
Bier met grenadyn
Is als
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
2010/9/21 a.sm...@ukgrid.net:
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
[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 high
Quoting vokern vok...@gmail.com:
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
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 machiel.richa...@gmail.com:
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
http://www.mysql.com/why-mysql/performance
2010/9/21 a.sm...@ukgrid.net:
Quoting vokern vok...@gmail.com:
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
Quoting vokern vok...@gmail.com:
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.
--
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 archives:
| 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
Subject: document for mysql performance improvement
Hello,
We are using mysql-5.1
Quoting Johan De Meersman vegiv...@tuxera.be:
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
On Tue, Sep 21, 2010 at 4:03 PM, a.sm...@ukgrid.net wrote:
Quoting Johan De Meersman vegiv...@tuxera.be:
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
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 vegiv...@tuxera.bewrote:
On Tue, Sep 21, 2010 at 4:03 PM, a.sm...@ukgrid.net wrote:
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 :-)
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
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 vok...@gmail.com:
This is piece of the setting in my.cnf:
set-variable = innodb_buffer_pool_size=4G
set-variable =
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
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,
I am
[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
, 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 you've described should be able to handle quite
a
bit of load
)
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 you've described should be able to handle quite
a
bit of load, though, if well-tuned.
On Tue, Nov 24, 2009 at 4
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
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-- ON
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 Allan
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,
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
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
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
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
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
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 time. I think better solution is to use LVM
snapshots, but this performance decrease really scares
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
performance?
Now we are backuping
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
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
]
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.
|
|Using MySQL
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:
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
|Subject: MySQL
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
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
://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 - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V
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
, 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-webinars/mysql-performance-tuning.php
Go
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
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 handle that, as should your OS, but the
most important part IMO
-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 from
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
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 tables based on your
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
%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: mysql performance
Moritz Möller wrote
; 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 dualcore, 8 GB
), but still, every 2-3 days
the slaves got completely out of sync (duplicate key and other) :(
Moritz
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 6:37 PM
To: Moritz Möller
Cc: 'Dan Trainor'; mysql@lists.mysql.com
Subject: Re: mysql performance
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
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
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: mysql
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 RAM. Disk-io is nearly
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 --
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
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. While
improving your hardware can
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
. 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 performance tuning, and have
learned: once
.
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 have reasonable hardware, the biggest thing you can do to improve
speed is to optimize your SQL queries, indexes, and data structure
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: once you have
.
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 have reasonable hardware, the
biggest thing you can do to improve speed is to optimize your SQL
queries, indexes, and data structure
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 appears on
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 version
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 2
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,
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
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: ignore
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 )
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
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 that
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
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 have
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
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.
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
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:
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`
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
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
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
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
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.0 processors,
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
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 certain
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 content
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 - 100 of 254 matches
Mail list logo