慢速数据库检索 [英] slow database retrieval

问题描述

我想知道为什么我的数据库检索变得太慢......我们设置了

a新服务器（ubuntu，breezy badger）机器我们转移了所有

我们的文件从旧服务器..我们的新服务器使用华硕p5pe-vm

主板和英特尔奔腾D 3.0Ghz处理器，相比我们使用asrock主板的

旧处理器和AMD毒龙。两者都有

相同版本的mysql安装...


总结一下，两台机器都有相同的配置除了一些

硬件更改和安装的Ubuntu版本（我们在旧机器上使用了

ubuntu hoary hedgehog）。


我们问题的原因是什么？我不觉得它有点像我从我的应用程序运行我的查询的方式，因为我做的事情

在我们的旧机器上没有遇到这样的问题..此外，我试图从我的sqlyog执行查询：

ex：

select * from db_town

结果： 8872行（）在2687毫秒

在旧服务器上它应该只需要大约421毫秒


select * from diagnostics_detail

结果：42499行（）在27609毫秒

在旧服务器上它应该只需要大约4375

ms


请再次急需帮助......

恩典

解决方案

Ayon kay恩典：

i我想知道为什么我的数据库检索变得太慢...我们设置了

a新服务器（ubuntu， breezy badger）我们从旧服务器转移所有文件的机器..我们的新服务器使用As我们p5pe-vm

主板和英特尔奔腾D 3.0Ghz处理器，相比我们使用asrock主板和AMD Duron的旧b
旧处理器。两者都有

相同版本的mysql安装...


总结一下，两台机器都有相同的配置除了一些

硬件更改和安装的Ubuntu版本（我们在旧机器上使用了

ubuntu hoary hedgehog）。


我们问题的原因是什么？我不觉得它有点像我从我的应用程序运行我的查询的方式，因为我做的事情

在我们的旧机器上没有遇到这样的问题..此外，我试图从我的sqlyog执行查询：

ex：

select * from db_town

结果： 8872行（）在2687毫秒

在旧服务器上它应该只需要大约421毫秒


select * from diagnostics_detail

结果：42499行（）在27609毫秒

在旧服务器上它应该只需要大约4375

ms


请再次急需帮助...

grace

当我试过在我的旧服务器和新服务器之间进行一些比较

这里的结果是：


新服务器：

Db_town 8902行直接来自

机器：50米来自网络：2687ms

Diagnostics_detail 42511行直接来自机器：

来自网络的410ms：27609ms


OLD SERVER：

Db_town 8902行直接来自

机器：60ms来自网络：421ms

Diagnostics_detail 42511行直接来自机器：

410ms来自网络：4375ms


希望有人能帮助我...

恩典

< blockquote> ==引用恩典（zy ***** @ gmail.com）的文章

Ayon kay grace：

i我想知道为什么我的数据库检索变得太慢了...我们设置了

a新服务器（ubuntu，breezy badger）机器我们转移了所有

来自旧服务器的文件..我们的新服务器使用华硕p5pe-vm

主板和Intel Pentium D 3.0Ghz proc与我们使用asrock主板和AMD Duron的

旧版本相比，essor。两者都有

相同版本的mysql安装...


总结一下，两台机器都有相同的配置除了一些

硬件更改和安装的Ubuntu版本（我们在旧机器上使用了

ubuntu hoary hedgehog）。


我们问题的原因是什么？我不觉得它有点像我从我的应用程序运行我的查询的方式，因为我做的事情

在我们的旧机器上没有遇到这样的问题..此外，我试图从我的sqlyog执行查询：

ex：

select * from db_town

结果： 8872行（）在2687毫秒

在旧服务器上它应该只需要大约421毫秒


select * from diagnostics_detail

结果：42499行（）在27609毫秒

在旧服务器上它应该只需要大约4375

ms


请再次急需帮助...

grace

当我尝试在旧服务器和新服务器之间进行一些比较时

这里的结果是：

新服务器：

Db_town 8902行直接来自

机器：50ms from网络：2687毫秒

来自机器的Diagnostics_detail 42511行：

来自网络的410ms：27609ms

旧服务器：

Db_town 8902行直接来自

机器：60ms来自网络：421ms

Diagnostics_detail 42511行直接来自机器：

410ms来自网络：4375ms

希望有人可以帮助我...

grace

i不认为这与硬件有任何关系。

be一定要在新服务器上的所有表上运行优化表，然后

将结果发回到这里。

-

POST BY：lark with PHP News Reader

Ayon kay lark：

==引用恩典（zy ***** @ gmail.com）的文章

Ayon kay grace：

我想知道为什么我的数据库检索变得太慢...我们设置了

a新服务器（ubuntu，breezy badger）机器，我们从旧机器转移所有

我们的文件服务器..我们的新服务器使用华硕p5pe-vm

主板和英特尔奔腾D 3.0Ghz处理器，相比我们使用asrock主板和AMD Duron的旧b
旧处理器。两者都有

相同版本的mysql安装...

>

总结一下，两台机器都有相同的配置，除了一些

硬件更改和安装的Ubuntu版本（我们在旧机器上使用了

ubuntu hoary hedgehog）。

>

我们问题的原因是什么？我不觉得它有点像我从我的应用程序运行我的查询的方式，因为我做的事情

在我们的旧机器上没有遇到这样的问题..此外，我试图从我的sqlyog执行查询：

ex：

select * from db_town

结果： 8902行（）在2687毫秒

在旧服务器上它应该只需要大约421毫秒

>

select * from diagnostics_detail

结果：42499行（）在27609毫秒

在旧服务器上它应该只需要大约4375

ms

>

请再次急需帮助...

grace

当我试过在我的旧服务器和新服务器之间进行一些比较

这里的结果是：

新服务器：

Db_town 8902行直接来自

机器：距离n 50ms etwork：2687ms

Diagnostics_detail 42511行直接来自机器：

410ms来自网络：27609ms

旧服务器：

Db_town 8902行直接来自

机器：60ms来自网络：421ms

Diagnostics_detail 42511行直接来自机器：

来自网络的410ms：4375ms

希望有人可以帮助我...

恩典

i不认为这与此有任何关系硬件。

一定要在新服务器的所有表上运行优化表，然后

将结果发回到这里。

-

POST BY：lark with PHP News Reader

tnx for the advice ...

is在数据库处于活动状态时运行优化表是否正常？ -

意味着用户使用它？可以肯定我打算这样做

以后当他们确定完成它时...结果，我会告知

you..tnx more

i am wondering why my database retrieval becomes too slow...we set up
a new server (ubuntu, breezy badger) machine where we transferred all
our files from the old server.. Our new server uses Asus p5pe-vm
motherboard and an Intel Pentium D 3.0Ghz processor, compared to the
old one where we uses asrock motherboard and AMD Duron. Both has the
same version of mysql installed...

To summarized, both machine has the same configuration except for some
hardware changes and the version of the Ubuntu installed (we used
ubuntu hoary hedgehog on the old machine).

what would be the cause of our problem? i don''t thnk it has someting
to do with the way i run my queries from my applications since i do
not encounter such problems on our old machine..Also i tried to
execute queries from my sqlyog :
ex:
select * from db_town
result: 8902 rows() in 2687 ms
where on the old server it should take only about 421 ms

select * from diagnostics_detail
result: 42499 rows() in 27609 ms
where on the old server it should take only about 4375
ms

Please please need again ur urgent help...
grace

解决方案

Ayon kay grace:

i am wondering why my database retrieval becomes too slow...we set up
a new server (ubuntu, breezy badger) machine where we transferred all
our files from the old server.. Our new server uses Asus p5pe-vm
motherboard and an Intel Pentium D 3.0Ghz processor, compared to the
old one where we uses asrock motherboard and AMD Duron. Both has the
same version of mysql installed...

To summarized, both machine has the same configuration except for some
hardware changes and the version of the Ubuntu installed (we used
ubuntu hoary hedgehog on the old machine).

what would be the cause of our problem? i don''t thnk it has someting
to do with the way i run my queries from my applications since i do
not encounter such problems on our old machine..Also i tried to
execute queries from my sqlyog :
ex:
select * from db_town
result: 8902 rows() in 2687 ms
where on the old server it should take only about 421 ms

select * from diagnostics_detail
result: 42499 rows() in 27609 ms
where on the old server it should take only about 4375
ms

Please please need again ur urgent help...

grace

when i tried to do some comparisons between my old and my new server
here''s the outcome:

NEW SERVER:
Db_town 8902 rows direct from
machine: 50ms from network: 2687ms
Diagnostics_detail 42511 rows direct from machine:
410ms from network: 27609ms

OLD SERVER:
Db_town 8902 rows direct from
machine: 60ms from network: 421ms
Diagnostics_detail 42511 rows direct from machine:
410ms from network: 4375ms

hope someone could help me...
grace

== Quote from grace (zy*****@gmail.com)''s article

Ayon kay grace:

i am wondering why my database retrieval becomes too slow...we set up
a new server (ubuntu, breezy badger) machine where we transferred all
our files from the old server.. Our new server uses Asus p5pe-vm
motherboard and an Intel Pentium D 3.0Ghz processor, compared to the
old one where we uses asrock motherboard and AMD Duron. Both has the
same version of mysql installed...

To summarized, both machine has the same configuration except for some
hardware changes and the version of the Ubuntu installed (we used
ubuntu hoary hedgehog on the old machine).

what would be the cause of our problem? i don''t thnk it has someting
to do with the way i run my queries from my applications since i do
not encounter such problems on our old machine..Also i tried to
execute queries from my sqlyog :
ex:
select * from db_town
result: 8902 rows() in 2687 ms
where on the old server it should take only about 421 ms

select * from diagnostics_detail
result: 42499 rows() in 27609 ms
where on the old server it should take only about 4375
ms

Please please need again ur urgent help...
grace

when i tried to do some comparisons between my old and my new server
here''s the outcome:
NEW SERVER:
Db_town 8902 rows direct from
machine: 50ms from network: 2687ms
Diagnostics_detail 42511 rows direct from machine:
410ms from network: 27609ms
OLD SERVER:
Db_town 8902 rows direct from
machine: 60ms from network: 421ms
Diagnostics_detail 42511 rows direct from machine:
410ms from network: 4375ms
hope someone could help me...
grace

i don''t think this has anything to do with hardware.
be sure to run optimize table on all of your tables in the new server and then
post the results back in here.
--
POST BY: lark with PHP News Reader

Ayon kay lark:

== Quote from grace (zy*****@gmail.com)''s article

Ayon kay grace:

i am wondering why my database retrieval becomes too slow...we set up
a new server (ubuntu, breezy badger) machine where we transferred all
our files from the old server.. Our new server uses Asus p5pe-vm
motherboard and an Intel Pentium D 3.0Ghz processor, compared to the
old one where we uses asrock motherboard and AMD Duron. Both has the
same version of mysql installed...
>
To summarized, both machine has the same configuration except for some
hardware changes and the version of the Ubuntu installed (we used
ubuntu hoary hedgehog on the old machine).
>
what would be the cause of our problem? i don''t thnk it has someting
to do with the way i run my queries from my applications since i do
not encounter such problems on our old machine..Also i tried to
execute queries from my sqlyog :
ex:
select * from db_town
result: 8902 rows() in 2687 ms
where on the old server it should take only about 421 ms
>
select * from diagnostics_detail
result: 42499 rows() in 27609 ms
where on the old server it should take only about 4375
ms
>
Please please need again ur urgent help...
grace

when i tried to do some comparisons between my old and my new server
here''s the outcome:
NEW SERVER:
Db_town 8902 rows direct from
machine: 50ms from network: 2687ms
Diagnostics_detail 42511 rows direct from machine:
410ms from network: 27609ms
OLD SERVER:
Db_town 8902 rows direct from
machine: 60ms from network: 421ms
Diagnostics_detail 42511 rows direct from machine:
410ms from network: 4375ms
hope someone could help me...
grace

i don''t think this has anything to do with hardware.
be sure to run optimize table on all of your tables in the new server and then
post the results back in here.
--
POST BY: lark with PHP News Reader

tnx for the advice...
is it alright to run ''optimize table'' while the database is active? -
meaning while users are using it? to be sure i am planning to do it
later when they are sure done with it..any results, i would inform
you..tnx much

这篇关于慢速数据库检索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！