I'm running a forum system on my server. Loading pages that don't connect to the forum database load normal. Whenever I browse any page that connects to the forum database on my forum, the page either takes ages to load or times out loading. I never exceed using 14% of one of my two cores, I'm using a quarter of my 1.5GB ram. It's only been loading slow like this since I've switched from running Windows to Ubuntu Server 8.10. I enabled logging slow queries on SQL, but nothing's been recorded. I've installed the server packages through Webmin,
when I access the server through its local IP address it's still very slow.
I have a website www.officegofor.ca. The site takes a very long time to load. I don't think it's because of the server's connection speed. What would be the best way to diagnose the problem? What could the problem be? I noticed that it get's slower and slower with time and when I restart apache it's faster (but still not fast enough).
I seem to be having a problem with slow loading. When I type in a couple of domain names on my browser, I noticed that it will take 2 seconds, before the site will start to load.
On my status bar, it would show "Looking for www.domain.com" during that 2 seconds.
It seems like the DNS is taking a long time to find my IP?
a DNSstuff.com's tools report, shows my DNS as pretty healthy.
I have a page that is loading very slowly the first time I connect to it. After that it's very fast.
Now I did some research and found out that this could be a DNS issue and that my nameserver might do a reverse DNS lookup. I do not know excatly what that means yet, but I suppose that could be the issue.
To the my.cnf file I added skip-name-resolve in order to disable DNS lookups, but what I can do to find out if I have a dns issue?
i am trying to optimize my dedicated server to host one website (php-nuke platnuam 7.6v2b5 taking 1min to 1min 30secs to load). ive read the tutorials and it does not seem to make a difference no matter what i try. if one of you guys could kindly point out what could possibly be the problem i would be very greatful.
Vmstat: procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache si so bi bo in cs us sy id wa st 0 0 0 891124 228272 1964832 0 0 34 21 99 81 1 0 98 0 0 0 0 0 891124 228284 1964824 0 0 0 9 1045 161 0 0 100 0 0 1 0 0 891124 228292 1964832 0 0 0 3 1031 130 0 0 100 0 0 0 0 0 891124 228300 1964832 0 0 0 3 1045 157 0 0 100 0 0 0 0 0 891000 228308 1964832 0 0 0 7 1035 144 0 0 100 0 0
Distro: REDHAT Enterprise 5 i686
Mysql: 4.1.22-standard
Apache: Server version: Apache/2.0.61 Server built: Oct 17 2007 14:55:40 Cpanel::Easy::Apache v3.2.0 rev2623
php: PHP 5.2.4 (cli) (built: Oct 17 2007 15:00:59) Copyright (c) 1997-2007 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
things from the tutorials section ive tried: this website/showthread.php?t=549666 this website/showthread.php?t=579135 this website/showthread.php?t=340239 (only did 4. Tuning sysctl.conf from here)
I have a VPS over at futurehosting, and I'm having some issues with my PHP/MySQL sites loading slowly after a few days of uptime. A restart of the various services (apache/mysql) fixes the issue, but I'd like the issue to not start in the first place.
I know very little of server administration (I'm still learning) so just let me know what info you need to see to do the troubleshooting and I'll get it to you.
I am working with wamp on development phase. We have a Symfony 2 project and I am using Assetic to manage the assets. (no filter used for my test, so no compression or whatever).
I know I am in the development mode and that assetic is meant to work differently on prod environment but the loading of js, css and images is so slow (could be 30s for a dozen css, a dozen js -most of them are already minified- and 4 images, I am using firebug to check) that I wonder if there is a problem with Apache.
I've got 25 domains on a Virtuozzo/Plesk8.6/CentOS5 VPS. Each domain has one up-to-date install of WordPress, most have very little traffic (average 200mb per month), maybe 2 domains get 5-7gb traffic per month.
I monitor port 80 connections and rarely see more than 10 at a time. That should in my opinion be no problem at all for a VPS with 768mb guaranteed ram and 2.4ghz cpu. I've got 30gb hard drive spare too.
But.... about 8 or 10 times a day it grinds to a complete halt: server load at 500-1000%, sites timing out, plesk takes 3mins to load, often I can't even connect with SSH, and the plesk web server, apache
80 seconds sounds like a huge amount of time for a MySQL insert to me! Does anyone know if this is likely to be the cause of my trouble? Some problem with Plesk and the database? Or could it be something else?
I've got a server that was running Apache 2.0/PHP 5.2.5 & MysQL 5.0 just fine, however I needed to upgrade to a newer version of MySQL.
So I uninstalled MySQL 5.0 and installed MySQL 5.1, copied the MySQLlibs over, and recompiled Apache/PHP with easyupdate. Apache & MysQL both start/run fine without errors, however PHP files don't load. Just get black pages (HTML works fine obviously).
I went ahead and updated to Apache 2.2 & PHP 5.2.6 while I was at it, but that doesn't change things. I'm not sure why uninstalling MysQL & reinstalling would break any dependencies, but looks like thats the case. Perhaps I need to reinstall some libraries?
Or would it be easier just to reinstall Apache/PHP entirely? I have no data.
I have a Centos 6 server with Heart Internet, who yesterday had an issue with the issue and once back online have been struggling til now getting the mysql service working correctly again and have now refused to provide any further support and redirected me here.
I was following this article here: [URL] ....
I've gotten to point 4. "~# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` -A | sed '1iSET FOREIGN_KEY_CHECKS = 0;' > /root/dumpall.sql" however it's saying "got error: 145: table './avenue141_dabs/av_options' is marked as crashed and should be repaired when using LOCK TABLES and any attempts made to get into the DB to repair is giving me "error: 1045: Access denied for user 'root'@'localhost' (using password: NO)
This issue is urgent as we have a few websites on this server which use mysql databases for their website.
At the PHP level, we have the following in our php.ini (some of these were recommended in our documentation to start with):
max_execution_time = 300 memory_limit = 128M error_reporting = 2039 display_errors = Off register_globals = Off
/etc/my.cnf
[mysqld] local-infile=0 datadir=/var/lib/mysql skip-locking skip-innodb skip-networking safe-show-database query_cache_limit=1M query_cache_size=32M ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=500 max_connections=1500 interactive_timeout=10 wait_timeout=28800 connect_timeout=20 thread_cache_size=128 key_buffer=512M ## 128MB for every 1GB of RAM join_buffer=4M max_connect_errors=20 max_allowed_packet=16M table_cache=1024 record_buffer=4M sort_buffer_size=4M ## 1MB for every 1GB of RAM read_buffer_size=4M ## 1MB for every 1GB of RAM read_rnd_buffer_size=4M ## 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
We have a dedicated server and we host 4 news portals based on e107 and joomla.
My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much.
We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec !
Does anybody know if this is makes sense ?
Below is the server Status from WHM : -------------------------------------
cpdavd up cpsrvd up exim (exim-4.69-15.1_cpanel_maildir) up ftpd up httpd (2.2.11 (Unix)) up imap up interval up mysql (5.0.67-community-log) up named (9.3.4) up pop up rsyslogd up spamd up syslogd up Server Load 6.97 (1 cpu) Memory Used 49.4 % Swap Used 0.23 % Disk /dev/hda3 (/tmp) DMA+ 70 % Disk /dev/hda5 (/) DMA+ 22 % Disk /dev/hda1 (/boot) DMA+ 14 %
Below is the Server Information from WHM : ------------------------------------------ Processor #1 Vendor: GenuineIntel Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz Processor #1 speed: 2394.068 MHz Processor #1 cache size: 2048 KB
What I did here was create /var/log/mysqld.slow.log for queries that are taking one second or longer. After around 36 hours, here is what I came up with. Since the file size of /var/log/mysqld.slow.log was 219KB, posting it in its entirety it not practical. Therefore, I used a program, the perl script known as mysql_slow_log_parser found on www.retards.org, to parse the mysqld.slow.log to make it easier to interpret and read. The result was that the original filesize of 219KB was converted to the smaller size of 14KB....
I'm hosting about 6 private websites on my server, and some have problems.
My biggest website is a vb forum with 30.000 members and 1.5 million posts.
When i browse with firefox i see that vb forum loads fast, but phpads which is integrated on the top and footer loads very slow. When i browse with IE, it takes like 10 seconds before the whole site is loaded and sometimes IE even crashes.
When i try to login on another website / admin panel (oscommerce), i get a mysql gone away error, that means timeout. But why does it show that? I ran mysqlreport and can't find anything why it should display mysql gone away. # ./mysqlreport MySQL 5.0.15-standard uptime 3 19:36:47 Mon Feb 5 11:08:10 2007
__ Key _________________________________________________________________ Buffer usage 78.94M of 96.00M %Used: 82.23 Write ratio 0.60 Read ratio 0.00
I have windows server 2012 and Plesk v12.0.18 #30 - I noticed speed problem.
When I try to connect to mySQL with:
$conn = new mysqli('localhost', 'joomla_***', '*****', 'joomla_test');
Connection takes 1 second!!!When I try to connect with '127.0.0.1' instead of 'localhost' connection takes 0,009 seconds.
1. I tried solution to add line '127.0.0.1 localhost' to c:windowssystem32driversetshosts - but no luck.
2. I tried to edit C:Program Files (x86)ParallelsPleskMySQLDatamy.ini - adding lines bind-address=127.0.0.1 skip-name-resolve then restarted mySql but 1 second lag time on connection was still there.
3. I even tried to disable IPv6 but still no luck
I guess all users windows windows server 2012 has the same problem??!?!...
i am getting iptables errors when reloading APF, and after that APF takes a few seconds to move thru each line in deny_hosts.rules (and also other rules files). is this normal? if i have a very long list of deny rules wouldnt this delay loading other rules?
(running centos/virtuozzo 2.6.18-028stab062.3)
Code: /etc/apf/apf -r apf(7689): {glob} flushing & zeroing chain policies apf(7689): {glob} firewall offline apf(7721): {glob} activating firewall apf(7761): {glob} determined (IFACE_IN) venet0 has address 127.0.0.1 apf(7761): {glob} determined (IFACE_OUT) venet0 has address 127.0.0.1 apf(7761): {glob} loading preroute.rules iptables: Unknown error 18446744073709551615 iptables: Unknown error 18446744073709551615 iptables: Unknown error 18446744073709551615 iptables: Unknown error 18446744073709551615 iptables: Unknown error 18446744073709551615 iptables: Unknown error 18446744073709551615 iptables: Unknown error 18446744073709551615 apf(7761): {resnet} downloading http://r-fx.ca/downloads/reserved.networks apf(7761): {resnet} parsing reserved.networks into /etc/apf/internals/reserved.networks apf(7761): {glob} loading reserved.networks apf(7761): {glob} loading bt.rules apf(7761): {glob} loading deny_hosts.rules apf(7761): {trust} deny all to/from 124.166.250.250 ' not found.3.5: host/network `124.166.250.250 Try `iptables -h' or 'iptables --help' for more information. ' not found.3.5: host/network `124.166.250.250 Try `iptables -h' or 'iptables --help' for more information. apf(7761): {trust} deny all to/from 200.233.149.110
I have a Shared Hosting , and a Vps . i use the VPS to Storage Audio files and Leach to them from my Shared Hosting . the shared hosting Only Has Some php, and Html pages with the links to leach from the vps ..
Now which One Gets The Load , or which one is the One Suffering the Load . the Shared Hosting or the VPS ..
I have a weird issue with my Plesk VPS. If I restart the VPS it will work find for about 20 minutes and then go down. All my websites will continue to load and load until they time out.
The weird thing is, I can still access everything. FTP, Plesk, SSH. Just no my websites.
