0
votes
0answers
26 views

User Uploaded Images– Blank Post – Connection reset by peer / FastCGI: incomplete headers

To give a little background, I have a website that permits users to upload images. WordPress is used as a content management system and the posts are immediately published with the image inserted as ...
1
vote
1answer
54 views

Apache MySQL Server Crashing - Large number of connections from localhost

I'm running a 2GB Centos 5.9 server with the standard LAMP setup. I'm running a wordpress website so it's nothing to demanding performance wise. However the MySQL server seems to keep crashing as I ...
0
votes
0answers
96 views

Where does ISPConfig store the MySQL credentials?

I need to know where ISPConfig keeps the rest of its MySQL credentials So, we reset the root MySQL password, and ever since, whenever I try to install wordpress via ISPConfig , it gives me ...
0
votes
1answer
35 views

Please help me to configure my server to give high performance for wordpress [closed]

I am using 2GB ram,2 core XEON processor. I want to configure my Apache, MySQL and PHP for giving me high performance, as of now when i try to test my server with stress test , it is breaking down ...
0
votes
0answers
114 views

Wordpress uppon connect causes php5-fpm cpu 100%

'm administering Debian jessie VPS (2GHz, 1,4GB RAM). Since yesterday have terrible problem, can't even imagine what is it. So, my config is NGINX + PHP5-FPM and Wordpress on top. Now, I've tried: ...
-3
votes
1answer
604 views

Can a MongoDB replace a mysql database [closed]

If I will create a WordPress blog that uses mysql, can I use MongoDB instead of mysql?
0
votes
1answer
52 views

Nginx cache entire site while performing MySQL maintenance

I currently have a high traffic WordPress site that is entirely static. But it currently generates each page via the MySQL database anyway (I know I should be caching content). I will be moving the ...
1
vote
1answer
255 views

MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

Trying to install MySQL (for WordPress) on a CentOS 6.4 /64 bit server. I have installed the mysql-server-5.1.69-1.el6_4.x86_64 package and executed the following commands: # chkconfig mysqld on # ...
0
votes
1answer
66 views

wordpress cannot connect to remote azure centos virtual host

I have two windows azure CentOS hosts in the same affinity group and on the same private subnet. I am unable to get wordpress to connect to the db from the apache webserver. I continually get "Error ...
0
votes
1answer
140 views

I moved my (wordpress) site to a new server. Why adminer cannot login to MySQL?

I just moved my wordpress site to another vps. Everything worked fine and i used sequel pro to connect to database (via ssh) and import my data. The strange thing is that i tried to connect to MySQL ...
1
vote
1answer
470 views

Centos MySQL optimization 4gb ram

I am using Centos 6 64bit on vps with 4gb ram. 1 wordpress website and 2 wallpapers script websites. Wordrpess have 10k visits daily. Site is slow. My.cnf # Example mysql config file for large ...
0
votes
0answers
296 views

odd “waiting for localhost” loading delay on wordpress ubuntu 12.04 server LAMP install

I have just installed wordpress (last version) on /var/www/wordpress on a default ubuntu server 12.04 LAMP installation. Every time I want to load something on this wordpress (even the login screen) ...
-2
votes
2answers
44 views

Recommended UNIX user for CMS access to MySQL [closed]

This article recommends the UNIX nobody user to access MySQL from Joomla scripts. Is this standard practice? Moreover, is it reasonable to use it, say, both for Joomla and WordPress?
1
vote
1answer
256 views

MySQL is too slow on Windows VPS

I'm running a wordpress blog on my VPS, But MySQL Queries are taking too much time. For example, it is taking more than 1.5 seconds to load a post from database. But CPU and RAM usage is low on my ...
1
vote
1answer
411 views

Wordpress : Shift from local MySQL to Amazon RDS Mysql?

i have a 32 bit Bitnami ubuntu wordpress stack ami for amazon and hence a working wordpress installation. My questions are 1)How can i shift over to amazon RDS mysql from local MySQL. And if more ...
1
vote
2answers
225 views

Nothing Can Access MySQL

I have been trying to install WordPress, but I get the error, "Error establishing a database connection". I realize this is a common error, but after a few hours, I haven't found any solutions that ...
1
vote
3answers
388 views

Install wordpress using amazon RDS

Now this is weird! I am trying to install a WordPress website on a Amazon EC2 server with Ubuntu 12.04 LTS and [amazon RDS][1] database service. I have installed apache and wphp and ran the required ...
0
votes
1answer
488 views

Ways to go about optimizing website performance WordPress, Amazon EC2 Apache and RDS MySQL

I have 6 WordPress websites running on 1 single EC2 instance. All the the websites are connecting to databases in 1 same RDS instance. Earlier today, traffic to the largest website peaked and the ...
2
votes
1answer
2k views

With WebMatrix, How do I Connect to a MySQL Database on a Colleague's Machine? [closed]

I have scoured Google trying to discover how to do this, but essentially I want to connect to a colleague's MySQL database for working together on a Wordpress installation. I am having no luck and ...
2
votes
1answer
334 views

Periodic MySQL lockup when Wordpress is under heavy load

(Wasn't sure if this was a ServerFault question or StackOverflow, so please forgive cross post) I have a MySQL 5.1.61 database running behind two load balanced Apache webservers hosting a fairly busy ...
1
vote
1answer
158 views

How can I narrow down why Apache randomly stops serving pages?

I am running a Turnkey Linux LAMP stack (based on Ubuntu). The server is hosting a relatively large WordPress installation with a pretty hefty amount of allocated RAM (on a dedicated machine). We get ...
1
vote
2answers
111 views

What is the most secure way to set up a mysql user for Wordpress?

I am setting up Subdomain based MU on my domain.Everything is hosted by me running on one CentOS/Webmin VPS. Will I be better off setting the MySQL user's domain as localhost, 127.0.0.1 or with a ...
1
vote
1answer
138 views

Apache - vhost file permissions not working properly using www-data group

I'm setting up a vhost with ftp access. I've a FTP user ftpuser, which is chrooted to its home directory, then I set up the vhost making it point to /home/ftpuser/. I've added ftpuser to www-data ...
0
votes
0answers
32 views

WP RECOVERY unable to link DB to WP 'Error establishing a database connection'

I have the following error. Error establishing a database connection I have a WP +BP + Faecbook site that is down. I had a recent backup before I made the changes. I am tryng to restore that. I ...
0
votes
1answer
82 views

MySQL broke; how can I save some of the tables?

For some reason my MySQL can't connect any more. I'm running three WordPress sites and I need to save the tables. That's what I really really really really care about. Here is the problem: ...
4
votes
1answer
199 views

What privileges does a MySQL User need for Wordpress?

I need to create a new MySQL user to manage my wordpress site. What privellages are needed for wordpress? I assume INSERT is also needed and maybe DROP? Example GRANT SELECT ON database.* TO ...
1
vote
1answer
4k views

MySQL, php-fpm, APC, Varnish and Nginx optimization for WordPress/W3 Total Cache?

I'm setting up my first VPS and it seems to be working well. Installed Nginx, php-fpm (as a unix socket), APC, Varnish and MySQL on Ubuntu 12.04 server with OnApp, and everything works and is damm ...
0
votes
1answer
437 views

SFTP authentication with credentials in Wordpress MySQL database?

I'm trying to find a solution that will allow for a user to connect to a server via SFTP using a provided username/key combination (stored in a Wordpress installation's MySQL database), without ...
0
votes
1answer
79 views

mysql tables strange behaviour

i have a wordpress driven web site. i am having a very very weird issue. i am clean installing my wordpress, using it about a week or so then i am losing admin rights in wp-admin. i can login with my ...
-3
votes
1answer
163 views

How scalable is mySQL server? [closed]

I am debating on whether I should have three separate wordpress installs with three separate databases, or whether it would be okay to use multisite (which only uses one central db). I am concerned ...
1
vote
1answer
330 views

Server hitting high loads and becoming very slow

all. I recently installed WordPress on a server of mine and ever since then my server has been acting very sporadic and becoming extremely slow-- sometimes even hitting a load average of 20!! At ...
0
votes
2answers
229 views

nginx + MySQL + php5 + Wordpress: Too much php5-fpm processes

I have this web server running on nginx + MySQL + php5 + Wordpress. The thing is, the server is to slow and I think it's due to the number of php5-fpm running. Look at the numbers of php5-fpm ...
0
votes
1answer
43 views

'Database error' for a wordpress blog hosted on a server

I've hosted my site on a server provider that I got cheaply. Recently when the traffic to the site increased suddenly I started getting a Database Error and when I try to login to the wordpress ...
0
votes
2answers
437 views

Wordrpress with PHP 5.3

I'm trying to install Wordpress 3.1 on PHP 5.3 (under IIS 7.5), but before getting to the configuration page it's throwing this error: Your PHP installation appears to be missing the MySQL extension ...
2
votes
3answers
2k views

Replace text on MySQL - Wildcards to replace certain variable parts?

I'm trying to apply a text replace on my WordPress MySQL database. I need to delete part of the current images html code, but this part of the text is variable, althouth there is a part that never ...
1
vote
1answer
295 views

MySQL not accepting connections from WP

I have a few servers running WordPress. I am using IIS with MySQL. One keeps faulting; I reset the MySQL server and it works well for a few hours and after that I start getting "Error establishing a ...
0
votes
2answers
238 views

Best way to merge MySQL databases and Wordpress files in a cross-platform dev. environment

SETUP Development server (testing environment): Windows 7 with XAMPP, Visual SVN Server and Trac Live server (staging and live environments): Amazon EC2 with Ubuntu 10, Apache, PHP, MySQL and ...
3
votes
1answer
611 views

LAMP memory management (CentOS)

First of all, I have to say I am not an expert in server administration. I have done web programming for 10+ years on several platforms, but have most of the time come to a readymade situation where ...
0
votes
1answer
178 views

Dedicated MySQL Server for Large Wordpress Site Memory Usage

Preface We are currently using Rackspace Cloudsites to host a very large WordPress Membership Content site using WishListMember. This setup is kind of slow for the price we pay for it, as Rackspace's ...
0
votes
2answers
2k views

MySQL, replacing   with… nothing (delete those, please!)

I'm trying to purge my WordPress content from "false" carriage return (CR). These are caused after a migration of my content, that now presents from time to time a   code that makes the web ...
1
vote
3answers
698 views

Having trouble keeping a 1GB RAM Centos server running

This is my first time configuring a VPS server and I'm having a few issues. We're running Wordpress on a 1GB Centos server configured per the internet (online research). No custom queries or anything ...
1
vote
3answers
471 views

Replace text with spaces in MySQL

I'm trying to do a global replace of search in my database, which has a lot of articles with a double carriage return because of this code: <p> </p> I'd like to replace this in my ...
1
vote
2answers
736 views

MySQL/Apache: Replace spaces with underscores only in certain URLs

I'm having a problem with some images I'm using on my WordPress blog. After a migration I renamed every image replacing spaces with underscores, so HIDDEN_264_4062_FOTO_IDF los MID.jpg was renamed ...
0
votes
2answers
2k views

Drupal7 doesn't detect MySQL on CentOS, but Wordpress3 does?

I'm running CentOS 5.5 here with Apache2, PHP5.3.3, and MySQL 5 (Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1). My wordpress install on the same system runs perfectly, but ...
2
votes
4answers
1k views

Mysql high queries per second, with high cpu usage

I have a dedicated server with 4gb of ram and a Quad core Xeon cpu, serving a site with 350k pageviews a day using the wordpress script. The problem is, mysql is eating loads of cpu, and on ...
1
vote
3answers
205 views

Wordpress on shared/grid hosting

I'm running a basic WordPress site on a GoDaddy Grid Hosting account and the load times are just terrible (5-15 seconds). I'm considering moving it to an older GoDaddy account I have that still uses ...
0
votes
5answers
1k views

Tuning Apache/MySQL/PHP for Wordpress

I am trying to figure out why my apache processes are eating so much memory My slice specs( 1.5GB RAM, CentOS 5, Apache2, PHP 5.2, MySQL) As you can see my top processes are consuming nearly half of ...
0
votes
1answer
238 views

mysql config wordpress high loads

My query ./mysqlslap --user=root --concurrency=50 --iterations=1 --pass=toor -vv --create-schema=db --query="SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON ...
0
votes
1answer
58 views

Slow to non-existent MySQL on Fedora?

I have a VPS with a few low-traffic personal sites on it, two of which run Wordpress. Occasionally the Wordpress sites just don't want to load. They've taken a minute or more to load. Sometimes I can ...
2
votes
1answer
1k views

How to make mirror of current running wordpress site on same server?

For example: I have a wordpress site(blog) on www.xxxxxx.com I want to upgrade some plugins and WP version of site but before it i want to check all things on a mirror version. How to make a mirror ...