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, there are
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 digi
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.
>
[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
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
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 |
+---+---
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
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
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
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
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
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 :
>>
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
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
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
>
>>>
>>> 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
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
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
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
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
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
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
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
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
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
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
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
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
[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
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,
>
>
>
>
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
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--
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 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
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 compi
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
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,
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
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
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
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
>
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 (C
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.
|
"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
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
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
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
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
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
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
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
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
---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
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
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
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
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
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
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
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
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
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
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 (
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
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
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
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
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:
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
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
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
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
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
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
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
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
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 )
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
> 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
>
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
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
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
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
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
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
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:
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
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
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
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
"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
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
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
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
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 264 matches
Mail list logo
