Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

数据库分离后远程mysql主页面打开很慢

WBOY
Release： 2016-06-23 14:16:39
Original
1051 people have browsed it

PHP mysql web

原来项目和数据库是在一起的，打开都是很正常的，现在数据库和项目分开了，项目是在一个服务器上，数据库在一个服务器上，项目是远程访问数据库的。然后我再用自己的电脑去访问项目，打开首页都很慢，然后用户登录也要4-10秒的时间。在上网找了好多方法，在my.ini里添加
[mysqld]   
skip-name-resolve
效果不是很明显，有没有别的方法可以让访问不卡呢？ 

回复讨论(解决方案)

可能是 mysql 的版本他低了，至少的5.5以上
采用长连接
当然你也需要注意网络的性能，不要两端都在防火墙的监视之下

5.5以上嘛？防火墙应该不会的。

远程访问数据库，远程是个问题

Related labels：
数据库分离后远程mysql主页面打开很慢
source：php.cn
Previous article：ZendStudio Debug 失效怎么办？ Next article：php提示错误 mysql_fetch_array() expects parameter 1 to be resource, boolean given
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1870
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
10
2033
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1711
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1613
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1626
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template