RE: Too slow speed of SELECT in mySQL 4.1 alpha (0.2s delay) - jbon...@sola.com.au - com.mysql.lists.win32

2 messages in com.mysql.lists.win32RE: Too slow speed of SELECT in mySQL...

From	Sent On	Attachments
Stepan V. Borodulin	15 Aug 2003 04:37
jbon...@sola.com.au	17 Aug 2003 17:21

Subject:	RE: Too slow speed of SELECT in mySQL 4.1 alpha (0.2s delay)
From:	jbon...@sola.com.au (jbon...@sola.com.au)
Date:	08/17/2003 05:21:37 PM
List:	com.mysql.lists.win32

Doesn't sound like an unreasonable network delay to me. Anything else happening on your network? It's probably nothing to do with MySQL.

John Bonnett

-----Original Message----- From: Stepan V. Borodulin [mailto:fore...@konservator.ru] Sent: Friday, 15 August 2003 9:08 PM To: win...@lists.mysql.com Subject: Too slow speed of SELECT in mySQL 4.1 alpha (0.2s delay)

Hello all,

Can anybody tell me something about such problem?

MySQL running with InnoDB on P4 2800MHz 800MHz FSB, 2GB RAM (1GB InnoDB memory). Database is not so big - <400MB with all indexes, i.e. all database is in RAM.

All updates and inserts take <0.001s.

But queries such as SELECT * FROM ... (very small table), SHOW TABLES etc. takes approximately 0.2s.

If client is connected to localhost, not from LAN, SELECTs take <0.001s.

Queries with summing and filtering, issued on big tables (more 150000 records, more 50MB of data), take time_at_localhost+0.2s :)))

We cann't find any reasons for this 0.2s delay.