Thanks all for the suggestions. I *think* I've finally figured it out.
At the end of the day I think it was because the new drives were formatted
with ext3. I recreated them in ext2 and performance is back to where it was
on those queries..
I hadn't realised that ext3 would give that much of a de
On Mon, July 21, 2008 09:14, Brent Baisley wrote:
> Copying 5GB files shows you what kind of performance you would get for
> working with say video, or anything with large contiguous files.
> Database access tends to be random, so you want a drive with faster
> random access, not streaming speed. T
At 11:14 AM 7/21/2008, you wrote:
Copying 5GB files shows you what kind of performance you would get for
working with say video, or anything with large contiguous files.
Database access tends to be random, so you want a drive with faster
random access, not streaming speed. Try copying thousands o
Copying 5GB files shows you what kind of performance you would get for
working with say video, or anything with large contiguous files.
Database access tends to be random, so you want a drive with faster
random access, not streaming speed. Try copying thousands of small
files and compare the speeds
Possibly..
top - 07:52:58 up 18:04, 3 users, load average: 4.98, 4.09, 3.20
Tasks: 165 total, 3 running, 162 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0% us, 0.0% sy, 100.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0%
si
Cpu1 : 0.0% us, 0.3% sy, 0.0% ni, 0.0% id, 96.3% wa, 0.7% hi, 2.7%
when you run this update, what is the IO WAIT from the top command.
regards
anandkl
On 7/21/08, Phil <[EMAIL PROTECTED]> wrote:
>
> Nothing else running and no queries go against that table, it's effectively
> created just for this, so I would expect the table lock.
>
> Show (full) processlist
Nothing else running and no queries go against that table, it's effectively
created just for this, so I would expect the table lock.
Show (full) processlist has nothing but this running..
Confirmed the faster disks by copying 5Gb files between two of the same type
of disk (I installed two of them
Is there any other job running while the update is happening. Because,
myisam does a table level lock. Please check the "show full processlist".
Also run mysqladmin -uroot -pxxx status. This would write lock information
into the machine.err log file. Check in this file also if there is any
locking
Hi All,
Given a fairly simple table as follows
CREATE TABLE `common_userx2` (
`t_proj` char(6) default NULL,
`t_id` int(11) NOT NULL default '0',
`t_nick` varchar(50) character set latin1 collate latin1_bin NOT NULL
default '',
`t_country` varchar(50) NOT NULL default '',
`t_cpid` varc
