ing help with the following:
>>> - what's the best way to run such a script without affecting the DB server
>>> performance?
>>>Should i limit the script to implement N number of records at a time?
>>>and then sleep or is there a better way?
>&g
e 2.4 seconds?
i'm seeking help with the following:
- what's the best way to run such a script without affecting the DB server
performance?
Should i limit the script to implement N number of records at a time?
and then sleep or is there a better way?
- What's the best practice of h
ple
sounds like a bad design without key
how can 30 updates take 2.4 seconds?
> i'm seeking help with the following:
> - what's the best way to run such a script without affecting the DB server
> performance?
> Should i limit the script to implement N number of recor
ffecting the DB server
performance? Should i limit the script to implement N number of records at a
time? and then sleep or is there a better way?
- What's the best practice of handling errors and warnings in such a situation?
- How can i prevent the runtime errors and mysql locks?
Any help wit
om
Subject: [SPAM] RE: mySql versus Sql Server performance
Importance: Low
It's not much, but the dataset is definitely larger than your buffer pool. You
could try this query to show how much data+index is in innodb: SELECT
SUM(data_length+index_length) as data size FROM INFORMATION_SCHE
size=
I don't have a much experience running mysql on windows; I think much more time
is spent optimizing the server performance on linux based systems rather than
windows.
-Original Message-
From: Patrick Thompson [mailto:patrick.thomp...@channelintelligence.com]
Sent: Monday, Octo
ySql versus Sql Server performance
Here's the innodb stuff - although the largest data set I've used in the stats
run is around 20MB, which doesn't seem like much to me.
'innodb_adaptive_hash_index', 'ON'
'innodb_additional_mem_pool_size', '2097
'0'
'innodb_mirrored_log_groups', '1'
'innodb_open_files', '300'
'innodb_rollback_on_timeout', 'OFF'
'innodb_stats_on_metadata', 'ON'
'innodb_support_xa', 'ON'
'innodb_sync_spin_loops
son [mailto:patrick.thomp...@channelintelligence.com]
Sent: Monday, October 25, 2010 12:31 PM
To: Gavin Towey; mysql@lists.mysql.com
Subject: RE: mySql versus Sql Server performance
Query:
SELECT *
FROM Item
WHERE CollectionID = 'a0d3937b-f5a8-0640-dec8-bdd60f7f4775' AND
Ext
list.com/> - everything you could possibly want (to buy)
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Monday, October 25, 2010 3:53 PM
To: Patrick Thompson; gto...@ffn.com; mysql@lists.mysql.com
Subject: [SPAM] RE: mySql versus Sql Server performance
Importance: Low
Patrick-
you'll w
on of the same problems.
Patrick
myList - everything you could possibly want (to buy)
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Monday, October 25, 2010 2:00 PM
To: Patrick Thompson; mysql@lists.mysql.com
Subject: RE: mySql versus Sql Server performance
MySQL
l@lists.mysql.com
Subject: mySql versus Sql Server performance
I am running an open source project that provides an abstraction layer over a
number of different stores. I am puzzled by performance numbers I am seeing
between mysql and sql server - a brief discussion is available here
http://cipl.co
list.com/> - everything you could possibly want (to buy)
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Monday, October 25, 2010 9:55 AM
To: Patrick Thompson
Cc: mysql@lists.mysql.com
Subject: Re: mySql versus Sql Server performance
I merely skimmed it, but y
I merely skimmed it, but your comment that you pay the query compilation
cost on every request suggests to me that you're not using prepared
statements. If you can, you should :-)
Also, MySQL *does* support SPs, from 5.0 onwards or something. You could
split into separate modules for pre- and post
I am running an open source project that provides an abstraction layer over a
number of different stores. I am puzzled by performance numbers I am seeing
between mysql and sql server - a brief discussion is available here
http://cipl.codeplex.com/wikipage?title=Data%20Provider%20Comparison
The
Jerry Schwartz wrote:
> From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
> Sent: Friday, January 15, 2010 8:03 AM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
> performance
>
> Jerry Schwa
>Dear Jerry,
>
>OH
>32 Bit php is good for working with 64 Bit MySQL ?
>
[JS] Yes, it's fine. Remember, MySQL is a server - it doesn't care who is on
the other end, so long as the queries are properly formed.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farming
Jerry Schwartz wrote:
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Friday, January 15, 2010 8:03 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
BTW, would you mind to
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Friday, January 15, 2010 8:03 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
BTW, would you mind to tell me which newer
Jerry Schwartz wrote:
>>BTW, would you mind to tell me which newer version of php and mysql are
>>you running now ?
>>Due to I want to download a version of them and do the test under win2003...
>>Then, I want to tell(reply) you the result(stable)!
>>
>>
>[JS] PHP 5.2.10, Apache 2.2.14 (Win32)
>-Original Message-
>From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
>Sent: Sunday, January 03, 2010 2:13 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Dear Jerry,
>
>Sorry...
>I just visit www.php.net...
>BUT I don't quite understanding the online manual:
>http://www.php.net/man
>Dear Jerry,
>
>Would you mind to tell me how to update ( what tool/editor ) all of your
>php source code for using with your new version of php and mysql ?
>
[JS] If I had one, I would do it. I've been using an editor named Textpad for
a very, very long time but despite its many features I wouldn
Jerry Schwartz wrote:
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Tuesday, December 29, 2009 10:35 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
Dear Jerry,
Sorry
Jerry Schwartz wrote:
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Tuesday, December 29, 2009 10:35 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
Dear Jerry,
Sorry
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Tuesday, December 29, 2009 10:35 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
Dear Jerry,
Sorry, did you suggest to use
Jerry Schwartz wrote:
>>Dear Jerry,
>>
>>Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ?
>>
>>
>[JS] No, I am not saying that. The system I inherited was running 5.x, and I
>have not had the time nor urgent need to move upwards. There are some
>incompatibilities that I would have to dea
>Dear Jerry,
>
>Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ?
[JS] No, I am not saying that. The system I inherited was running 5.x, and I
have not had the time nor urgent need to move upwards. There are some
incompatibilities that I would have to deal with. For example, although short
ta
Jerry Schwartz wrote:
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Monday, December 28, 2009 9:25 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
-Original Message
From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
Sent: Monday, December 28, 2009 9:25 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
performance
Jerry Schwartz wrote:
-Original Message-
From: Edward S.P
Jerry Schwartz wrote:
>>-Original Message-
>>From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
>>Sent: Thursday, December 17, 2009 7:25 AM
>>To: mysql@lists.mysql.com
>>Subject: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
>>performanc
>-Original Message-
>From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
>Sent: Thursday, December 17, 2009 7:25 AM
>To: mysql@lists.mysql.com
>Subject: 32bit ( php + mysql server ) on 64bit Windows 2003 Server
>performance
>
>Dear all,
>
>Would you mind
Dear all,
Would you mind to give me the suggestion ?
I want to use 32bit php and mysql server on 64bit Windows 2003 Server...
So, is it possible ( good for work also ) ?
Thanks !
Edward.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Hello,
I use a mysql server on red hat 9 linux box with PIII 733 Mhz cpu and
256 MB memory. On this machine we use an adserver with a mysql
backend. All click and view logs are kept in mysql tables. The number
of the advertisements are increasing and so do the server's overhead.
Some times I can n
ing a 'show tables'
when a database instance is heavily loaded.
Kevin Cowley
R&D
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
> -Original Message-
> From: Ender Güler [mailto:[EMAIL PROTECTED]
> Sent: 25 Januar
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I use a mysql server on red hat 9 linux box with PIII 733 Mhz cpu and
256 MB memory. On this machine we use an adserver with a mysql
backend. All click and view logs are kept in mysql tables. The number
of the advertisements are increasing and s
Well I probably can tweak the queries, but there are a LOT of them. It
is for http://www.ecommstats.com so we get a TON of requests that have
to processed with probably ~20 queries (selects, inserts, updates), then
there is a maintenance program that runs every few minutes to clean
things up a
On Tue, Oct 21, 2003 at 08:59:31PM -0600, Travis Reeder wrote:
> It seems mostly to be mysql pinned, not the app. like 99% mysql until
> all data is processed and keeps going up when data coming in is more
> than can be processed.
So MySQL is using 99% of the CPU?
Any idea why? Are you doing
Would innodb tables help?
Travis
Daniel Kasak wrote:
Travis Reeder wrote:
It seems mostly to be mysql pinned, not the app. like 99% mysql until
all data is processed and keeps going up when data coming in is more
than can be processed.
What could I change in my.cnf to get better performance
I have several queries that are taking at least a full minute to process...
From a web page, user submits parameters to a perl program which performs
multiple queries, then spits the info out formatted for the web.
Does anyone have a quick & dirty method of locating a bottle neck slowing
these
Travis Reeder wrote:
It seems mostly to be mysql pinned, not the app. like 99% mysql until
all data is processed and keeps going up when data coming in is more
than can be processed.
What could I change in my.cnf to get better performance? I just have
a default mysql install (4.0).
Travis
F
It seems mostly to be mysql pinned, not the app. like 99% mysql until
all data is processed and keeps going up when data coming in is more
than can be processed.
What could I change in my.cnf to get better performance? I just have a
default mysql install (4.0).
Travis
Daniel Kasak wrote:
Travis Reeder wrote:
So I think these are the only options, but if someone has another idea
I'd be glad to hear it. Our current server just isn't handling the
load anymore so, it has single processor
Option 1:
Single server with dual processor and change from IDE to SCSI
Option 2:
One s
So I think these are the only options, but if someone has another idea
I'd be glad to hear it. Our current server just isn't handling the load
anymore so, it has single processor
Option 1:
Single server with dual processor and change from IDE to SCSI
Option 2:
One server with mysql on it
On Mon, Mar 04, 2002 at 03:06:46PM -0500, [EMAIL PROTECTED] wrote:
> I am currently implementing a database-ran webserver dll:
> Info:
> Ms Visual C++
> MySQL ++ 1.7.1
> MySQL-nt 3.23.47
> MyISAM db.
> 3or 4 Queries in the application
>
> Biggest Query:
> 66,000 records
> using LIKE "something%"
I am currently implementing a database-ran webserver dll:
Info:
Ms Visual C++
MySQL ++ 1.7.1
MySQL-nt 3.23.47
MyISAM db.
3or 4 Queries in the application
Biggest Query:
66,000 records
using LIKE "something%"
Question:
I am currently using a connection every time I query, but since this is a
stat
45 matches
Mail list logo