Hi,
We're chaning it to INT(9). Apparently someone remembered to change the type
of data in this field from an alphanumeric value to an INT(9).
I'm going to change this asap.
Thanks
BR
AJ
On Mon, Sep 6, 2010 at 5:17 AM, mos mo...@fastmail.fm wrote:
At 04:44 AM 9/3/2010, Alexandre Vieira
, 18.49 updates/s, 0.00 deletes/s, 41.47 reads/s
If nothing else can be done I'll advise the client to acquire new HW for
this BD.
By the way, upgrading from 5.0.45-log to 5.1.50 would make a huge difference
in terms of performance?
BR
AJ
On Mon, Sep 6, 2010 at 10:46 AM, Alexandre Vieira nul
sec)
Thanks
BR
AJ
On Thu, Sep 2, 2010 at 8:52 PM, Johnny Withers joh...@pixelated.net wrote:
What about an explain of this query:
SELECT * FROM clientinfo WHERE userid='182106617';
-JW
On Thu, Sep 2, 2010 at 9:35 AM, Alexandre Vieira nul...@gmail.com wrote:
John, Johnny,
Thanks
:
http://peter-zaitsev.livejournal.com/9138.html
Thanks in advance.
BR
AJ
On Fri, Sep 3, 2010 at 2:31 PM, Johnny Withers joh...@pixelated.net wrote:
Ok, so I'm stumped?
What kind of hardware is behind this thing?
-JW
On Fri, Sep 3, 2010 at 4:44 AM, Alexandre Vieira nul...@gmail.com wrote
wrote:
What does
SHOW TABLE STATUS LIKE 'table_name'
Say about this table?
-JW
On Fri, Sep 3, 2010 at 8:59 AM, Alexandre Vieira nul...@gmail.com wrote:
Hi,
I've done some tests with INT(8) vs the VARCHAR(23) on the userid PK and
it makes a little difference but not enough
601.919.2275 x112
[image: eCash Software Systems]
On Fri, Sep 3, 2010 at 9:20 AM, Alexandre Vieira nul...@gmail.com wrote:
Hi,
mysql SHOW TABLE STATUS LIKE 'clientinfo
not an iostat expert, use my research and recommendations with caution
=)
--
*Johnny Withers*
jwith...@ecashsoftware.com
601.919.2275 x112
[image: eCash Software Systems]
On Fri, Sep 3, 2010 at 10:37 AM, Alexandre Vieira nul...@gmail.comwrote:
Hi,
The DB
Hi list,
I'm having some performance problems on my 5.0.45-log DB running on Solaris
8 (V240).
We only have one table and two apps selecting, updating, inserting and
deleting massively and randomly from this table.
The table is very simple. All SELECTs,INSERTs,UPDATEs and DELETEs have only
one
John, Johnny,
Thanks for the prompt answer.
mysql SHOW CREATE TABLE clientinfo;
4:46 p, Alexandre Vieira wrote:
John, Johnny,
Thanks for the prompt answer.
...
We also run some other applications in the server, but nothing that
consumes
all the CPU/Memory. The machine has almost 1GB of free memory and 50% of
idle CPU time at any time.
TIA
BR
Alex
Increase
for your
delete queries?
DELETE FROM clientinfo WHERE units='155618918';
-Original Message-
From: Alexandre Vieira [mailto:nul...@gmail.com]
Sent: Thursday, September 02, 2010 8:46 AM
To: John Daisley; joh...@pixelated.net
Cc: mysql@lists.mysql.com
Subject: Performance problems on MySQL
11 matches
Mail list logo