Is It Possible To Make Joomla Connect To An External Mysql Database Server
Is it possible to make Joomla connect to an external mysql database server?
Meaning, the database for Joomla won't be local, but on another server.
Will it work by just entering the mysql hostname, user and password in Joomla's config?
What issues might arose by doing this?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
MySQL Cannot Connect To Database Via PHP
I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database. It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs. I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS. I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem. All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts. I just added an hourly crontab so as to restart the MySQL server as a stop gap.
View Replies!
View Related
MYSQL Error "Could Not Connect To The Database"
Last night i went to install GD on my server(Linux RH) I went through the process /scripts/easyapache and at the end of it gave me this error "...Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Fail ed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1..... .Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1 ......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127. 0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed... The was no content, the test may be unable to connect to 8080 simply because tomcat is still initila izing. You can try to go to http://localhost:8080/ to manually check it. -- End test 'Basic tomcat port running test' -- Post check of 'httpd' process Ok -- End post apache restart tests -- Executing '/scripts/initfpsuexec' Executing '/scripts/initsslhttpd' Executing '/scripts/gentomcatlist2' Compiling report... Sending report (336 bytes)... If you want to create a support ticket with cPanel regarding this please reference 'BuildAP Report Id': '528932' Report processed. You can change how PHP is configured. As root, simply execute: /usr/local/cpanel/bin/rebuild_phpconf --help for more information. Build Complete Verbose logfile is at '/usr/local/cpanel/logs/easy/apache/build.1198389830' Now I am unable to connect to MYSQL databases, MYSQL is still running from what I can see. I have base knowlage of Linux as well.
View Replies!
View Related
Installing Joomla And A Forum On One Database... Will That Run Slow
Usually I install every single PHP application on a new database. But I was thinking of installing a Joomla website and a SMF forum on one database with different table suffixes. Whether I install them in the same database or a different database, they will still be on the same host. So does it make any difference to put them in different databases or should I just put them in one database? The site/forum is for a little WoW guild website and it might get maybe 30ish visitors a day.
View Replies!
View Related
Could Not Connect To Database
I recently tried installing phpbb forum via fantastico and everytime I try I get the error "phpbb critical error" "could not connect to database" I also get an error connecting to database when I try installing SMF. I checked the configuration/information and the password and username is all correct.
View Replies!
View Related
Users Cannot Connect To Remote MySQL Server
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did. What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?
View Replies!
View Related
Can't Connect To MySQL Server On 'localhost' (10055)
Do you guys know anything about this? My server works perfectly with INSERT, UPDATE, DELETE for mysql. but after like 12 hours later, my application crashes and I get this "Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly. Do you guys have any idea why this happen? I do have a lot of connections coming in and out of my server. Would that mean anything?
View Replies!
View Related
Cannot Connect To Database ; Errno.: 2003
I'm having trouble to connect my site to the MYSQL server. The condition is like this: My site is running under 5 http servers and all are serve using a mysql server. Recently, I have changed the ip address of all the servers due to the ip migration at the datacenter. After the changes, all my http server having problem to connect to mysql server. It shows the error like below: Quote: Error: Can't connect to MySQL server on '123.456.789.2' (4) Errno.: 2003 However, I tried to establish a connection by placing the http file into mysql server. Only this site can be shown up correctly. Means, there's actually no problem with the Mysql Server. Can I know what's the problem actually? I guess there might be some setting of the mysql server blocking the connection from my other servers. Where do we normally do the setting for this? I'm quite new in server stuff and wish to get some advice from you all...
View Replies!
View Related
Requota Make Server Highload And Mysql Failed
today mysql server just went down and below is ps aux result Quote: khuvuich 4821 0.1 1.2 34580 24760 ? S 08:44 0:00 /usr/local/cpanel/cpanel ./frontend/x3/index.html root 4822 0.0 0.0 1980 644 ? D 08:44 0:00 quota -v nobody 5079 0.0 0.2 9248 4612 ? S 08:46 0:00 /usr/local/apache/bin/httpd -DSSL root 5202 0.1 0.1 12344 4060 ? Ss 08:46 0:00 /usr/sbin/exim -Mc 1IOjnZ-0001Lt-Sq mailnull 5207 0.0 0.1 12348 2236 ? S 08:46 0:00 /usr/sbin/exim -Mc 1IOjnZ-0001Lt-Sq root 5233 0.3 0.2 9940 5064 ? S 08:46 0:00 /usr/bin/perl /scripts/restartsrv_mysql --restart root 5262 0.0 0.0 4580 1200 ? S 08:46 0:00 /bin/sh /etc/rc.d/init.d/mysql start root 5423 0.0 0.0 5796 528 ? S 08:47 0:00 sleep 1 root 5424 0.0 0.0 4288 788 pts/5 R+ 08:47 0:00 ps aux root 5592 0.0 0.1 7612 4012 ? S Aug23 0:01 /etc/authlib/authProg root 6889 0.0 0.0 3216 644 ? D 05:00 0:00 quota -v root 8687 100 0.0 3360 556 ? R 01:47 419:13 /usr/sbin/repquota -auv root 8701 0.0 0.0 2196 524 ? D 01:47 0:00 /usr/sbin/repquota -auv root 10187 0.0 0.1 7612 4084 ? S Aug23 0:01 /etc/authlib/authProg root 10833 0.0 0.0 0 0 ? S Aug24 0:15 [pdflush] root 11900 0.0 0.0 3340 524 ? D 02:02 0:00 /usr/sbin/repquota -auv root 11921 0.0 0.0 2012 524 ? D 02:02 0:00 /usr/sbin/repquota -auv root 12142 0.0 0.1 7612 4088 ? S Aug23 0:01 /etc/authlib/authProg root 14413 0.0 0.0 2172 524 ? D 02:15 0:00 /usr/sbin/repquota -auv root 14437 0.0 0.0 3172 524 ? D 02:15 0:00 /usr/sbin/repquota -auv root 14534 0.0 0.0 2888 520 ? D 02:16 0:00 /usr/sbin/repquota -auv root 14601 0.0 0.1 7612 4012 ? S Aug23 0:02 /etc/authlib/authProg root 14805 0.0 0.0 2564 524 ? D 02:18 0:00 /usr/sbin/repquota -auv root 14959 0.0 0.0 1848 520 ? D 02:19 0:00 /usr/sbin/repquota -auv root 15695 0.0 0.4 20540 10060 ? S Aug24 0:01 cpsrvd - waiting for connections root 16091 0.0 0.0 3096 632 ? DN 02:25 0:00 quota -v kd4rumn root 17065 0.0 0.1 7612 4088 ? S Aug23 0:01 /etc/authlib/authProg root 18882 0.0 0.0 3416 644 ? D 02:41 0:00 quota -v root 19232 0.0 0.0 2428 644 ? D 07:14 0:00 quota -v root 20506 0.0 0.0 3460 644 ? D 07:26 0:00 quota -v root 20751 0.0 0.0 2896 640 ? D 07:28 0:00 quota -v root 20808 0.0 0.0 3760 644 ? D 02:53 0:00 quota -v root 21143 0.0 0.0 2676 644 ? D 07:30 0:00 quota -v root 21615 0.0 0.0 3336 644 ? D 02:58 0:00 quota -v root 21732 0.0 0.0 2076 520 ? D 07:32 0:00 /usr/sbin/repquota -auv root 21871 0.0 0.0 3196 524 ? D 07:33 0:00 /usr/sbin/repquota -auv root 21885 0.0 0.0 3408 640 ? D 03:00 0:00 quota -v root 22190 0.0 0.0 2116 640 ? D 03:02 0:00 quota -v root 22333 0.0 0.0 3196 520 ? D 07:34 0:00 /usr/sbin/repquota -auv root 22350 0.0 0.0 2716 524 ? D 07:34 0:00 /usr/sbin/repquota -auv root 22959 0.0 0.0 2748 640 ? D 03:08 0:00 quota -v root 23312 0.0 0.0 3104 576 ? D 07:35 0:00 shutdown -r 0 w root 23712 0.0 0.0 3116 520 ? D 07:36 0:00 /usr/sbin/repquota -auv root 23941 0.0 0.0 3856 640 ? D 07:38 0:00 quota -v root 24197 0.0 0.0 3512 644 ? D 03:16 0:00 quota -v root 24928 0.0 0.0 2512 640 ? D 03:20 0:00 quota -v root 25144 0.0 0.0 3844 644 ? D 03:21 0:00 quota -v root 25830 0.0 0.0 1980 644 ? D 07:44 0:00 quota -v root 26838 0.0 0.0 3204 640 ? D 03:32 0:00 quota -v root 27238 0.0 0.0 3832 640 ? D 03:34 0:00 quota -v root 27377 0.0 0.0 2912 640 ? D 03:36 0:00 quota -v root 27433 0.0 0.0 2752 640 ? D 03:36 0:00 quota -v root 27503 0.0 0.0 2176 644 ? D 03:37 0:00 quota -v root 27659 0.0 0.0 2144 644 ? D 07:52 0:00 quota -v root 27713 0.0 0.0 3832 1080 ? S 07:52 0:00 /usr/bin/perl /scripts/quota_auto_fix root 27714 0.0 0.0 3832 440 ? S 07:52 0:00 /usr/bin/perl /scripts/quota_auto_fix root 27715 0.0 0.0 3340 520 ? D 07:52 0:00 /usr/sbin/repquota -a root 28543 0.0 0.0 2500 640 ? D 03:43 0:00 quota -v root 29352 0.0 0.0 1520 576 ? D 07:59 0:00 shutdown -r 0 w root 29417 0.0 0.0 0 0 ? Ds 08:00 0:00 [bash] root 29538 0.0 0.2 9240 5248 ? Ss 08:01 0:00 /usr/local/apache/bin/httpd -DSSL nobody 29543 0.0 0.2 9520 5264 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL nobody 29546 0.0 0.2 9500 5232 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL nobody 29547 0.0 0.2 9520 5376 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL nobody 29548 0.0 0.2 9380 5416 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL nobody 29549 0.0 0.2 9380 4792 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL root 29556 0.0 0.0 3180 640 ? D 03:48 0:00 quota -v root 29597 0.0 0.0 0 0 ? S Aug24 0:09 [pdflush] nobody 29637 0.0 0.2 10044 5624 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL nobody 29763 0.0 0.2 9380 5392 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL nobody 29878 0.0 0.2 9520 4868 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL nobody 29939 0.0 0.2 9520 4904 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL root 30271 0.0 0.0 5812 576 ? D 08:03 0:00 /sbin/quotaoff -a root 30425 0.0 0.0 2552 644 ? D 03:54 0:00 quota -v root 30432 0.0 0.0 2636 640 ? D 08:04 0:00 quota -v nobody 30466 0.0 0.2 9512 4844 ? S 08:05 0:00 /usr/local/apache/bin/httpd -DSSL root 30609 0.0 0.0 3732 640 ? D 08:06 0:00 quota -v root 30616 0.0 0.0 2328 640 ? D 08:06 0:00 quota -v root 30994 0.0 0.0 2464 640 ? D 08:09 0:00 quota -v root 31071 0.0 0.0 2156 644 ? D 08:09 0:00 quota -v root 31250 0.0 0.0 2296 644 ? D 08:10 0:00 quota -v root 31800 0.0 0.0 3508 524 ? D 08:12 0:00 /usr/sbin/repquota -auv root 31828 0.0 0.1 8852 2328 ? Rs 08:12 0:00 sshd: root@pts/5 root 31851 0.0 0.0 4812 1444 pts/5 Ss 08:12 0:00 -bash root 32295 0.0 0.0 2172 644 ? D 08:15 0:00 quota -v and top result Quote: 8687 root 19 0 3360 556 468 R 100 0.0 422:52.37 repquota 5817 nobody 16 0 9384 4728 1288 S 0 0.2 0:00.03 httpd 6119 root 17 0 3480 1024 764 R 0 0.0 0:00.01 top 1 root 16 0 2716 548 468 S 0 0.0 0:01.37 init 2 root RT 0 0 0 0 S 0 0.0 0:02.45 migration/0 3 root 34 19 0 0 0 R 0 0.0 0:00.05 ksoftirqd/0 4 root RT 0 0 0 0 S 0 0.0 0:00.75 migration/1 5 root 34 19 0 0 0 S 0 0.0 0:00.01 ksoftirqd/1 6 root 5 -10 0 0 0 R 0 0.0 0:04.17 events/0 7 root 5 -10 0 0 0 S 0 0.0 0:00.52 events/1 8 root 8 -10 0 0 0 S 0 0.0 0:00.00 khelper 9 root 15 -10 0 0 0 S 0 0.0 0:00.00 kacpid 35 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0 36 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1 37 root 15 0 0 0 0 S 0 0.0 0:00.00 khubd 56 root 16 0 0 0 0 S 0 0.0 0:48.82 kswapd0 57 root 12 -10 0 0 0 S 0 0.0 0:00.00 aio/0 58 root 12 -10 0 0 0 S 0 0.0 0:00.00 aio/1 202 root 25 0 0 0 0 S 0 0.0 0:00.00 kseriod 332 root 18 0 2356 644 560 D 0 0.0 0:00.00 quota 429 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata/0 430 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata/1 431 root 6 -10 0 0 0 S 0 0.0 0:00.00 ata_aux 435 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0 436 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1 437 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_2 438 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_3 439 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_4 440 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_5 461 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_6 462 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_7 523 root 15 0 0 0 0 S 0 0.0 0:43.22 kjournald 679 root 18 0 3516 640 560 D 0 0.0 0:00.00 quota 718 root 20 0 2648 644 560 D 0 0.0 0:00.00 quota 1017 root 19 0 2388 524 448 D 0 0.0 0:00.00 repquota 1213 root 18 0 2064 644 560 D 0 0.0 0:00.00 quota 1495 root 18 0 2124 644 560 D 0 0.0 0:00.00 quota 1678 root 18 0 3464 640 560 D 0 0.0 0:00.00 quota 1694 root 19 0 3576 640 560 D 0 0.0 0:00.00 quota It make mysql server failed and when i try to restart got this Quote: MySQL manager or server PID file could not be found! [FAILED] This issue is really strange as i never put requota to run in cronjob.
View Replies!
View Related
Intermittent "Can't Connect To MySQL Server"
I started getting small periods of intermittent connection errors about once every hour, lasting for about 1 to 5 minutes each time: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' I enabled the error log and did some other monitoring and established 2 things: - the server doesn't crash/restart, it keeps running throughout the errors - the errors do not match the load on the website, as sometimes when 500 users are online there are no errors, but when 300 are online they may by prolific I checked many forums and then made 5 changes: - changed the directory containing the mysql.sock file so only file owners or superusers can delete files from it - I changed the default socket file setting in both my.cnf and php.ini - I read about SELinux causing such a problem, so I disabled SELinux completely, rebooted the server and double-checked that it is indeed disabled. - I changed the maximum amount of open files allowed by the operating system from 1024 to 30000. Despite all these changes, I still get the errors. I then read that there is a workaround by using TCP/IP instead of the sock file. I tried that, but I still get the error intermittently in the form of: Can't connect to MySQL server on 127.0.0.1 MySQL server 4.1.20, PHP 4.3.9, client API 4.1.20, CentOS 4.3, Intel P4 2.8GHz 1GB RAM
View Replies!
View Related
Does A External Mysql Use A Lot Of Bandwidth?
Does a external mysql use a lot of bandwidth? On one of my sites, mysql uses most of the resources of the dedicated server. I'm thinking of putting multiple mysql servers at home and the rest in the data centre. Having mysql servers at home does not require much bandwidth does it? would a dsl line work ok?
View Replies!
View Related
MySQL Stops Allowing External Connections
Recently I've upgraded my MySQL server. I connect to it via a conection from NIC to NIC (Internal IP addresses). Since the upgrade/format, I've managed to get everything back to the way it was. Everything works fine for 15-20 minutes. Then the PHP server can no longer access the MySQL server. I tried logging in from the PHP server, I get access denied. I then tried logging in locally, on the MySQL server and I get in fine... It's not like it's a firewall issue though, it's strange... I tried updating PHP/MySQL to a few releases, even the RC's to no avail... Something to note is that when I try restarting MySQL it can take 4-5 minutes, sometimes not even complete.
View Replies!
View Related
MySQL Can't Connect To Socket.....
I saw following error in some of my site in my server. Coppermine critical error: Unable to connect to database ! MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) or following error : Invalid mysql server connection Please help me how can I resolve this error ! /etc/my.cnf : [mysqld] datadir=/var/lib/mysql skip-locking skip-innodb skip-networking safe-show-database query_cache_limit=1M query_cache_size=16M ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=200 max_connections=500 interactive_timeout=10 wait_timeout=20 connect_timeout=20 thread_cache_size=128 key_buffer=64M ## 128MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=16M table_cache=1024 record_buffer=1M sort_buffer_size=1M ## 1MB for every 1GB of RAM read_buffer_size=1M ## 1MB for every 1GB of RAM read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM thread_concurrency=8 ## Number of CPUs x 2 myisam_sort_buffer_size=64M server-id=1 collation-server=latin1_general_ci [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout My server details : 1 GB RAM P4 3.00 HT
View Replies!
View Related
Users Cannot Connect To MySQL Via Phpmyadmin
It seems I am having issues with WHM/CPanel. I cannot connect to mysql via phpmyadmin through WHM as a root and get this error #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) All users get the same error when they try to access mysql from cpanel. The access seems to be only for valid for 192.168.1.% Would allowing access to localhost will help and how can I do that for all users?
View Replies!
View Related
Connect To Mysql From Many Remote Virtual Hosts
I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB. The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2. server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times. server 2 is not very busy, around 30% CPU usage and 0.6 CPU load. Yet, users on server 2 experience *much slower* response times than the ones on server 1. The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1). I was wondering what other reasons it could be. The mysql processlist is weird: Code: mysql> show processlist; +-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | 81817 | mysite | localhost | mysite | Sleep | 865 | | NULL | | 94992 | mysite | server2:47927 | mysite | Sleep | 188 | | NULL | | 96890 | mysite | server2:50881 | mysite | Sleep | 26 | | NULL | | 97213 | mysite | server2:51010 | mysite | Sleep | 22 | | NULL | | 97391 | mysite | server2:51085 | mysite | Sleep | 36 | | NULL | | 97919 | mysite | server2:51300 | mysite | Sleep | 49 | | NULL | | 97927 | mysite | server2:51306 | NULL | Sleep | 49 | | NULL | | 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL | 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL | | 97958 | mysite | server2:51321 | mysite | Sleep | 26 | | NULL | | 97961 | mysite | server2:51323 | mysite | Sleep | 46 | | NULL | | 98104 | mysite | server2:51344 | mysite | Sleep | 39 | | NULL | | 98169 | mysite | server2:51376 | NULL | Sleep | 36 | | NULL | | 98177 | mysite | server2:51388 | mysite | Sleep | 9 | | NULL | | 98365 | mysite | server2:51461 | mysite | Sleep | 26 | | NULL | | 98377 | mysite | server2:51427 | mysite | Sleep | 26 | | NULL | | 98380 | mysite | server2:51468 | mysite | Sleep | 6 | | NULL | | 98394 | mysite | server2:51474 | mysite | Sleep | 26 | | NULL | | 98404 | mysite | server2:51479 | mysite | Sleep | 26 | | NULL | | 98418 | mysite | server2:51486 | mysite | Sleep | 26 | | NULL | | 98419 | mysite | server2:51487 | mysite | Sleep | 26 | | NULL | | 98429 | mysite | server2:51496 | mysite | Sleep | 2 | | NULL | | 98503 | mysite | server2:51520 | mysite | Sleep | 22 | | NULL | | 98512 | mysite | server2:51524 | mysite | Sleep | 22 | | NULL | | 98514 | mysite | server2:51525 | mysite | Sleep | 20 | | NULL | | 98519 | mysite | server2:51526 | mysite | Sleep | 22 | | NULL | | 98557 | mysite | server2:51514 | mysite | Sleep | 21 | | NULL | | 98568 | mysite | server2:51548 | mysite | Sleep | 20 | | NULL | | 98581 | mysite | server2:51557 | mysite | Sleep | 5 | | NULL | | 98617 | mysite | server2:51572 | mysite | Sleep | 18 | | NULL | | 98620 | mysite | server2:51574 | NULL | Sleep | 18 | | NULL | | 98630 | mysite | server2:51577 | mysite | Sleep | 17 | | NULL | | 98644 | mysite | server2:51584 | mysite | Sleep | 17 | | NULL | | 98681 | mysite | server2:51601 | mysite | Sleep | 15 | | NULL | | 98698 | mysite | server2:51604 | mysite | Sleep | 14 | | NULL | | 98704 | mysite | server2:51606 | mysite | Sleep | 14 | | NULL | | 98714 | mysite | server2:51610 | NULL | Sleep | 14 | | NULL | | 98736 | mysite | server2:51619 | NULL | Sleep | 13 | | NULL | | 98748 | mysite | server2:51626 | NULL | Sleep | 12 | | NULL | | 98753 | mysite | server2:51628 | mysite | Sleep | 12 | | NULL | | 98785 | mysite | server2:51635 | mysite | Sleep | 11 | | NULL | | 98820 | mysite | server2:51654 | mysite | Sleep | 10 | | NULL | | 98821 | mysite | server2:51655 | mysite | Sleep | 10 | | NULL | | 98822 | mysite | server2:51656 | mysite | Sleep | 10 | | NULL | | 98823 | mysite | server2:51657 | mysite | Sleep | 10 | | NULL | | 98836 | mysite | server2:51660 | mysite | Sleep | 9 | | NULL | | 98840 | mysite | server2:51662 | NULL | Sleep | 9 | | NULL | | 98841 | mysite | localhost | NULL | Query | 0 | NULL | show processlist | | 98901 | mysite | server2:51680 | mysite | Sleep | 6 | | NULL | | 98903 | mysite | server2:51651 | mysite | Sleep | 7 | | NULL | | 98920 | mysite | server2:51684 | mysite | Sleep | 6 | | NULL | | 98947 | mysite | localhost | mysite | Sleep | 1 | | NULL | | 98954 | mysite | server2:51696 | mysite | Sleep | 5 | | NULL | | 99024 | mysite | server2:51710 | mysite | Sleep | 1 | | NULL | | 99031 | mysite | server2:51712 | mysite | Sleep | 2 | | NULL | | 99032 | mysite | server2:51686 | mysite | Sleep | 2 | | NULL | | 99041 | mysite | server2:51694 | mysite | Sleep | 2 | | NULL | | 99049 | mysite | server2:51717 | mysite | Sleep | 2 | | NULL | | 99058 | mysite | server2:51720 | mysite | Sleep | 1 | | NULL | | 99063 | mysite | server2:51685 | mysite | Sleep | 1 | | NULL | | 99064 | mysite | server2:51722 | mysite | Sleep | 2 | | NULL | | 99073 | mysite | localhost | mysite | Sleep | 1 | | NULL | | 99075 | mysite | server2:51724 | mysite | Sleep | 1 | | NULL | | 99086 | mysite | localhost | mysite | Query | 1 | Creating tmp table | SELECT DISTINCT * | | 99089 | mysite | localhost | mysite | Sleep | 1 | | NULL | +-------+----------+---------------+----------+---------+------+----------- Why so many sleeping processes from server 2, and none or almost none from server 1 ? Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently? What could be a reason for server 2 having problems to open connections on server 1, and how to solve it? Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.
View Replies!
View Related
"Can't Connect To Local MySQL Server" + "IPS Driver Error"
During peak times (especially weekends) many of my site's users have been reporting intermittent 'IPS Driver Errors' in the forums and the following error in the coppermine gallery: Quote: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) (The forums and the gallery are the main parts of the site). I'm assuming that the site is having problems handling the number of users trying to connect to SQL. I tried increasing the max_connections and max_user_connections settings in my.cnf but it doesn't seem to have made a significant difference. What do I need to do to fix this? Would I need to upgrade my server specs or is it something to do with the server settings? my server specs: AMD Dual/Dual Opteron 270 with 4GB RAM.
View Replies!
View Related
Copy An Account From Another Server Via WHM - Cannot Copy Mysql Database
In previous thread we made few manual transfer of our domains. We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature. All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.
View Replies!
View Related
Reloading A Mysql Database
My server admin linked me to this: [url] I'm using a cpanel based server, but I can't get this to work. It requires I be in a directory I figure (this step isnt included) so I type cd /home/username/public_html/ And then i follow the commands. but it doesnt work. Basically i need to take a mysql database that I uploaded to my directory, and load it back into a database. :@
View Replies!
View Related
Get Mysql Database From Shell
I have a problem getting mysql to start, so I am planning to setup a new server and move all the mysql databases to a new server. The problem is I normally get mysql databases when mysql is running by using mysql command lines. Now that I cannot start mysql, I cannot use that method. Is there a mysql directory that contains all the mysql databases for me to tar it up and untar it on a different? If there is a directory that contains all the mysql databases, do I need to exclude some files/folders so it doesnt conflict with the files/folders on my new mysql server?
View Replies!
View Related
MySQL With Huge Database
ways to improve the database performance in the situation when I have to modify a large table (several million rows), by e.g. adding a column. Currently this would take several hours which is too slow. The bottleneck is disk I/O. I am considering either partitioning the table over several innodb files on several disks, or going to a RAID-5 or RAID-10, it this will give me better write performance. The database is 130GB large, and the problem table (which I make period changes to) is the largest table on the server. I cannot have downtime of 3 hours each time I make a change and adding blank fields (to be used later, when a new field is needed) is not an option. Each time I add a column, the cpu goes into high (80%) io wait state for about 3 hours. I have a hack which would allow me to split the large table into multiple smaller tables based on some criteria (for example, forumID or such). Here are a couple of things but would like to know which is best, and am open to new ideas. The ideas so far: 1. Split the table into 3 or 5 smaller tables each on it's own disk. The disk IO would then not be so bad, and it might only take 1 hour to perform the table change. But this might not work because the changes to the database (as in adding a column) might be serial, meaning only 1 disk is being written to at a time. (Then again, maybe it will work if I launch 3 different scripts, one to update each table at once). 2. Do RAID 5 or 10, and have 3 or 5 disks. This again might not help at all because of the above issue with MySQL writing serially. I am using latest MySQL 5.0.45 with InnoDB engine on Debian etch Linux
View Replies!
View Related
How To Secure Access To MySQL Database
What can I do to secure access to my MySQL database to stop it from getting compromised from hackers? Is there any way I can restrict access to the MySQL database to my IP only? The database is for an IPB 2.3.4 forum and the username/password are stored in a conf_global.php file that is CHMODed 0444.
View Replies!
View Related
Big Mysql Database 4gb
i been trying to move my server.. But mysql database is quite big and restoring takes ages 10 12 hours.. is there anyway i can make it quick because database dump takes 10 15mins but restore takes 12hours and it should be a way to make that quick
View Replies!
View Related
Managed Database Hosting (Mysql)
if there are any recommendations on managed database hosting services. This will be used for a fairly large project running on Mysql DB. Due to the size and complexity of the database a lot of resources are being used, so I prefer to find a company which specializes in dB hosting.
View Replies!
View Related
[mySQL] Copy Colomn From 1 Database To Another
I'm trying to copy the contents of a column from 1 database to another. I need to do this as the contents in the current database have got messed up after an upgrade. The DB structure table forum_msgs It contains a column called "topic_id". Basically I need to copy over the topic ID fields from the "old" database into the "current" database into table forum_msg replacing any values that are currently in the column "topic_id" I tried this but it doesn't seem to work correctly. Any ideas how it should be done? insert current.forum_msgs ( topic_id ) select topic_id from old.forum_msgs
View Replies!
View Related
Alterntive Way For Downloading A MySQL Database
A friend of mine has an account with a hosting company that recently became unstable and he wants to move his site away. I downloaded the files, but it now seems impossible to download the databases in the conventional ways. I tried downloading them using their control panel (vDeck) but I get an error "File Permissions do not allow to download backup". Then I tried to export it using PHPMyAdmin but the files either doesn't download at all, or it downloads inccomplete with the last lines having something like the following: Cannot modify header information - headers already sent by (output started at /usr/local/apache/htdocs/phpMyAdmin-2.6.3/export.php:121 I tried to contact their support but they have no clue. Is there any way to download the database? I thought of creating a script that would manually itterate through the tables and create an export fie similar to what phpMyAdmin creates. I don't know if this is possible, and I hope there are better ways.
View Replies!
View Related
Backup BIG MySQL Database
What is the recommended method of backing up big MySQL database of size 2 GB ? Quote: # mysqldump gallery > gallery.sql mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES # I checked the table, it is fine, but can't do the backup. Quote: mysql> check table 10tir_user_group; +-------------------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+-------+----------+----------+ | gallery.10tir_user_group | check | status | OK | +-------------------------+-------+----------+----------+ 1 row in set (0.07 sec) mysql>
View Replies!
View Related
Exporting Mysql Database From Helm
i have a fren who wants to transfer a hosting ..for a site made in php and hosted in helm...windows server... the site uses mysql datbase but i could see no database in the database setting(of helm)...and says no database created.. in host i could see server.mysql in php database config files i want to export database...to linux server i have not used helm much.. where actually is database located and how can it be exported?
View Replies!
View Related
Fetch Admin Password From MySQL Database
I have forgot the admin password for one of our application. All the users and passwords are stored in database table "users", is there any way I can get the password from the database.. any MySQL query that will fetch the admin password from that database table.
View Replies!
View Related
|
TRACKER
