Bug #27043 Slow Response when many people select one table in same time
Submitted: 12 Mar 2007 11:45 Modified: 17 May 2011 8:44
Reporter: hady ginanjar Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:4.0.13 OS:Windows (windows)
Assigned to: CPU Architecture:Any
Tags: -

[12 Mar 2007 11:45] hady ginanjar 
Description:
Dear MySql Team,

I really need your help, i always get slowly reponse table where many people SELECT in same table and same time, any mistake with my code ? pls help. i use VB 6.0

Tks
Hady

How to repeat:
-

Suggested fix:
-
[12 Mar 2007 12:08] Valeriy Kravchuk 
Thank you for a problem report. Please, try to use newer version, 4.0.27 at least. In case of the same problem, please, send your my.init file content and SHOW FULL PROCESSLIST results for the moment when you have this slow response.
[14 Mar 2007 5:08] hady ginanjar 
Dear MySql,

This is my.ini : 

# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
# 
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
# The MySQL server
[mysqld]
basedir = d:/mysql/
datadir = d:/mysql/data/
max_connections=1000
[WinMySQLAdmin]
Server=D:/mysql/bin/mysqld-nt.exe

Any mistake ?

Thanks 

Hady
[14 Mar 2007 14:12] Valeriy Kravchuk 
Nothing wrong in your my.ini (although default values for most parameters are usually not good for servers with up to 1000 concurrent connections). But SHOW FULL PROCESSLIST results under the load you described are still needed.
[15 Mar 2007 2:07] hady ginanjar 
Dear Mysql,

Sory, what you mean SHOW FULL PROCESSLIST is in mysql control center process list ? how to sebd it ? 

Tks
Hady
[15 Mar 2007 8:16] hady ginanjar 
Show Process List

Attachment: Process List.txt (text/plain), 332.47 KiB.
[30 May 2007 13:51] Valeriy Kravchuk 
What exact SELECT from your processlist is a problematic one? Pleasem send the results of:

EXPLAIN SELECT marker_ratio.KPNo, marker_ratio.Shell_Name, marker_ratio.Size, qccut.Shell_Name shellcut, qccut.OutPut FROM marker_ratio left JOIN qccut ON (marker_ratio.Size = qccut.Size) AND (marker_ratio.KPNo = qccut.KPNo) AND (marker_ratio.shell_name = qccut.shell_name) WHERE marker_ratio.kpno='ADIN061485' and marker_ratio.size=' 50' group by marker_ratio.kpno,marker_ratio.shell_name,marker_ratio.size\G

That query is used more than once, it seems.
[30 Jun 2007 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[7 Apr 2011 6:17] A viji 
Dear Support

I am using VB 6.0 with Mysql. When i run my EXE the login form came after 3 minutes later. Is there any solution to reduce the time delay.
[17 Apr 2011 8:44] Valeriy Kravchuk 
FYI, this is not a proper place to ask for help with a problem that probably has nothing in common with the original bug report.
[17 May 2011 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".