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 c
John, Johnny,
Thanks for the prompt answer.
mysql> SHOW CREATE TABLE clientinfo;
++--
--
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=nul...@gmail.com
>
>
--
Alexandre Vieira - nul...@gmail.com
; 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
in set (0.53 sec)
Thanks
BR
AJ
On Thu, Sep 2, 2010 at 8:52 PM, Johnny Withers 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 wrote:
>
s total sense if you read:
http://peter-zaitsev.livejournal.com/9138.html
Thanks in advance.
BR
AJ
On Fri, Sep 3, 2010 at 2:31 PM, Johnny Withers wrote:
> Ok, so I'm stumped?
>
> What kind of hardware is behind this thing?
>
> -JW
>
> On Fri, Sep 3, 2010 at 4:44 AM, A
> What does
>
> SHOW TABLE STATUS LIKE 'table_name'
>
> Say about this table?
>
> -JW
>
>
> On Fri, Sep 3, 2010 at 8:59 AM, Alexandre Vieira wrote:
>
>> Hi,
>>
>> I've done some tests with INT(8) vs the VARCHAR(23) on the userid PK a
>
> *Johnny Withers*
> jwith...@ecashsoftware.com
> 601.919.2275 x112
> [image: eCash Software Systems]
>
>
> On Fri, Sep 3, 2010
more disks? Add faster disks?
>
> I'm not an iostat expert, use my research and recommendations with caution
> =)
>
>
> --
>
> *Johnny Withers*
> jwith...@ecashsoftware.com
> 601.919.2275 x112
> [image: eCash Software System
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 wrote:
> At 04:44 AM 9/3/2010, Alexandre Vieira w
006533, deleted 111028, read
30145300
0.17 inserts/s, 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
O
11 matches
Mail list logo
