Assuming that I have a dedicated server on which I am running multiple instances of mysql and postresql servers. How without iotop determine which instance in particular time (proc/pid/io shows data ...

I don't know why I am getting a syntax error. I have checked my query carefully many times and read up on mysql reference for load data infile and everything seems fine. Here is my query:
LOAD DATA ...

I am executing a web service for 100 times. The average response time of this service is 1.5 seconds. But when I look at the response time of each execution individually, there are a few executions ...

I am performing a load test for my application. All my SQL queries which are fired from my application, individually look better and perform fast.
The same SQL are becoming bottleneck when they are ...

I am trying to update ^G (Ctrl G) in a table, below is scenario-
CREATE TABLET TEST(COLA INT,DESCRIPTION VARCHAR(20));
I have crtl G in my data for description field, so to replace it with a \,I am ...

On a 64Bit Debian 6 OS with 4 CPU cores and 8GB RAM, I can reproduce an issue with mongostat.
Whenever I create an index, reIndex or even index in background, according to top, the CPU load is 40-60% ...