I have a VPS.
I have installed "Lighttpd, php5cgi, mysql-server, mysql-client,
libmysqlclient15-dev"
I have optimized the MySQL Server (/etc/mysql/my.cnf).
All these together just take 30 mb Memory.
Lighttpd use just 12mb memory And everything is very good.
But,
When I install php5 mod MySQL:
apt-get install php5-mysql
Then the Lighttpd memory increases to 90mb!
I am using updated Debian Lenny, MySQL5, php5.
I recently installed ubuntu 7.10, and apache2. Both installed with no problems. In my browser i am able to type localhost, and i recieve the "It works" page. I can also start,stop and restart with no problems. However, I cannot install php5. I use synaptic package manager to install, and i added the appropriate lines to the httpd.conf file but i still cannot view .php files. I try to run a simple php page and a dialog box pops up prompting me to open or save the file. If i choose either, the box just pops up again.
View 15 Replies View RelatedI keep seeing instructions on installing using apt-get install php5-gd to install it, but when I do that my server says unknown command....
View 4 Replies View RelatedAfter install MySQL and Apache, everything went well, I tested web server and it was OK. but after I installing PHP, httpd just simply don't run.
When I tried to run httpd, nothing was happened as showing below
[root@localhost ~]# /usr/local/apache/bin/apachectl start
[root@localhost ~]# ps aux |grep httpd
root 2809 0.0 0.2 4988 672 pts/0 S+ 06:52 0:00 grep httpd
[root@localhost ~]#
-----------------------------------------
CentOS 5
MySQL: 5.0.41
httpd-2.2.4
PHP-5.2.3
------------------------------------------
Installation Details
groupadd -g 103 mysql
useradd -u 103 -g mysql mysql
groupadd -g 104 web
useradd -u 104 -g web web
MySQL
./configure --prefix=/usr/local/mysql
--with-extra-charsets=all
--enable-thread-safe-client
httpd
./configure --prefix=/usr/local/apache
--disable-status
--disable-asis
--disable-cgid
--disable-userdir
--disable-cgi
--with-mpm=worker
--enable-so
--enable-deflate
--enable-rewrite
PHP
./configure --disable-all
--with-apxs2=/usr/local/apache/bin/apxs
--with-pcre-regex
--with-zlib-dir
--with-dom-xslt
--with-dom-exslt
--with-gd
--with-jpeg-dir
--with-png-dir
--with-ttf
--with-freetype-dir
--enable-gd-native-ttf
--enable-gd-jis-conv
--with-iconv
--enable-mbstring
--with-mysql=/usr/local/mysql
--with-mysqli=/usr/local/mysql/bin/mysql_config
--with-pdo-mysql=/usr/local/mysql
--enable-pdo
--enable-sockets
--with-dom
--with-xmlrpc
--with-xslt-sablot
--enable-xslt
--enable-soap
--enable-zip
--enable-libxml
--enable-simplexml
--enable-exif
--with-pear
--enable-xml
httpd.conf
User web
Group web
------------------------------------------------------------
I have installed PHP5 in my windows server (IIS6).But when I check with phpinfo() its not showing mysql extension or any details.
I have enabled the mysql extension in php.ini
Is this possible? It seems that yum wants to also upgrade to mysql 5 if I want to upgrade php to 5. I'm having a hard time finding any info about it online.
View 4 Replies View RelatedWhile trying to compile PHP 5 with mysql and mysqli , I was facing some issues.
Actually, the configure command generates a bad Makefile.
Open the Makefile and look for a line staring with EXTRA_LIBS
You will see that the option “-lmysqlclient” is repeated twice. Delete one of them and save the Makefile.
Now, you should be able to run the Make command and compile PHP without any issues.
any hosts that can provide the following:
PHP5.3 +
MySQL
CRON (to run daily/weekly scripts at a certain time)
Mass Email. The scripts will send emails to a number of users(between 10-100 at first, but may grow) and this will be done daily and weekly.
In the past, I've tended to go with SupaNames or FastHosts but looking at their solutions for this, it's not quite right for my requirements.
I am currently using CentOS 5. I installed php-mysql, mysql-server, mysql and mysql-devl through yum install.
WhenI try to start mysqld I get this error
Code:
090722 20:17:32 mysqld started
090722 20:17:32 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090722 20:17:32 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
090722 20:17:32 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Error: pthread_create returned 12
090722 20:17:33 mysqld ended
I obviously havn't done something correctly.
im trying to install mysql, apache and php on my new server and everytime i use the command - make install or make all it says is -bash: make: command not found.
View 2 Replies View RelatedI want install PHP near IIS and security is important for me.
I chose ISAPI is it good?
It works but I have problem in using MySQL I did not use PHP.ini for php5+ISAPI and it works how add mysql?
to make it useful with MySQL and make secure,
I tried installing MySQL on a Windows 2000 Server. I went through all the wizards and I got an error because I needed to open a port. I am not really a server/network guy, its just a dev server for my programming. How do I go about opening the port for MySQL. And then how would I test the installation to know its all good?
View 3 Replies View RelatedI am trying to install MySQL from its RPM. I keep getting the following dependency issues and I have never seen these before. libc.so.6 is installed via glibc. I have all of the different glibc packages installed and I am lost. libc.so.6 is located in /lib/lib.so.6.
# rpm -i MySQL-server-community-5.1.34-0.rhel5.x86_64.rpm
error: Failed dependencies:
libc.so.6()(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libc.so.6(GLIBC_2.2.5)(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libc.so.6(GLIBC_2.3)(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libc.so.6(GLIBC_2.3.4)(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libc.so.6(GLIBC_2.4)(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libcrypt.so.1()(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libcrypt.so.1(GLIBC_2.2.5)(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libdl.so.2()(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libdl.so.2(GLIBC_2.2.5)(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libm.so.6()(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libm.so.6(GLIBC_2.2.5)(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libnsl.so.1()(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libpthread.so.0()(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libpthread.so.0(GLIBC_2.2.5)(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libpthread.so.0(GLIBC_2.3.2)(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
libpthread.so.0(GLIBC_2.3.4)(64bit) is needed by MySQL-server-community-5.1.34-0.rhel5.x86_64
Here is where I stand..
OS: FRESH install of Unix Fedora Core 6
Kernel Version: Kernel 2.6.18-1/2798.fc6 on an i686
Hardware Information: Brand new Dell SC1435 Server
Software Version: MySQl 5
Control Panel: cPanel
A few things I did already..
#yum install mysql-server && service mysqld start
Nothing to do
mysqld: unrecognized service
#rpm -qa | grep mysql
libdbi-dbd-mysql-0.8.1a-1.2.2
mysql-connector-odbc-3.51.12-2.2
#ps -ef | grep -i mysql
root 15299 15114 0 16:55 pts/0 00:00:00 grep -i mysql
I don't see the mysql.sock file. What I can do to further troubleshoot this issue?
I've installed lighttpd and it works perfectly. However, when I browsed my blog I got the msg:
"Your PHP installation appears to be missing the MySQL which is required for WordPress."
Was there anything I missed? Should I install PHP again?
I have two servers, one is web server, the other one is mysql server.
I am installing php on web server that does not have mysql installed.
when I do the follows:
./configure --prefix=/usr/local/webserver/php --with-config-file-path=/usr/local/webserver/php/etc --with-mysql=/usr/local/webserver/mysql --with-mysqli=/usr/local/webserver/mysql/bin/mysql_config --with-iconv-dir=/usr/local --with-freetype-dir --with-jpeg-dir --with-png-dir --with-zlib --with-libxml-dir=/usr --enable-xml --disable-debug --disable-rpath --enable-discard-path --enable-safe-mode --enable-bcmath --enable-shmop --enable-sysvsem --enable-inline-optimization --with-curl --with-curlwrappers --enable-mbregex --enable-fastcgi --enable-fpm --enable-force-cgi-redirect --enable-mbstring --with-mcrypt --with-gd --enable-gd-native-ttf --with-openssl --with-sendmail=/usr/sbin/sendmail
the script tells me error:
configure: error: Cannot find MySQL header files under /usr/local/webserver/mysql.
Note that the MySQL client library is not bundled anymore!
Because mysql installed on another physical server. so how may I fix the problem? can I configure php without "---with-mysql" and "--with-mysqli" parameters? I need my php could access remote mysql server.
We have recently recompiled Apache and now we are receiving MySQL errors on some of our sites. The errors are only displayed sometimes (not on every single load of the page).
We have been advised that the problem may be due to MySQL running out of memory - is this correct?
I have tried changing the 'memory_limit' in php.ini to 100MB but still this does not change anything. Here is the error we are receiving:
Code:
Warning: mysql_list_tables() [function.mysql-list-tables]: Unable to save MySQL query result in /home/username/public_html/includes/tables.php on line 16
Does anyone know if MySQL 5.1 or 5.0 uses less memory than 4.1 does?
View 3 Replies View RelatedI have a vps with 1GB of ram and mysql consume lots of memory I googled about this subject but everywhere mysql performance tuning is described
mysql has 10 threads like below
7338 mysql 0 0.0 4.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
7339 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
7378 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
2507 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
2517 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
2518 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
2519 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
2520 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
7399 mysql 0 0.14.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
5162 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
my.cnf properties are
set-variable = max_connections=90
set-variable = wait_timeout=10
set-variable = connect_timeout=10
set-variable = long_query_time=4
skip-locking
key_buffer = 2M
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
table_cache = 1M
query_cache_size = 1M
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
Since upgrading to Apache 2 I am no longer able to tell which domains are the busiest using CPU/Memory/MySQL Usage. Now Apache processes are all lumped together and individual domains only show cron, mail and FTP usage. I opened a ticket with cPanel and they know of the problem but there is still no solution. Is there another way I can tell which of my sites is using the most resources until this bug is fixed?
View 2 Replies View RelatedMySQL Error : Out of memory
I'm getting this very frequently today
MySQL Error : Out of memory (Needed 76760 bytes)
Error Number : 5
Request Date : Friday, November 7th 2008 @ 01:52:17 PM
Error Date : Friday, November 7th 2008 @ 01:52:18 PM
Script : [url]
Referrer : [url]
IP Address :
Username :
Classname : vB_Database
MySQL Version :
I have Mysql 5 installed, on a Centos/Cpanel box. Server has 4GB memory, server load is green/normal.
I already ran optimization on the database too.
It started happening yesterday, pretty much after I installed this hack:[url]
Quote:
[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-networking
safe-show-database
query_cache_limit=2M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=500
max_connections=500
interactive_timeout=10
wait_timeout=28800
connect_timeout=20
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=8M
max_connect_errors=20
max_allowed_packet=32M
table_cache=1024
record_buffer=8M
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_swedish_ci
[mysql.server]
user=mysql
old-passwords = 1
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=24M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Warning: mysql_connect() [function.mysql-connect]: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /home/user/public_html/includes/functions.php on line 423
Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
My mysql is using alot of memory although there is not much data into the mysql tables.
I tried to control mysql usage by editing my.cnf file but that didnt help.
Which variables should I edit in my.cnf to keep mysql using low memory?
I edited sort_buffer_size, key_buffer_size but that didnt help much. It uses alot of per-thread memory as well.
I'm always having MySQL consuming quite a bit of cpu & ram.
what's happening here?
PHP Code:
mysql 27519 7.2 12.8 158736 132496 ? Sl Mar08 180:57 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server.hostname.pid --skip-external
I have replaced my server's real hostname to server.hostname
I am very low of system resources but wish to use MYSQL as my database backend so I have installed MYSQL 4.0 on my Debian Sarge 3.1 VPS with linuxthreads and configured it to use least possible resources as my VPS only offers 32MB main memory. Generally I use the PS command to get the memory usage of running processes. But MYSQL being threaded confuses me. My system uses linuxthreads so all the threads get listed as seperate processes but show same stats in PS command output. On initialization, MYSQL starts 3 threads which according to documentation, are necessary for its functioning. This is what I see:
root 139 0.0 0.0 2436 4 ? S Feb07 mysqld_safe
mysql 163 0.0 4.5 5480 1264 ? S Feb07 0:02 mysqld
mysql 164 0.0 4.5 5480 1264 ? S Feb07 0:00 mysqld
mysql 165 0.0 4.5 5480 1264 ? S Feb07 0:00 mysqld
Is that means MYSQL is using only 1264 Kb of real memory? If that is the case, I am really happy about my tweaking skills. After doing a query through PHP, the output becomes:
root 139 0.0 0.0 2436 4 ? S Feb07 mysqld_safe
mysql 163 0.0 4.5 5510 1278 ? S Feb07 0:02 mysqld
mysql 164 0.0 4.5 5510 1278 ? S Feb07 0:00 mysqld
mysql 165 0.0 4.5 5510 1278 ? S Feb07 0:00 mysqld
Thats just very nominal resource usage. I am assuming that what PS is showing are just duplicate entries for a single MYSQLD process and 1278 Kb can be safely taken as its RAM usage. I hope it is not (1278 X No. of mysqld threads).
My mysql server keeps on crashing. I wonder if it is because of out of memory. Last week, I upgraded my memory from 2GB to 6GB and I executed the command "free" to check memory usage. It uses 5GB in memory usage and leave under 10,000k unuse. Do you think this might be the cause of weekly mysql crashes?
I only use the server for mysql, so it is a dedicated mysql server.
I had a 280 MB MySQL db on a 384 MB Linux Dual Xeon 3.2 GHz VPS (no CP, no additional software) and it was no where near enough. Even if I upgraded the VPS to say 1 GB of Memory, it would take no time at all to over load it at this rate. There must be something wrong with the setup, I can't see MySQL being so resource heavy... or is it?
View 7 Replies View RelatedI'm checking my CPU/Memory/MySQL Usage and I'm seeing that something called Munin is running at 54%. That is apparently the average for today. Can anyone give me any insight as to what this is?
Wikipedia classifies Munin as a network monitoring application. I don't think it should be using this much processing.
It appears that I may have enabled this plugin when I rebuilt my apache using EasyApache. Are there any big benefits to this? Looking at the graphics at first glance it doesn't look like there is. but then again, I'm not that knowledgable about this stuff.
I have migrate any sites to new server, where there is mysql 5
Centos 5
WHM/Cpanel
When I try to open phpmyadmin I see this:/
query SQL:
SHOW CHARACTER SET;
Messaggio di MySQL:
#5 - Out of memory (Needed 1677360 bytes)
--
What is the average memory/cput usage for httpd connections.?One of the site is using 2.8% memory. Is it acceptable for 1 GB RAM servers?
View 6 Replies View RelatedNot displaying CPU/Memory/MySQL Usage stats.Can u tell me how can i do it.
View 2 Replies View Related