How To "Reduce Your SELECT DISTINCT Queries Without LIMIT Clauses"
Mar 28, 2009i want to edit "Reduce your SELECT DISTINCT queries without LIMIT clauses" in my my.cnf.
View 1 Replies
ADVERTISEMENT
What Difference Between "desktop"、"work Station"、"server" Board
Jun 9, 2008we may class the board into "desktop"A"work station"A"server" board,
i know they have price difference,
i want to ask any other main difference of them?
"Can't Connect To Local MySQL Server" + "IPS Driver Error"
Jun 4, 2007During 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.
APC :: Shows "timeout" And "out Of Memory" Errors With Php Scripts
Nov 9, 2009We have installed APC 3.1.3p1 beta (and also 3.0.19 stable seperately, to test) and we are seeing a lot of "out of memory" and "timeout" errors. For example, a php scripts dies saying the available memory is 256Kbytes, and the script tries to allocate 256 Mbytes of memory.
Here are the APC settings:
[APC]
apc.enabled = 1
apc.shm_segments = 1
apc.shm_size = 128
apc.max_file_size = 8M
apc.stat = 1
and PHP settings related to memory is
memory_limit = 1024M
We have tried included apc.php file to watch out the cache, but it doesn't show any kind of fragmantation or etc. related with system, instead it shows "timeout" and "out of memory" errors with php scripts.
We have thought that the error can be related to /dev/shm as you should increase apc.shm_size in order to obtain more memory, therefore we have mounted /dev/shm as 4Gbytes. The server has 8Gbytes of memory (using 64-bit CentOS).
Note that once we set apc.enabled = 0, the problems go away, so it's definitely something with APC.
Any Way To Stop Spammers From Forging The "From" Or "Reply To" Fields
Mar 28, 2008possible way to stop spammers from forging my website's domain in the "From" or "Reply To" fields? I just received 1700 bounced e-mails in my inbox from spammers using my domain in the "From" address. Really freaking annoying, and I don't want my website to get blacklisted.
View 6 Replies View RelatedKazix / Fatnetwork / "Mark" And "Jacob"
Mar 1, 2008A year ago I started up a website for me and some friends. By the end of last year ( December ) the website had died and I knew that I ( being a broke college student ) wouldn't have the funds to pay for a renewal.
I contacted Kazix and told them I was having trouble figuring out how to cancel my account and asked if they could do it for me or inform me how. I received the following email on Dec 18th 2007:
"Sir,
As soon as the hosting is about to end. You will get notice from our billing department.
-- Regards, Mark Senior Administrator fatnetwork.net/"
I figured this email would tell me how to cancel my account if I did not wish to renew it. I never received such an email.
I found out Friday that my banking account was over-drawn. I thought this was through my own error, but when I looked closely today, I noticed it was because 2co.com, the third-party billing company used by Kazix/Fatnetwork, had charged me for hosting renewal and had caused my account to go negative.
I sent them an email informing them that I had asked back in December for my account NOT to be renewed and that they had in fact went ahead and renewed it anyways. I requested that they reimburse me the charge of the domain, hosting, and overdraft. I had wrongly thought that my domain name was processed through them as well.
I received an email from billing@fatnetwork.com saying:
"Your domain is not registered by KAZIX only hosted
See WHOIS by yourself
The respond you got not from us from GoDaddy your domain registrant
( Who is removed )
You never requrested a cancellation from us blame yourself for over drafting, you should know where your account hosting with
Ill refund the charge of $44.99 and cancel the 2CO subscription as well as your account with KAZIX thats all I can do for you"
I wasn't really expecting them to reimburse my overdraft charges ( really, why should they pay for their mistake that harms others? ). And I fully admit that I did honestly forget that my domain name was registered by my husband and not by Kazix. What did surprise me was the tone of the email. I did use the Kazix's contact form on their website to request that my hosting be stopped. Why would I contact Go-Daddy if I had completely forgot that they were the ones in charge of my domain? If I hadn't contacted Kazix, why did Mark send me an email from fatnetwork in response to my request to cancel my account? Yeah. Someone was just being rude and snippy because they didn't want to admit that they made a mistake.
I sent a reply back to the rude man and informed him that I found his email to be very rude and not a good way to handle customers. I also informed him that I did use the contact page on Kazix's website and that I fully knew who my hosting was through.
I received this email as a reply:
"Im sure you have some other things to do Saturday night not only be rude
Ive responded you( from home, because billing is working only Mon-Fri )
Ive refunded your charge immediately
Im very glad you are not our customer anymore
Have a great weekend
Jacob
Billing Department"
Me and my husband were both floored when we read this. Who would handle customer support this way? I couldn't believe that he would have the gall to call me rude just for me pointing out his own rudeness. Then of course there is the nice touch of "I'm very glad you are not our customer anymore." Could you imagine someone in retail or any other face-to-face business practice saying this to you?
You know I didn't leave Kazix because I found it to be "bad." I just left it because of my own financial reasons. I had some technical problems with them before and found them to be helpful. If I hadn't experienced all of this, I probably would have recommended them to others and used them again. Now? I seem them as a shady group of characters who care more about their customer's money than they do about their actual customers.
As I see it now, they obviously did not want me to cancel my hosting with them and obviously wanted to renew my account for the money. What about my say in not wanting their services anymore and wanting to keep what little money I had left in my checking account? It didn't matter.
Stay away from Kazix and Fatnetwork. Let my bad experiences be your warning.
"no Longer Listening On" "named" /cpanel
Jul 5, 2008i install cpanel on my server
i have problem with dns ( ping)
i restart named and take this message: ....
What Should I Do On Server To Make Url On Archive With "/" Not "?"
Mar 10, 2008I has changed my server before 5 day ago
I note there are something error on my archive page
it was like this before I change my server
www.3walim.com/archive/index.php/t-7439.html
not if you use url above it will redirect you to vbulletin/archive/index.php
but if you make url as this
www.3walim.com/archive/index.php?t-7439.html
it will work right
the problem is now I have more than 40 K of page on google indexed with "/" so and google will remove it cuz all page it now redirect you to archive/index.php not to threade
I open ticket and they tell me vbulletin not have any thing to do to fix it it must doing from server
Disabling Fopen("/etc/passwd","r");
Jul 18, 2007I were seeing c99.php source code to know how it gets /etc/passwd file. it simply uses fopen() for this goal but I think fopen() is needed and I don't like it to be disabled in disabled_functions. I wonder how can I disable just fopen("/etc/passwd","r"); without doing any restriction to fopen function at all
View 8 Replies View Related"Intel P4 3.4dc" Versus "INTEL CORE 2 DUO E6600 2.4GHZ"
Apr 23, 2009I have currently a server with a "Intel Core 2 duo e6640 2.4Ghz".
Now the company I'm at moving to a new data center and offering me a box for the same price with a Intel P3.4.
As I understand I would move from a two core to a single core CPU.
In the first move letter they send me, they where saying I would get a CPU plus, plus 1 GB mem more.
[cPanel]: "httpd Not Running, Trying To Start" And "httpd Could Not Be Started"
Sep 1, 2007I trying:
Code:
[root@serwer /]# httpd restart
/usr/sbin/httpd restart: httpd not running, trying to start
/usr/sbin/httpd restart: httpd could not be started
Code:
[root@serwer /]# /etc/rc.d/init.d/httpd configtest
Syntax OK
Help
Which To Select, Bluehost And Hostmaster?
Sep 26, 2009which to select, bluehost and hostmaster? there are all excellent, which to choice? what the diffrent between them?
View 13 Replies View RelatedSelect: HostGator Or HostRocket?
May 5, 2009Was actually wondering what you guys recommend as far HostGator Reselling opportunity vs HostRocket re-selling opportunity. I came prepared for this questions, so here are my goals:
Goals:
Long Term - I've biz established already and would like to add hosting as unlimited bonuses and even start a hosting business slowly as my own forums start to pick intensity
The 24-month option of HostRocket seems irresistable with unlimited bandwidth and 1tb of space (as their chat), kind of skeptical as it isn't in writing, but it seems they have a better offter at first then Hostgator, but they don't provide a billing system like: whmautopilot. PL nameservers are also $2/month with HostRocket, but Hostgator reseller options has them included.
Select: HostGator Or Bluehost
Jun 8, 2009Was actually wondering what you guys recommend as far HostGator Reselling opportunity vs Bluehost re-selling opportunity. I came prepared for this questions, so here are my goals:
Goals:
Long Term - I've biz established already and would like to add hosting as unlimited bonuses and even start a hosting business slowly as my own forums start to pick intensity
The 24-month option of Bluehost seems irresistable with unlimited bandwidth and 1tb of space (as their chat), kind of skeptical as it isn't in writing, but it seems they have a better offter at first then Hostgator, but they don't provide a billing system like: whmautopilot. PL nameservers are also $2/month with Bluehost, but Hostgator reseller options has them included.
HDD Partitioning With 2 HDDs + CentOS V. Select
Aug 17, 2008I have 2 questions:
1) I have one 80Gb HDD and one 250Gb HDD ( all are s-ata ).
In which practical way they should be partitioned? I thought to setup OS on 80Gb HDD and /home on 250Gb HDD.
2) Which version of CentOS is currently the most stable for cPanel? I had an experince with CentOS 5, there were various problems with mail and mysql.. And now I want to install CentOS 4.6.
The server will have CentOS and cPanel installed.
State Sbwait Lockf Select
Jan 8, 2007explain me state table parameters when you run TOP ?
sbwait lockf select
I could find info about them in MAN
Plesk 12.x / Linux :: Select PHP 5.6 After Install
Dec 8, 2014I have installed PHP 5.6 following this guide (enabling php 5.6 in remi) but I can't select the new version of PHP from hosting settings page in domain administration. What is ionCube?
View 5 Replies View RelatedPlesk 12.x / Linux :: FTP Backup - Can't Select Objects
Sep 9, 2014I'm using the latest Plesk and I'm trying to backup to an FTP server. I'm assuming the backing up went well because I see the file on the FTP server.
1. In Plesk, I'm seeing this - Restore the backup file despite a corrupted signature. Q: What does this mean? How do I avoid this?
2. What do you want to restore? - You can select objects to restore only when you are restoring from backups that were created in Plesk 12.0 or later.
Q: I created the back in Plesk 12.0 or later, but the option for me to select objects is greyed out.
How Can I Reduce My CPU Usage
Mar 18, 2008Last year my web host stated that my site was over utilizing allowed resources for my plan. Specifically, they state that I was overusing the CPU. At the time, I had to upgrade my plan in order to stay online. I would like to move to a new host, but the prospective hosts are all suggesting a dedicated server because of my CPU usage. I don't want to pay that kind of money, so I would really like to curb the CPU problem. Does anyone know how to reduce the CPU of a Wordpress blog? I tried posting this question over at Wordpress.org, but I haven't received a single reply.
View 11 Replies View RelatedApache :: How To Select Specific File With Path Using HTAccess
Jun 14, 2014I want to select a specific file by its path using .htaccess to allow access to it.
View 1 Replies View RelatedPlesk 11.x / Windows :: Select Existing SSL Certificate For Domain
Oct 20, 2014I added a new SSL certificate in `Plesk -> Tools & Settings -> SSL Certificates` and now want to link an existing domain to it.
However, on domain SSL Certificates page, the only option displayed is to create a new certificate. I can't select one of the existing ones.
Am I missing something? How can I link already added SSL to a domain?
VPS Providers! What's Your Take On "write Back" & "write Through"
Oct 9, 2009I recently worked on an issue involving a severe performance issue between "write back" and "write through" caching on the RAID/HD.
Long story short, we purchased 12 IBM x3550 M2s came with LSI SAS1068E/SR-BR10i (gimp redheaded stepchild of the MR series. No BBU, no onboard DIMM.) RAID controller and had very bad and inconsistent write throughput with it. Sometimes it writes out 300-400MB/s (dd test, I know... don't flame. I know dd is NOT a good test.), somethings as low as 30MB/s. The server is configured with 2.5" SATA 500GB on HW RAID-1.
From dmesg log it was default to "write through" on sda. I figured out via lsiutil, you can set the drives to "write back". Once we did that, the write performance is more consistent. NOTE, this enables write back on the SATA drives, NOT the controller itself.
I loop out lspci on all our VPS servers. Found out those with LSI (SAS 8344ELP) cards have sda set to "write through w/ FUA". Those are already all RAID-10s, and I have not heard a single complaint from any customer stating poor I/O performance.
I believe the 8344ELP do have a BBU, I can double-check with DC. The DC is on UPS as well. So that rules out the shortcomings of enabling write back caching.
I want to ask those of you using Xen (3.3 & 3.4). Do you guys have better I/O performance with "write back" or "write through" caching? I'm actually looking for real world results. Where you guys actually deployed production VPS server with clients on it.
DNS Queries From Our Server
May 10, 2007We host our DNS with DNSmadeeasy.com. We noticed that the number of DNS requests is too high. So we decided to contact their support and ask them for log file, so we can determine
what's going on.
Reply we got from them is the following:
We researched your queries and we found that many of them were coming from the SoftLayer resolving name servers. We phone their admins to report the abuse and they said that the queries were infact coming from your own server with them.
We will not charge for any overage on the queries this month so you can research what on your server is causing these queries. But we will provide you with logs of about 5% of our your traffic.
here is the example of the line from log file sent by them:
May 10 17:15:48 t145 named[29945]: client 66.228.118.72#52529: query: host-196.218.57.145.tedata.net.mydomain.com IN AAAA -E
May 10 17:15:48 t145 named[29945]: client 66.228.118.72#52529: query: afontenayssb-151-1-40-153.w83-114.abo.wanadoo.fr.mydomain.com IN AAAA -E
I changed the real domain name to "mydomain.com"
I checked the apache access log and found these hosts there in exact order as they are in log file sent by dnsmadeeasy.
What is strange is that why is my server making back these requests ? Also these requests are bad because these are not valid domain names:
e.g. should be "host-196.218.57.145.tedata.net" instead of "host-196.218.57.145.tedata.net.mydomain.com"
Seems that it includes ".mydomain.com" to the end of every request.
Is there a way to discover what is making those DNS queries?
Dnsstuff Queries
Jan 19, 2007how can i run queries in dnstuff.com
for examlpe we can run following query for DNS Lookup MX record
Code:
nslookup -q=MX www.webhostingtalk.com
ISP Cached DNS Lookup =?
E-mail Test = ?
ISP Cached DNS Lookup =?
Redirect NS Queries
Jun 13, 2007I have 2000 domains set to
NS1.anydomain.com NS2 etc
Is it possible, through some script or otherwise, to send the traffic to certain/chosen domains to a completely different set of nameservers.? Preferably without having too much server load?
I already use a domain catchall, so no NS records are actually registered on the server.
High CPU Usage How To Reduce It
Mar 18, 2008My server details
Intel 2.4 Ghz P4 Celeron
os-redhat
RAM-2GB DDR
harddisk-160+50Gb
bandwith-3000Gb
now iam haveing more that 0.50-1.20 cpu useage,also cpu useage is also increased i hosted only 6 site out what only one site use MSQL all other site are plain download site,how to reduce the cpu load can u figure me out this issue also give me some tips to reduce the cpu usage
How To Reduce Apache Process
Jul 3, 200813438 nobody 15 0 42276 22m 13m R 22 2.2 1:51.94 httpd
10620 nobody 16 0 41928 16m 8468 S 19 1.7 0:28.54 httpd
11397 nobody 15 0 41524 12m 4784 S 18 1.3 0:06.04 httpd
10745 nobody 15 0 42376 14m 5316 S 17 1.4 0:06.62 httpd
The values in bold are the CPU percentage taken up by each apache process.
So i had to need to each apache process,who can i reduce it?what config i have to change to reduce it?
Reduce Backup Load
Jul 6, 2008we have a dual xeon 2.8G +2G ram CPANEL server normally load is well under2 and stable
we also use Incremental Backup and choose Per Account Only for MySQL backup
This server mainly hosts a big site, whose SQL is 1.2G big
Everytime server is running backup, load burst to 7 and accessing to website hanged. We are thinking to change SQL backup method to Entire MySQL Directory , but was told while it is processing SQL server will be stopped ?? wil Entire MySQL Directory reduce server load while processing SQL backup?
Any Way To Reduce Tcp Time_wait Period On A VPS
Jul 7, 2007apparently the sysctl commands / config does not work for VPS's. any way to reduce the time_wait period? got nearly 900 connections in that state!
View 0 Replies View Related
