|
Home > Archive > MySQL ODBC Connector > April 2006 > Limited trafic in 5.0?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Limited trafic in 5.0?
|
|
| paulomorfeo@portugalmail.pt 2006-04-01, 8:25 pm |
| I have a program that uses MySql.
When using a MySql 5.0 server, the MySql Administrator shows in the "health"
section that the server never passes a perfectly stable limit of 9.1~9.2 KB/s of
trafic and never shows more that 1 query (per second).
Looks like some kind of configuration limitation!?
This makes my application absurdly slow. My mysql 5.0 server was installed on
windows with all default settings.
Any hints at what could be wrong and how to change it?
____________________
____________________
__________________
O email preferido dos portugueses agora com
2 000 MB de espaço e acesso gratuito à Internet
http://www.portugalmail.pt/2000mb
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| sheeri kritzer 2006-04-03, 1:29 pm |
| You might want to change those. I'm guessing your wait_timeout is set
to the default of a day. Is the application letting go of
connections? If you do a SHOW PROCESSLIST on the server, is there
really only one connection, or are there many?
-Sheeri
On 4/3/06, paulomorfeo@portugal
mail.pt < paulomorfeo@portugal
mail.pt> wrote:
> mysql> SHOW VARIABLES LIKE "max%connect%";
> +----------------------+-------+
> | Variable_name | Value |
> +----------------------+-------+
> | max_connect_errors | 10 |
> | max_connections | 100 |
> | max_user_connections
| 0 |
> +----------------------+-------+
> 3 rows in set (0.06 sec)
>
> mysql>
>
>
> Citando sheeri kritzer <awfief@gmail.com>:
>
> It's possible that you have max_connections set to something very low,
> and/or the application is not letting go of MySQL connections.
>
> What does the following show you?
>
> mysql> SHOW VARIABLES LIKE "max%connect%";
>
> -Sheeri
>
> On 4/1/06, paulomorfeo@portugal
mail.pt < paulomorfeo@portugal
mail.pt> wro=
te:
> "health"
..2[color=darkred]
> KB/s of
lled[color=darkred]
> on
om[color=darkred]
>
>
>
>
> ____________________
____________________
__________________
> Email gratuito com 2 000 MB
> Espa=E7o para guardar 1 milh=E3o de mensagens
> http://www.portugalmail.pt/2000mb
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| paulomorfeo@portugalmail.pt 2006-04-04, 11:29 am |
| Thanks for the answers!
When i do a SHOW PROCESSLIST; i get this:
#####
mysql> show processlist;
+----+------+----------------+------+---------+------+-------+------------------
+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------+----------------+------+---------+------+-------+------------------
+
| 1 | root | localhost:1116 | NULL | Query | 0 | NULL | show processlist
|
| 2 | root | localhost:1117 | NULL | Sleep | 162 | | NULL
|
| 5 | root | localhost:1132 | aa | Sleep | 89 | | NULL
|
| 6 | root | localhost:1133 | aa | Sleep | 89 | | NULL
|
| 7 | root | localhost:1134 | aa | Sleep | 0 | | NULL
|
| 8 | root | localhost:1135 | aa | Sleep | 0 | | NULL
|
+----+------+----------------+------+---------+------+-------+------------------
+
6 rows in set (0.00 sec)
mysql> show processlist;
+----+------+----------------+------+---------+------+-------+------------------
+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------+----------------+------+---------+------+-------+------------------
+
| 1 | root | localhost:1116 | NULL | Query | 0 | NULL | show processlist
|
| 2 | root | localhost:1117 | NULL | Sleep | 21 | | NULL
|
| 5 | root | localhost:1132 | aa | Sleep | 124 | | NULL
|
| 6 | root | localhost:1133 | aa | Sleep | 124 | | NULL
|
| 7 | root | localhost:1134 | aa | Sleep | 1 | | NULL
|
| 8 | root | localhost:1135 | aa | Sleep | 0 | | NULL
|
| 9 | root | localhost:1145 | NULL | Sleep | 1 | | NULL
|
+----+------+----------------+------+---------+------+-------+------------------
+
7 rows in set (0.00 sec)
#####
Does it shows anything abnormal?
How do i change that "set global max_connections=900;
"? Just execute it from the
MySql comand line?
From Mysql Administrator 1.1, i'm seeing the user root, the one i'm using, as
having 0 max connections, 0 max updates and 0 queries. Suposedly it will allow
for infinite, right? Or will global variables overcome those settings of the user?
Thanks for the help!
Citando sheeri kritzer <awfief@gmail.com>:
You might want to change those. I'm guessing your wait_timeout is set
to the default of a day. Is the application letting go of
connections? If you do a SHOW PROCESSLIST on the server, is there
really only one connection, or are there many?
-Sheeri
On 4/3/06, paulomorfeo@portugal
mail.pt < paulomorfeo@portugal
mail.pt> wrote:
> mysql> SHOW VARIABLES LIKE "max%connect%";
> +----------------------+-------+
> | Variable_name | Value |
> +----------------------+-------+
> | max_connect_errors | 10 |
> | max_connections | 100 |
> | max_user_connections
| 0 |
> +----------------------+-------+
> 3 rows in set (0.06 sec)
>
> mysql>
>
>
> Citando sheeri kritzer <awfief@gmail.com>:
>
> It's possible that you have max_connections set to something very low,
> and/or the application is not letting go of MySQL connections.
>
> What does the following show you?
>
> mysql> SHOW VARIABLES LIKE "max%connect%";
>
> -Sheeri
>
> On 4/1/06, paulomorfeo@portugal
mail.pt < paulomorfeo@portugal
mail.pt>
wrote:
> "health"
> KB/s of
installed[color=dark
red]
> on
>
>
>
>
> ____________________
____________________
__________________
> Email gratuito com 2 000 MB
> Espaço para guardar 1 milhão de mensagens
> http://www.portugalmail.pt/2000mb
>
____________________
____________________
__________________
Sabe quanto gasta com a sua ligação à Internet?
Verifique aqui: http://acesso.portugalmail.pt/contas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Kishore Jalleda 2006-04-04, 11:29 am |
| ------ =_Part_18356_1387404
.1144164308605
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
I don't see anything abnormal in your show processlist, yes you can change
the max_connections global setting from the mysql CLI, but for it to surviv=
e
restarts/reboots it has to be defined in the my.cnf file ( I guess its
my.ini for windows) .....
Kishore Jalleda
http://kjalleda.googlepages.com/
On 4/4/06, paulomorfeo@portugal
mail.pt < paulomorfeo@portugal
mail.pt> wrote:
>
> Thanks for the answers!
>
> When i do a SHOW PROCESSLIST; i get this:
> #####
> mysql> show processlist;
>
> +----+------+----------------+------+---------+------+-------+-----------=
-------
> +
> | Id | User | Host | db | Command | Time | State | Info
> |
>
> +----+------+----------------+------+---------+------+-------+-----------=
-------
> +
> | 1 | root | localhost:1116 | NULL | Query | 0 | NULL | show
> processlist
> |
> | 2 | root | localhost:1117 | NULL | Sleep | 162 | | NULL
> |
> | 5 | root | localhost:1132 | aa | Sleep | 89 | | NULL
> |
> | 6 | root | localhost:1133 | aa | Sleep | 89 | | NULL
> |
> | 7 | root | localhost:1134 | aa | Sleep | 0 | | NULL
> |
> | 8 | root | localhost:1135 | aa | Sleep | 0 | | NULL
> |
>
> +----+------+----------------+------+---------+------+-------+-----------=
-------
> +
> 6 rows in set (0.00 sec)
>
> mysql> show processlist;
>
> +----+------+----------------+------+---------+------+-------+-----------=
-------
> +
> | Id | User | Host | db | Command | Time | State | Info
> |
>
> +----+------+----------------+------+---------+------+-------+-----------=
-------
> +
> | 1 | root | localhost:1116 | NULL | Query | 0 | NULL | show
> processlist
> |
> | 2 | root | localhost:1117 | NULL | Sleep | 21 | | NULL
> |
> | 5 | root | localhost:1132 | aa | Sleep | 124 | | NULL
> |
> | 6 | root | localhost:1133 | aa | Sleep | 124 | | NULL
> |
> | 7 | root | localhost:1134 | aa | Sleep | 1 | | NULL
> |
> | 8 | root | localhost:1135 | aa | Sleep | 0 | | NULL
> |
> | 9 | root | localhost:1145 | NULL | Sleep | 1 | | NULL
> |
>
> +----+------+----------------+------+---------+------+-------+-----------=
-------
> +
> 7 rows in set (0.00 sec)
> #####
> Does it shows anything abnormal?
>
> How do i change that "set global max_connections=3D90
0;"? Just execute it
> from the
> MySql comand line?
>
> From Mysql Administrator 1.1, i'm seeing the user root, the one i'm using=
,
> as
> having 0 max connections, 0 max updates and 0 queries. Suposedly it will
> allow
> for infinite, right? Or will global variables overcome those settings of
> the user?
>
> Thanks for the help!
>
>
> Citando sheeri kritzer <awfief@gmail.com>:
>
> You might want to change those. I'm guessing your wait_timeout is set
> to the default of a day. Is the application letting go of
> connections? If you do a SHOW PROCESSLIST on the server, is there
> really only one connection, or are there many?
>
> -Sheeri
>
> On 4/3/06, paulomorfeo@portugal
mail.pt < paulomorfeo@portugal
mail.pt>
> wrote:
> wrote:
> 9.1~9.2
> installed
> http://lists.mysql.com/mysql? unsub...mail
.com
>
>
>
>
> ____________________
____________________
__________________
> Sabe quanto gasta com a sua liga=E7=E3o =E0 Internet?
> Verifique aqui: http://acesso.portugalmail.pt/contas
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql? unsub...ma
il.co=
m
>
>
------ =_Part_18356_1387404
.1144164308605--
|
|
|
|
|