Re: iostats per mysql process

2009-07-14 Thread Xuekun Hu
iopp but that need >2.6.20 kernel support On Wed, Jul 15, 2009 at 12:32 PM, wrote: > Does anyone has any suggestions on how to get IO stats used by per process > (mysqld) on Linux 2.6.18-53 kernel ... I just need to seeĀ  how much reads and > writes mysql is actually doing and what else is causi

ANSI Isolation Level vs. InnoDB consistent read implementation

2009-07-07 Thread Xuekun Hu
Hi, Guys I think I got puzzled about the transaction isolation level and the InnoDB consistent read implementation. My understanding about the ANSI isolation level are: 1. READ-COMMITTED is to protect against Lost Updates, Dirty Reads, and NOT protect against Nonrepeatable Reads and Phantoms. 2.

Re: MySQL TPC benchmark

2008-10-13 Thread Xuekun Hu
You may try DBT2 (TPC-C like) workload. On Sat, Oct 11, 2008 at 6:31 AM, Sachin Gaikwad <[EMAIL PROTECTED]> wrote: > On Fri, Oct 10, 2008 at 6:29 PM, Martin Gainty <[EMAIL PROTECTED]> wrote: >> Hello Sachin >> >> have you looked at using Benchmark Suite? >> http://dev.mysql.com/doc/refman/5.0/en/m

Re: Slow mysql connections

2008-08-13 Thread Xuekun Hu
You should run into out of memory scenaria. OS is keeping to free some memory that delay mysql connection. On 8/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens <[EMAIL PROTECTED]> wrote: > > > Do you have any other services running on th

Re: innodb_buffer_pool_size on 16 GB machine

2008-07-24 Thread Xuekun Hu
entioned getting rid of myisam configuration values might help. > Which ones would that be? > > Regards > Dominik > > Xuekun Hu wrote: > > I can alloc 14GB to innodb_buffer_pool_size, even 15GB on my 16GB > > system. However I used mysql6.0, not mysql5.0. Ma

Re: innodb_buffer_pool_size on 16 GB machine

2008-07-24 Thread Xuekun Hu
I can alloc 14GB to innodb_buffer_pool_size, even 15GB on my 16GB system. However I used mysql6.0, not mysql5.0. Maybe you can try newer mysql version. Thx, Xuekun On 7/24/08, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi, > U can use max of 80% of your Memory to Mysql, as OS needs the remaning. >

Re: how to obtain development source tree behind a firewall

2007-12-18 Thread Xuekun Hu
Seems like no way to get directly from development tree behind a firewall. :-) On 12/19/07, Chris <[EMAIL PROTECTED]> wrote: > Xuekun Hu wrote: > > Hi, guys > > > > I am behind a firewall, and have to use http proxy. However seems like > > the free bitkeeper c

how to obtain development source tree behind a firewall

2007-12-18 Thread Xuekun Hu
Hi, guys I am behind a firewall, and have to use http proxy. However seems like the free bitkeeper client (http://www.bitmover.com/bk-client2.0.shar) doesn't support HTTP proxy. export http_proxy=http://xxx:xx/ ./bkf clone http://mysql.bkbits.net/mysql-5.1 mysql-5.1 Bad URL does anyone have a so