Remote MySQL Connection Slow
I have a website on a dedicated server that was running really slow, so I got another, much faster server and transferred the MySQL database to this server. However, now when I connect to the faster server's database using the slower server's PHP web pages, the overall page loads much slower than when the database was on the slower server.
Any ideas why this would be? Right now the host name is just an IP address. Does it need an actual resolved hostname to be fast? MySQL on the faster server is supposedly tweaked for fast service (my-huge.cnf).
View Complete Forum Thread with Replies
Related Forum Messages:
Slow Remote MySql
We have a local (client) machine that runs a php application on windows using apache, the database for this application is on a remote server, which the client machine connects to via the servers ip number and the server accepts the connection from the client via the designated ip address (skip-resolve-address is set in MySql server and no dns addresses are used, only ip). However, the php application when dealing with the data from the MySql server is still pretty slow. We've tried query cache, but still slow. When I say slow, I mean page response and reloads take about 5 or 6 seconds. Is this expected from a remote server and using apache as we do for this application? When using a local MySql server the speed is pretty much instantaneous, but we need the remote server! Also, in testing the remote MySql server with a program such as SQLyog, response to requests are very quick and queries take no time. How could we go about testing for where the bottleneck is? Could it be apache and php (and where do we start looking for the problem? Local MySql server is nice and fast)?
View Replies !
MySQL Slow To Connect To Remote Database
I was running a PHP/MySQL web site with the database on the local web server. I needed to move the database off the webserver (located in the firewall DMZ) and onto its own machine (behind the firewall on our private network) Now when I run my web site it goes really slow. I ran mysql from the command line on the web server and connected through to the database machine behind the firewall using webserver:/# mysql -h 192.168.1.7 -u www-data -p After I enter the password, it takes around 5-7s before I see the mysql> prompt. Is mysql trying to do reverse dns on the IP address and timing out? I added the machine details to /etc/hosts so it would be recognized but no improvement. Or do I have something wrong with my mysql configuration?
View Replies !
MySQL Connection Sometimes Slow
I have been developing an application in Visual Basic that accesses a MySQL database either on the local machine, or a remote machine. Locally, database connections run smoothly. However, when I try to connect to the remote system (another computer on my local network) some databases take longer to connect than others (sometimes 10 - 20 seconds). The application usses the myvbql.dll (sorry lost the link, found it through google) wrapper around the libmysql.dll file to perform database actions. The application seems to hang when it tries to actually make the connection to the datatbase. This is only happening on the remote database server, and does not happen on every connection to that server.
View Replies !
Remote MySQL Connection Fails
I have two XP computers, with the same version of MySQL on each. I have the same database structure and data on each. Each computer has the same user name, and each MySQL database has the same user names. Locally on each, I can connect and work with the data. I can ping each computer from the other computer. My problem is that when I try to connect from one computer to the other I get the following error: Host 'XXX.XXX.XX.XX' is not allowed to connect to this MySQL server. This happens on both computers. I can not find the reason for the error.
View Replies !
Local Application Connection To Remote MySQL
I have managed to set it up on a remote server, I would like to know what' the best way to write an application, pref. in C++, that can connect to the remote DB over the internet. Basically, I hope to have a program running on a local computer collecting information and dumping it into an online MySQL database.
View Replies !
Remote Connection To Mysql Database Using JDBC?
I am trying to set up OpenOffice Base to connect to a remote os x server with mysql on it. It has the default mySQL JDBC driver class set to com.mysql.jdbc.Driver It also asks for server URL, should this be the ip address? Port number? Default is set to 3306. When I set the class it says that the JDBC driver could not be loaded.
View Replies !
Localhost Mysql Connection Pointing To Remote Server!
This one is beyond bizarre. For a few days I've been having trouble working on my site on my local machine. Everything was dog slow, and the information I was seeing coming out of the database was oddly out of date, even though I had synced to my live server several times. I finally discovered that the records I was seeing were consistent with the tables I have up on my Media mysqlle host, which I've been working on switching over to, but is not live yet. So to put it more clearly, when I'm running my local version of my site on my local version of Apache (on my Windows Vista laptop): 1. The php files being interpreted are indeed the ones on my local machine. 2. Any MySQL queries somehow reach up to Media mysqlle, and query THAT database (even though it has different login credentials). I'm using the following lines to create the MySQL connection: $sqlHandle = mysql_connect('localhost', '<myusername>', '<mypassword>'); mysql_select_db('<mydatabasename>', $sqlHandle) or die(mysql_error()); Is this weird, or what? Any idea what's going on?
View Replies !
Remote Connection To MySQL DB Server From Client With No MySQL DB
I have MySQL server running on a Solaris machine. I have a Perl tool that is run on multiple operating systems (Linux, Solaris, MKS on windows, CYGWIN on windows). I would like to post to the MySQL database on the Solaris machine from this script when it is run on the different local clients. All these clients share a single network share (available via Samba on windows). Is there a Perl module that I can install in the network share that I can use to connect remotely to the server DB?
View Replies !
SLOW REMOTE CONNECTIONS
well i have read many many threads about mysql being slow on remote connections due a issue called dns look back, and dns round trips ive read many many times the solution its the to add this line to the my.ini skip-name-resolve. but it mysql seens to ignore it since i still can use dns on the conections and the response times still 5 seconds or moreits not a network speed or latency issues cause once connection its established it works fine. this its how my.ini on my computer looks like [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve whats wrong there or what could i be possibly doing wrong.
View Replies !
Slow Connection
I build an application and installed it on many machines. In every machine except two, the program works without problems. On this two, the connection with database is too slow. I saw the opened doors with 'netstat' and the computer opens about 5 or 6 ports (to the port 3306 of the mysql server) before sucessfuly connect with MySql Database and execute the sql. I don't know what could be happening. I realy need to fix this because the progrm is too slow with this error. Could anyone know what could be happening??
View Replies !
Connection :: Pages Slow
we have end site layout (really fast and made with css+xhtml) so we have insert the mysql connection The page load seems very very slow at middle of page. Page is load within middle, after there are pause of 1/2 second and after load continue .. we don't have meet this problem so, we have comment all last row code.. the row that make problem is mysql connection: $conn = mysql_connect($_CONFIG['host'], $_CONFIG['user'], $_CONFIG['pass']) or die('Impossibile stabilire una connessione'); mysql_select_db($_CONFIG['dbname']); Have you any idea?
View Replies !
Remote SQL Connection
I am trying to access my database on the server with a MYSQL front-end client on my computer (not the server). I have the correct username, password and database name. I tried every possible hostname, even its ip addy, but each time, I am rejected by the server, which says something like - access denied. I can access the database in my php code with 'localhost', but that's of course because the code is actually running on the server. Is there anything I have to specify on the MYSQL server in order to gain access to it remotely?
View Replies !
Remote DB Connection
I am trying to install SAM Broadcaster and it requires tables to be installed on a mysql database remotely. I am not able to connect to the database for some reason and I am wondering if this is maybe because the MySQL server I am trying to connect to has remote connection protection on (if there is such a thing). Is there a way of determining this and is there also a way if this exists to allow remote connections to add tables to a mysql database?
View Replies !
Remote Connection Error
I have been using a database on localhost for a while succesfuly. I am now, however going to be using this same database remotely. Whenever I attempt to connect to the database remotley I am given the error message: Warning: mysql_connect(): Can't connect to MySQL server on 'my ip' (10060) in C:OpenSAApache2htdocsindex.php on line 9 I have removed the bind-address line from the my.ini file in C:Windows as I read in a previous post you should do, and restarted mysql, but the error still remains. Does anyone know what i'm doing wrong?
View Replies !
Remote Connection Via Internet
Alrite i've really briefly used mySQL with java but only with a local database. I need help on how to create remote connections via the internet to mySQL. Basically i've been trying to test out connecting via the internet from my home machine where mySQL is installed, i've tried this through windows command line and doing: mysql -h myip -u myuser -p also tried with --port=3306 but it doesn't work. Does the fact that i'm behind a router and have a different local ip matter? Or does the fact that i'm doing this from the machine that holds the mySQL database but i'm using the internet IP address to make it go through the internet. I've already opened up the port in my routers firewall. I wanted to create a java application that can access a mySQL database over the internet so I thought i'd try out remote connections on windows command line first. I'm very new to mySQL so any help in the right direction and/or what i'm doing wrong with some explanation will help me give a better understanding.
View Replies !
Remote Connection Permissions
I have mysql4 installed in RHEL4. I need to enable remote connection in this db so that application server can get connected to db server. For this, only creating user as grant all on db.* to remote@remoteipaddress identified by pwd; is this enough? or shud i do any other step.
View Replies !
Remote Root Connection
I am new here and I have a problem with configuring mysql. How can I set up mysql to allow remote root connections from a specific IP range?? Is this possible at all?
View Replies !
Remote Connection Through Php Script
I have a mysql server running at the office on <officeip>:3306 I have a site hosted by a provider at domain.it I have granted privileges for existing user office as office@domain.it and office@domainip I wrote a php script using the parameters: $host='<officeip>' $user=office $pass='<thepass>' $db='<mydb>' to connect to the office db from the website. I get a 'Lost connection' error (no query to execute just connecting so no time-out problem) What do you believe is wrong with it?
View Replies !
Establishing A Remote Connection
I'm trying to enable remote connections to my mysql database. I'm getting a java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused error when I try establish a jdbc connection. I'm supplying the correct user/pass information. A quick google tells me that I need to enable connections from places other than localhost. okay, so I do a: mysql> GRANT ALL PRIVILEGES ON *.* to raghav@'%' identified by 'blah'; As can be seen from the table below, i've tried doing it for anonymous accounts as well, when all of this didn't work. I've flushed privileges, and restarted the mysql server. no luck. Code:
View Replies !
Remote Connection To Sql Server
I've set the remote website, dotbooks.org (207.44.234.74) as an "Access Host" in cPanel. I'm trying to connect to wiishare.org (70.86.206.218) The connection string I'm trying is: <?php $user = "username"; $password = "password"; $database = "database"; $link = mysql_connect("70.86.206.218", $user, $password); mysql_select_db($database, $link); echo mysql_errno($link) . ": " . mysql_error($link). " "; ?> The string works with localhost, but not like this. It just times out Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in connect.php on line 7 Any suggestions?
View Replies !
Remote Connection Navicat
I m trying to connect remotely to mysql on my domain. Navicat works after opening mysql port:3306 on my firewall setting but Mysql query browser gives me the error below. I need to use query browser because navicat is commercial and i only have a trial release. So query browser needs to work for me. Any suggestions on how to sort this out?
View Replies !
Lost Remote Connection
I had a remote connection to my mysql databases working fine for ages, but today I heard it stopped working. I can't understand what is wrong - I thought we tested it after I changed the username & password for the db & all was well. I changed everything back to the default (original) connection info & still no joy. Even a short test script with the original master pw / username doesn't work. This is the error message I get from the test script: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'xxxxxxxxx.com' (4) in /home/xxxxxxxxxxx/conntest.php on line 2 Could not connect: Can't connect to MySQL server on 'xxxxxxxxxx.com' (4) I am on a shared server & therefore restarting the server isn't an option. Does adding a new user to the db screw up an existing remote connection? How would I fix it? I tried adding the port number to the hostname but that didn't work either.
View Replies !
Remote Connection Truncates Username
I'm having a problem connecting to mysql on a remote host because it truncates my user name (dbm.stetsonband.org): ERROR 1045 (00000): Access denied for user: 'dbm.stetsonband.@d199-126-224-237.abhsia.telus.net' (Using password: YES) Is there something I need to set in my mysql prefs somewhere?
View Replies !
Error 2003 On Remote Connection
I have a WinXP Home Edition where I have installed MySQL 4.x I can use MySQL Administrator on my server, but when I try to connect to my server by entering my WAN-IP, I get the error: "Could not connect to the specified instance. MySQL Error Number 2003 Can't connect to MySQL server on xx.xx.xx.xx (10061)".
View Replies !
Remote Server Connection Error
When I try to connect to my server remotely via mySQL Administrator, I receive the above error message # 2003 (Could not connect to the specified instance) However, the connection to my MySQL server works fine, once I have established a VPN connection to the school's network. Is there any way to establish the connection to my MySQL server without having to use the VPN?I run MySQL 4.1.9-nt on windows 2000.
View Replies !
Where Are Remote Connection Errors Logged?
The server machine accepts most connections, but wont accept connections from a version of mysql on another machine that was hand compiled to work w/in SGE. Instead it reports the following error: ERROR 2003 (HY000): Can't connect to MySQL server on 'billy.bio.nyu.edu' (111) However, when using a package-install mysql client on that same client machine, we can connect w/o issue.
View Replies !
Slow Performance :: Navicat To Import Tables From An ODBC Connection
have been using Navicat to import tables from an ODBC connection I have. The import goes extremely fast but once the data is locally stored and I try to manipulate it by joining tables, the program goes slower and sometimes even crashes it. If the same data is however imported into a table in MS Access, and a query is created it runs fine. I would like to know if there is a way to improve the performance of my MySQL database as the reason I was using it is because of its scalability. I was wondering if there was something I was doing wrong or could do better. The Server the data is downloaded to right now is has the following specs: Windows XP Pro Intel Core 2 CPU 2.13 Ghz 2 GB RAM
View Replies !
MySQL Remote Backups - No Access To FTP Or Remote Command Line
I have a mySQL database located on a remote host's server. I would like to schedule a task on my local Windows computer to retrieve a backup/dump of this remote database. I have contacted my host, and they indicated that the server is only open to the Internet via mySQL. Therefore, even if I did have access to that server's command line (which I don't) to create dumps via mysqldump, I would not be able to retrieve via FTP. Does anybody have any ideas as to how I can generate backup files from my local computer through a local command-line interface? I have done it through a GUI (DBTools), but I would like to have it done via DOS batch, so that I can schedule it. Does anyone know of any mysql backup GUIs with command line switches? Or can somebody recommend an alternate means of getting a local backup?
View Replies !
Slow MySQL
mySQL has been running very slowly and I am getting errors. First I did 2 things I raised the ServerLimit number (apache) to allow for more connections, I also raised the max conncetions in my.cnf. I do not know if this took effect? That should have worked. But basically in phpmyadmin i get this error frequently. I am getting more traffic so I think it is that. MySQL said: Documentation #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
View Replies !
Why Does MySQL So Slow
I just changed to use MySQL few days ago but it was a bad idea. My server now is running very slowly with the database. I'm using Perl5 and DBD::Mysql in my script. The system is Linux9, Apache2. I looked at these mysql pid and saw a lot of activities (about 400) while there are more 100 users online at this moment and lots of running under a the same pid number.
View Replies !
MySQL Slow
I had downloaded a few years back mySQL v3.51 installed but never used it. Now I wanted to convert some B-TREE databases to mySQL and did some testing via ODBC to insert 70,000 records: My results: MS ACCESS: ~60,000 msecs MYSQL v3.51 ~18,000 msecs Impressed with the speed, I went ahead and got the latest MySQL v5.1. Uninstalled the older version, I had nothing there to preserve, so I did a simple new install with MySQL v5.1. I noticed the size of the files and BINEXE increasted by 1,000,000%. Ok, Bulky. Not a problem. I reran the same ODBC test, and now I got: MYSQL v5.1: ~450,000 msecs or 7.5 freaking MINUTES! What the hell happen? Nothing was done. I'm knew to MYSQL. I just installed it with all the defaults. I did choose "developer's machine" for the "optimizer wizard" I can't redistribute MYSQL v3.51 and force it down people's throats! I have to use what they are using already, if already installed. Not even my current system takes 1 minute to add 70,000 records. Why 7.5 minutes? All it is simple inserts/free statements.
View Replies !
MySQL Slow Log
I have the long query time set to 15 yet MySQL is still showing results with a query time of 0 in the slow query log. It says enter time in "seconds" in the MySQL Administrator but did it mean in milliseconds??
View Replies !
MySQL Slow In Windows NT4
I am running the Apache web server, MySQL v4, and PHP on an NT4 server. Apache runs great, but the auction software I am using (Web2035 Auction software written in PHP) is very, very slow. Sometimes it takes 20-30 seconds to bring up an auction page from the items table which has less than 200 records in it. Can anyone can give me some pointers on where to start looking? (I don't know if the bottleneck is with MySQL or PHP or what I might need to look at to enhance the performance of either package.)
View Replies !
Slow Mysql Select *,
I have a sql table with more then 20,000 rows in a table called summary and when I run "select * from summary" it returns a exucutions time of 0.5 seconds in php which is kinda slow if you ask me, now I know that the * type for select isnt the fastest way to fetch data but its the most convenient for me.
View Replies !
MySQL Slow Starting Up
I am using a Windows 2003 Web Edition Server running IIS and MySQL 4.1. I had to restart the server the other day and it took MySQL almost 2 hours to come back up. I was watching it on my task manager and it went up to approximately 60,000k in 10k increments before I was able to access MySQL. My CPU usage was hovering around 3% all this time. Everything else came up on the server just fine. This happens every time I have to restart my server. The reason I have to restart my server most of the time, is because MySQL locks up on me. Is there any settings I can change that would help me here? Any help would be greatly appreciated. One more thing to add. I am using the default my.ini file. We have almost 100 different databases on the server and have around 20000 tables within all of these databases combined. All of these tables are InnoDB tables.
View Replies !
MySQL Running Very Slow
I have the following INSERT SQL, which runs very slow (For 2 full days it had not done anything) on a 2 processor Compaq machine running Suse Linux. Code:
View Replies !
MySQL Is Slow, Trying To Optimize
It just seems that my system is slow, adding records, etc. I tried to optimize it, saw that there was a my-medium.ini file, read that is was for medium sized system. I replaced it with my.ini (yes I did make a backup, thankfully) and restarted mysql. Pretty much it hangs. I tried to connect with QueryBrower, did a Select Count(*) and just froze. I admit that I didn't wait for ever, yes I know I Select Count(*) takes a long time but I gave up after waiting 3x as long as I normal did. Also the logs screen froze in administrator.
View Replies !
Slow Running MySQL?
I'm hoping someone may have an idea what could be causing the slow loading pages of my web-site. I'm not positive, but I'm relatively sure that it's related to a problem with MySQL database. I purchased a program called Sam3 for broadcasting our radio signal over the internet. The software requires the use of MySql in order to set up web pages for our web site. The problem is, that while everything works GREAT (requests can be made from the site, songs can be searched, the history of what we've played shows up) the pages load PAINFULLY slow. Other users of this software have had no such problems so I'm at a loss. I know from testing that the PHP script for the web pages is fine, I have plenty of bandwith both upload and download available on my DSL line, and while the computer running MySQL is behind a router I have tried plugging the DSL line DIRECTLY into the host computer and it makes no difference. For all appearances it seems the problem is that it takes MySQL forever to gather and provide the information needed for these pages. Does anyone have any idea what I should be looking at to solve this problem? I do not know the MySQL program at all, so I get somewhat lost when people start throwing out technical terms, but this has been really frustrating because no one else seems to have the problem and everyone so far has just told me to check the things I've already checked.
View Replies !
MySQL ODBC 3.51 Driver Very Slow!
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time to load making any kind linkage with my Access data virtually useless. I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting out on a server and the Access database is running locally.
View Replies !
MySQL Slow: Configuration To Blame/fix?
I have MySQL 5 running on a PC, and have grown used to the startling slowness of MySQL joins. The most recent disappointment is a straightforward self-join of a not-too-big (700K rows), indexed (on very-high-cardinality column FILE) table create table temp2 as select a.*, b.time as time2, from temp1 a left join temp1 b on a.file = b.file and timestampdiff(HOUR,a.time,b.time) = 1; that completed in 10 hours. (Indexing resulting table took 20 minutes). If this is not a problem with the programmer, or with MySQL, could it be a result of a mismanaged installation, one that could be fixed with a judicious re-configuration/choice of MySQL options?
View Replies !
Delay, Latency, Slow Mysql
I recently upgraded mysql from 3.23 to 4.0 and found that my websites using the mysql db had a 5 second delay, or latency. I searched for 2 days and found no answer to my latency problem until just a moment ago. I'd like to share the answer in case someone else finds this occurring to them as well. I was using my real static ip in my website mysql address instead of 'localhost', localhost should have been used initially anyways. I am not real sure what my reasoning was when I initially chose to put in my static IP. So, If you are like me and keep your stuff on your local machine, use 'localhost' instead of your static IP. At least it fixed my delay issues.
View Replies !
Mysql -s -u Root Bmd < Db.dump2 Slow
I've been sent a dump of a database and am trying to restore it with the command in the subject line. It's progressing, but very slowly. The problem is that the database is 40GB. Now if mysql is doing database-y thing like allowing access while building tables this might be slowing it a little. Is this the case and is there any way round the problem and slurp the the whole thing in isolation. Background: debian sarge mysql-server-4 4.1.11a-4sarge I really *am* a mysql newbie - tell me I'm silly for starting at 40GB
View Replies !
My MySQL Back-end Works Very Slow
I have installed my MySQL Server in a Window XP platform running in a Pentium4 machine. When I access the database on the machine, it is working in a normal speed. But when I access the database from a client machine (still running in windows platform), it runs very slow.
View Replies !
|
TRACKER
