-1
votes
0answers
20 views

Two small VPSs or one bigger VPS? [duplicate]

I have a relatively busy WordPress site (http://ndsmcobserver.com). I'm currently on Linode 2GB plan, but performance is pretty sluggish, especially when performing searches and working every night ...
-1
votes
3answers
78 views

Best Apache2 + MySQL config for VPS Server [closed]

I've bought a VPS Server with 1v core and 1GB ram, but yesterday I tried to host a website using Apache2 + MySQL... Everything went wrong! I had around 400 unique vists and the server was dying, full ...
-1
votes
1answer
20 views

How to allow remote connection to MySQL only for specific accounts in CentOS VPS?

I have a CentOS VPS. Port #3306 for MySQL is open for all customers, and they can connect to their databases remotely. As this can be a cause of security issues, I would like to stop all remote ...
0
votes
1answer
79 views

Setting Up a Load Balancer on VPS with Replication

I'm looking for some expert advice on how to go about setting up a load balancer across a VPS, configuring two other VPS for PHP/MySQL replication and then linking them together. I've looked into ...
0
votes
0answers
31 views

ERROR! Server quit without updating PDI file

My hosting provider migrated my vps instance and after the migration I encountered this error. I check the error (/var/lib/mysql/*.err) file and I got this: 140113 11:01:57 mysqld_safe Starting ...
0
votes
1answer
79 views

MySQL Creating a Database CentOS (6 - 64bit) Error 1064 (42000)

When ever I type in : GRANT ALL PRIVILEGES minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '********'; It gives me an error of : ERROR 1064 (42000): You have an error in your SQL syntax; check the ...
-3
votes
1answer
27 views

How many VPS do I need for my website? [duplicate]

I made a website which aims at simulating a trading market. There are a list of prices and corresponding volumes that people want to purchase. Users can purchase at any price any time. My website ...
1
vote
1answer
79 views

PHP + Mysql and memcache or phpsessions

I currently manage a game that handles around 8K daily users, the current server setup is VPS: 16GB+8cores+ 160GBSSD. Handles 8K daily users that are generating 600K daily direct calls to the mysql ...
0
votes
0answers
60 views

Modifying open base directory on Apache VPS server and MySQL problems

I have an Apache VPS server that I'm having some configuration issues with. I'm using an open source PHP social networking program that needs to be able to write to a data directory that's on the ...
-6
votes
1answer
170 views

2GB RAM VPS with LAMP. How can i improve performance and loading times? [closed]

I recently upgraded my VPS(OpenVZ VT) to 2GB of RAM. Despite the configuration changes i make to the LAMP stack the websites loading times take up to 5-10 seconds to fully load. I use prefork with apc ...
0
votes
1answer
121 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 ...
0
votes
3answers
101 views

Best idea for overloaded server, more RAM or new VPS? [duplicate]

I need an idea to solve overloading my server, my server specification: vCPUs: 1 vCPU Memory: 2 GB System Drive: 40GB OS:Linux Ubuntu 10.04 64 bit Software: Apache, PHP, MySQL, and Plesk 11 I ...
0
votes
1answer
43 views

DB Server location in relation to main Web Server

Ive recently taken the plunge and started renting a VPS for my web projects. As the demands on the system get higher so do the costs. MY VPS is US based due to costs, but Im based in Germany. ...
0
votes
2answers
208 views

How would I allow access to a VPS based MySQL database only from AWS East based IPs?

I have a MySQL database on my VPS that I only want to be accessible by my local IP (no problem in doing that) and an IroneWorker Ruby app, which may use any of these AWS East IPs. So far, the only ...
0
votes
1answer
207 views

Error in mysql “max_allowed_packet” VPS godaddy

I am getting error "Serious session error detected. Please notify administrator, this problem is most probably caused by small value in max_allowed_packet MySQL setting. " This error generally ...
0
votes
1answer
173 views

OpenVZ with VSwap causes php-fpm/mySQL errors on nginx

I'm running into a rather nasty issue, and hope that anyone here can help me with a possible solution as I'm pretty much brickwalling right now. The situation: I have an OpenVZ VPS that is ...
0
votes
2answers
480 views

Plesk: access mysql as root

I cannot access MySQL as root on my Plesk 10.x + (Linux) VPS. Apparently Plesk disables the root account and replaces it with admin with the same password as your Plesk login, but access is still ...
1
vote
1answer
239 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
votes
3answers
74 views

Running a LAMP application entirely in memory

Our company uses a PHP/MySQL-based project management app heavily. So heavily that the app is really starting to slow down. It's not that the app is running out of memory -- I never go above 50% ...
0
votes
1answer
128 views

Centos VPS server backup

I have a quick question. I would like to create a backup of my entire centos VPS, including mysql. Would this work? tar -zcvpf /backup/testbackup.tar.gz --directory / Can I restore a tar backup by ...
0
votes
1answer
561 views

Error # 1045 - Cannot Log in to MySQL server -> phpmyadmin

We have installed PHPMyAdmin on a windows machine running IIS 7.0. We are able to connect to MySQL using command-line, But we are not able to connect using PHPMyAdmin. The error displayed is: Error ...
0
votes
2answers
265 views

My VPS is Out of RAM how much to I need more? [closed]

I have VPS server with 1.25GB ram and 0.51GB cache trying to up an e-commerce website with 200k items, db now is about 2gb anything is now works terrible slow now because of lack memory mysql queries ...
0
votes
1answer
130 views

Limit Database Size for a particular Package on VPS with cPanel

Is it possible to limit mySQL database size for a particular package (created via whm)? So we can offer a kind of trial hosting account. Trial should obviously have catches or we won't really earn. I ...
0
votes
2answers
759 views

Nginx + PHP-fastcgi + MySQL on CentOS: 502 Bad Gateway in all files with MySQL connection

I am trying to install an Nginx server with PHP and MySQL on my VPS running CentOS. I followed this tutorial to install all the sofware. he server is running, the virtual hosts are working, but when ...
0
votes
3answers
192 views

Webhost reboots VPS at random times, crashes MySQL table

For one reason or another at random times, my webhost reboots the sever that hosts my CentOS VPS, when this happens it often causes one of my MySQL tables to crash. The table handles the sites PHP ...
0
votes
2answers
441 views

Can I run MySQL and Postgresql together on a VPS?

I'd like to know if anybody has any experience with this. I have a VPS server with ruby On rails, nginx and pgsql. I'd like to use Wordpress on it too, and the biggest issue seems to be running it on ...
0
votes
1answer
144 views

Setting up a dedicated mysql server

I got a dedicated VPS and installed mysql on it(I am new at this). Now from my web server(on a different server), when I make queries it takes 10x longer than it used to take to make the queries when ...
1
vote
1answer
256 views

random high cpu load on linux box

It was all working fine couple of days ago (never jumped above 3.0). But now, the load average for 1 minute jumps well above 10, may hit 20, and then goes back to 5-6, maybe 3. The htop shows me ...
1
vote
0answers
242 views

DB encryption for Django web app without storing key on server

We are setting up a virtual private server (not hosted by us), on which we will be user testing our Django-based web application. The user-generated content produced in these tests will be very ...
0
votes
1answer
230 views

Would it be okay to run Apache on one EC2 instance and MYQSL on another?

I'm currently running a VPS that uses ~1.5GB of ram. I'm thinking of switch to Amazon EC2, because access to our host is pretty slow, lots of downtime, etc. An EC2 small instance has 1.7GB, so I ...
1
vote
2answers
9k views

How to clean up mysql installation on centos

mysql does not exist anymore but when i run yum remove mysql it says that the package is available but not marked for installation, i cannot install new mysql because of that, I need to completely ...
0
votes
2answers
186 views

MySql does not start on Debian 5 VPS server

I have a 128MB RAM VPS server. I have Debian 32bit OS running on it and I have decided to install some light weight LAMP, so I installed lighthttpd and MySQL but then it had to be started It said it ...
2
votes
3answers
526 views

VPS set up for MySQL

Our VPS is set up in such a way that all databases are accessible from any domain via localhost and the username/password/dbname. Is this the usual set up, or should there be some way of 'jailing' ...
0
votes
2answers
311 views

Optimize VPS ( Apache,Mysql,Apc )

I have VPS With this specification: CPU Power 3,000 MHz Guaranteed RAM 1,024 MB Guaranteed FlexRAM* 2,048 MB I have hosted Social Network Script ( Social Engine PHP Script ) This script use Inno_DB ...
0
votes
1answer
290 views

MySQL database server on a VPS: can it handle the spike in traffic I'm anticipating?

I have VPS service with Hostican.com. 2.7GHz CPU, 2GB RAM (level 5, if you look at the site). I have a smartphone app that makes requests to PHP forms, which query the MySQL DB. I'm anticipating a ...
2
votes
1answer
788 views

innodb memory usage mysql

I have a small vps, with only 256mb of ram, with maximum burst up to 512mb. When I configure my vps without innodb, it only uses 130 mb of ram, so that is no problem for me. But when I turn on innodb, ...
1
vote
1answer
956 views

Accessing phpMyAdmin as Admin on Plesk?

I cannot figure out how to login to phpMyAdmin as root/admin on my Plesk VPS? I can log in as individual users but I wish to login as root so that I can play around with privaliages. Any ideas? I ...
1
vote
3answers
2k views

MySQL reserves too much RAM

I have a cheap VPS with 128Mb RAM and 256Mb burst. MySQL starts and reserves about 110Mb, but uses not more than 20Mb of them. My VPS Control Panel shows, that I use 127Mb (I also running nginx and ...
1
vote
1answer
1k views

Reducing MySQL RAM usage on CentOS

I have a vps with CentOS 5 (32bit) and it has 256mb of ram, although not much it is enough for me. On idle with 2 ssh connections active and httpd running it uses about 40mb of ram, but as soon as I ...
0
votes
1answer
300 views

Upgrade MySQL to 5.1 on Ubuntu Plesk VPS

Is it possible to upgrade MySQL to 5.1 on a VPS running Ubuntu 10.04, without breaking Plesk?
0
votes
2answers
714 views

Can't find my.cnf on my VPS

Hello, I am currently renting a VPS for the purpose of host a magento store. The VPS is running Centos5 with DirectAdmin. I have read a bit about how to optimize magento and one suggestion I have ...
0
votes
2answers
687 views

VPS eating up too much memory

I have installed CentOS 5.5 minimal on my VPS. Then I installed mysql (yum mysql mysql-server) and started as a service (service mysqld start) After that I installed PHP (yum install php). And finally ...
0
votes
2answers
451 views

windows VPS running apache and mysql, php scripts running slow.. but cpu usage is 1-3%

So every night I run some cron jobs. It requires probably about 20 min to process all the records. I gather the script does something like 10,000 sql queries. I figure this task was just that ...
-1
votes
2answers
1k views

update mysql latest version from yum

I want to update mysql in my VPS from yum. However I only got 5.0.9 mysql version Which repository should I add to get mysql latest version. at least 5.1? (CentOS) Thank you
0
votes
1answer
1k views

VPS 512 MB RAM with WordPressMU comes to consumes lots of memory

I have googled for days and gathered all optimization suggestions and tried. My sites are not getting any high hits. May be like 100 hits per day [all my sites combined]. Here are my specs I have ...
0
votes
1answer
326 views

cannot create database as root in phpmyadmin

I just got my VPS, I login to phpmyadmin as root but I cannot create a database, I can't even see a link for this. I also want to change other user's permissions but I cannot find out how to.
1
vote
2answers
947 views

Cant connect to MySQL server from Java application

This is on VPS\Centos server. The MySQL server is pre configured. I am running the Java application on Tomcat My Java web application is not able to connect to the MySQL server. I get an error - ...
1
vote
1answer
406 views

Network architecture when using Rackspace's Cloud

I'm planning on launching a web application soon, and have decided on using Rackspace's Cloud offering with Debian. I'm not expecting that much traffic to start, but would rather get the architecture ...
1
vote
3answers
193 views

Does my top indicate I need to optimize apache or mysql?

Take a look at this: http://img.skitch.com/20100214-pf95t9dpywxqgne7wrk65nnhq5.png After taking a look at that would you be able to say I need to optimize or am I doing ok?
2
votes
2answers
6k views

allow remote mysql access on centos

I am relatively new at using linux and was wondering how hard it would be to allow remote access to mysql on my vps and if it is worth me doing for my needs. The reason that I am asking is that I ...