0
votes
1answer
26 views

mysql client won't run on my Ubuntu instance

Running a LAMP server on Ubuntu 12.04. Trying to run mysql from the command line like so: root@server:~# mysql -u 'wp-user' -p and I'm getting mysql: ambiguous option '--v' (vertical, version) ...
0
votes
1answer
83 views

Xubuntu Desktop 14.04 - service mysql start unknown job

I installed fresh XUbuntu desktop 14.04 (as a dev system) and then lamp server using sudo apt-get install lamp-server^. I can type mysql and mysql console run but if I try service mysql start I got: ...
-3
votes
1answer
58 views

Improve LAMP performance Ubuntu 12.0.4 [closed]

cpu 1.3% mem 476/490MB swap 347/511mb tasks: 43, 29 thr; 1 running load average: 0.10 0.08 0.06 via htop:<br> /usr/sbin/apache2 -k start (listed 8x @ 8.1% mem each) /usr/sbin/mysqld (listed ...
0
votes
2answers
21 views

Distributed LAMP vs DB and Web Server same box

We have a very read heavy semantic web (RDF) application which is RHEL 5/Apache 2.2.3/Tomcat 6/Java 6 on one Server, and MySQL 5.1 on another. Apache and MySQL are backported Red Hat repo stuff, so ...
0
votes
1answer
47 views

How to determine what memory was freed

We have a somewhat complex LAMP stack running a variety of websites using Litespeed instead of Apache on Centos 5. Once everything is up and running, the memory usage of the system is fairly ...
1
vote
4answers
120 views

Setting up dev environments with big databases

This is my first time here. I recently joined as a system admin at a company and my recent assignment is to make friendlier dev environments for our devs. Until now our devs connect to our remote box, ...
2
votes
1answer
53 views

Need advice on documenting LAMP web site

I need to document my web site. It is a music web site on Linux/Apache/MySQL/PHP on AWS. I need to document everything: architecture (5 servers), database (100+ tables), php classes, programming ...
0
votes
1answer
72 views

server out of memory - mysql processes?

I have inherited a system build in PHP (LAMP) and it keeps going offline due to running out of memory every week or so. There's 4gb of RAM available. I've asked my hosting provider twice to look in to ...
0
votes
1answer
81 views

Optimal setup for bulk CSV import

We're currently running a Wordpress site but need to import 10,000 - 20,000 posts per day from CSV files. Our current setup is an all-in-one LAMP server with 8GB RAM and 8 Virtual Cores. The import ...
0
votes
1answer
101 views

LAMP stack everything seems to be working except sites are blank

I have a LAMP stack, Ubuntu 12.04.3 LTS PHP 5.3.10-1ubuntu3.8 with Suhosin-Patch (cli) (built: Sep 4 2013 20:05:42) Apache/2.2.22 (Ubuntu) MYSQL 5.5.32-0ubuntu0.12.04.1 (Ubuntu) Codeigniter 2.1.0 ...
0
votes
2answers
159 views

MySQL geographic replication cloud

I currently have a standard local LAMP setup, (2 web servers, master/slave MySQL, load balancer). This is severing me well locally, but my global users experience slowness. I want to setup some ...
-6
votes
1answer
208 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 ...
1
vote
3answers
534 views

MySQL server keep on crashing

I'm facing a problem that i can't figure out, for some reason my MySQL server keeps on crashing after 30-40minutes the server load itself isn't too high, it's not even 0.5 (for 2 cpu machine) i've ...
0
votes
0answers
152 views

Mysql won't start after replacing data in datadir.

so I have a little problem. I had errors with our old system and was unable to backup the old databases properly so I went ahead and backed up the datadir which had all of the databases folders inside ...
0
votes
1answer
65 views

Table Locking - Large number of inserts - How do I identify the source of the inserts?

I usually post on Stack Overflow, but I think this may be the more appropriate forum for this question.... I have a dedicated server that servers several million pages monthly. We use LAMP. We're ...
0
votes
2answers
58 views

Testing after migrating LAMP install on CentOS 6

I copied the /var/www/html/site directory to a new server and all of the /etc/httpd conf files, installed the necessary Perl modules, php, and ran cat mysqldumpfile.sql |mysql db_name to import the ...
0
votes
1answer
133 views

MySQL using large amounts of CPU while idle

A webserver (Apache + MySQL) locked so badly that I had to powercycle it, and immediately logged in to see what was going on afterward. Load average was over 3%, with MySQL hovering between 20% and ...
0
votes
1answer
104 views

mysql 5.6+ lamp AMI

I used couple of ec2 instance, ebs etc. Now I need to configure new system, and I think AMI search sucks! What I need is Ubuntu,64-bit, ebs mount, lamp+phpmyadmin, MySql Version > 5.6 . Is there ...
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) ...
0
votes
3answers
293 views

MySQL reinstall questions

For some reason my /var/run/ dir on debian6 had it's chown and chmod changed. Problem is from what? Outcome is that mysql fails. I'm guessing the easiest way to fix is to reinstall MySQL. (Previously ...
0
votes
2answers
134 views

Mysql very slow, out-of-the-box configuration

I just installed AMP stack on a VPS. I logged in to mysql console and found out that queries were incredibly slow. A single update query, targeting 1 row in a table with ~200 rows took 0.5 seconds to ...
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
votes
2answers
783 views

MySQL 5.5.27 crashes randomly on centOS 5

I am using godaddy's dedicate server to host my web application, it's centOS 5(I have no idea why they are still using this.), I installed mysql in that server, everything was running OK since one ...
1
vote
1answer
88 views

Best way to Install Lampp setup on Ubuntu

What is the best way to install a lampp setup in ubuntu? I know to install using xampp. Is it ok for using as a central development server? Or if am installing individually what are the packages i ...
-3
votes
1answer
184 views

LAMP servers performance: Can I improve them by adding more RAMs? [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Web Sites Let me refine my questions: 1. How can I improve MySQL performance? 2. Will adding more RAMs help? 3. Will ...
2
votes
4answers
2k views

Need working guide to install latest Apache or Nginx, PHP & MySQL for production

Ok I'm told the best and easiest way to install Apache/Nginx, PHP, MySQL for production these days is to pull in the software using apt-get or similar package manager for your specific distro. The ...
1
vote
2answers
86 views

What is the recommended linux user to create MySQL databases under LAMP?

I'm trying to set up a simple LAMP system while keeping some basic security in mind. If I want to create a MySQL to be accessed by PHP, under what user should create databases? Any references to best ...
1
vote
3answers
476 views

Cannot Log Into phpMyAdmin - Nothing Happens

I'm running a simple LAMP server at home from which I host a personal blog. The server is running Arch Linux, with the latest-and-greatest versions of Apache, MySQL, and PHP. In order to easily ...
1
vote
1answer
3k views

How to install mysqlnd for php 5.3.3 on Centos 6.2

I have just down graded my PHP-installation from 5.3.9 to 5.3.3. This in order to be able to use yum/EPEL instead of compiling everything myself. Appearently, mysqlnd-support isn't available in ...
0
votes
3answers
268 views

Database server, Webserver - RAM versus Server Load relationship between servers

We have a website running on 2 servers: 1 database server, 1 webserver. Our understanding was that we had 4GB RAM on the webserver and 8GB RAM on the database server. The site is database intensive ...
0
votes
1answer
71 views

Shared Hosting using Linux [closed]

I am planning to set up a server hosting multiple websites on a single high-end Linux server on Virtualization-enabled Hardware using a LAMP stack. I have decided to go with Centos 6.2 as a KVM host ...
1
vote
0answers
355 views

Can I run Zend Server along with already-installed LAMP Stack?

I already have Apache2+MySQL+PHP installed and am using it on Ubuntu Linux. I would like to test out the Zend Framework installation bundled with Zend Server, since the server is supposed to be ...
1
vote
2answers
419 views

Increasing the concurrent user performance in LAMP application

We have a LAMP application where we have started to feel the performance pinch due to large number of concurrent users connecting to the application. I have looked at the individual parameters of ...
1
vote
1answer
197 views

mysql always using maximum connection

I have LAMP server having 4 core CPU and 32 GB RAM.We are running a large website on it. I have following issues now in my server. When I use Mysqlreport tool to monitor the mysql server i am always ...
-1
votes
2answers
140 views

What configurations need to be set for a LAMP server for heavy traffic? [closed]

I was contracted to make a groupon-clone website for my client. It was done in PHP with MYSQL and I plan to host it on an Amazon EC2 server. My client warned me that he will be email blasting to about ...
2
votes
4answers
447 views

Server not coping, cpu load averages spike to 33.0

Basically I have a server failing under load. Its a editorial news site that see irregular traffic spikes. I'm tearing my hair out trying to stabilise the LAMP configuration. Current Time: Wednesday, ...
3
votes
3answers
804 views

Copy MySQL to RAM as a poor man's memcached replacement?

What about this idea: I've got a 4GB MySQL database, with few UPDATEs. On system startup I copy it to RAM and run it from there. Every couple of hours or even on UPDATES, I dump it to disk. ...as ...
-3
votes
2answers
102 views

Is it enough just to install LAMP? [closed]

I use yum to install LAMP on Centos, like this: yum install httpd mysql mysql-server php php-mysql chkconfig --levels 235 httpd on chkconfig --levels 235 mysqld on service httpd start service ...
2
votes
1answer
159 views

Scaling advice LAMP + Load balancers

My current setup: 1 Http Load Balancer 3 Apache Frontend Server 1 Mysql Load Balancer (Balancing reads across all three, writes go to master only) 3 Mysql Database Server (1 master, 2 slave) All ...
0
votes
2answers
146 views

Running 2 LAMP stacks on one instance

I have a working installation of apache and mysql using standard ports, and my host file points domains to 127.0.0.1. I'm in the process of switching my LAMP stack to Zend Server but want my old set ...
0
votes
1answer
273 views

Installed LAMP server and php myadmin, no .my.cnf file

I just installed apache LAMP server along with phpmyadmin to make database editing easier. Now that I've installed everything, I can't find the .my.cnf file that should have been generated. I thought ...
4
votes
2answers
5k views

phpmyadmin connecting to a remote server

I have two servers (ubuntu 10.04 amd 64). one i plan on the webserver, the other i plan on being the database server. The webserver is the only server with access to the outside world. I installed a ...
2
votes
5answers
606 views

Track resource usage on Ubuntu server while I'm sleeping?

I've got a pretty typical LAMP server running a web site but sometimes, during the night, resource usage skyrockets and the site becomes unresponsive. There are a lot of logged errors about being ...
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
2answers
291 views

Accessing databases from different domains on same server

I have a LAMP server - on there I have multiple domains. Each domain has its own user, db's, public_htmls/, etc. I need to access Domain A's database from a web app on Domain B in php. Currently I ...
0
votes
1answer
222 views

cron to merge xml into sqlite every two hours - lamp

I'm looking to auto pull an xml file from an offsite url and merge it into a sqlite db every two hours. The server is lamp. (If it is too difficult to do for sqlite, then merging the xml into a mysql ...
0
votes
3answers
135 views

MySQL on Linux (Redhat) freezing with queries on large tables

We have a server running LAMP which contains a number of zencart sites. We noticed a problem when trying to view orders in one of the sites and it timed-out. Now when I do: "select * from orders" ...
0
votes
1answer
182 views

PHP/MySQL hostserver crashing/freezing

I am not sure if I have totally missed something here so I am asking, to hopefully become a better person. So I already now, ask for forgiveness for my stupidity, if any. I have a client that is ...
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
2answers
288 views

LAMP vs Windows Server 2008 scenario

I see there is a lot of things online about this, but wanted an answer specific to this scenario. I can think of a few issues with this, but wanted to ask everyone to get the whole picture. Can ...