I need to stop Mysql server in MAMP PRO and keep Apache running. How can I do that ?
There is a stop button available but it stops all services.
I installed monit on my centos 6/64bit and somethings wrong. Look at the shell :
[root@ND-1003 monit.d]# service monit start
Starting monit: monit: generated unique Monit id f8f62f27db2323649f105342f2fbf04d and stored to '/var/monit/id'
[ OK ]
[root@ND-1003 monit.d]# service monit status
monit dead but subsys locked
[root@ND-1003 monit.d]# service monit stop
Stopping monit: [FAILED]
As you can see there is a message: monit dead but subsys locked
Anybody know how to correct this ?
I tried to run tuningprimer.sh to tweak my mysql settings. I already increased mysql query cache few times to current 2GB but it's still not enough according to test results:
> QUERY CACHE Query cache is enabled Current query_cache_size = 2.00 G
> Current query_cache_used = 1.72 G Current query_cache_limit = 8 M
> Current Query cache Memory fill ratio = 86.22 % Current
> query_cache_min_res_unit = 4 K However, 3906616 queries have been
> removed from the query cache due to lack of memory Perhaps you should
> raise query_cache_size MySQL won't cache query results that are larger
> than query_cache_limit in size
As you can see 3.9 mil queries were removed from cache because its size. I'm afraid about indexing such a big cache. I mean that maybe search in such a big cache file can take more time and resources than execute the query itself.
What do you think ? Should I still increase mysql cache ?
BTW: server runs Litespeed + mysql + php 5.3 and has 24GB of RAM, current memory usage is 12GB
Possible Duplicate:
Connect through SSH and type in password automatically, without using a public key
I have a bash script that makes dump of DB then copies file from one server to another but it always asks for password before connection.
scp file.tar.gz [email protected]:/backup
Is there a way to pass password directly into script ?
I have 2 servers and want to be able to connect via SSH from server A to B and vice versa. What Iptables rules should I set on both machines to make this possible ? SSH is runnning on default port 22
From time to time load on my server (centos 4)jumps to 15 or more. I need to discover what process causes this high load on server. It there any script which can handle this for me ? I think its caused by mysql so even to discover the sql query would be great help.
Is it ok to install zimbra on LAMP dedicated server which is running only our websites (no client sites) and also mails are only ours ?
Do you see any disadvantage to install it on the same box where PHP/Apache/Mysql is running ?
I just installed and configured Postfix/Dovecont + Mysql + PostfixAdmin. When I try to send email from e.g. gmail.com it's delivered but I cannot see it in mail folder. Seems to be deleted. Here is my maillog. Can anybody help why ?
Sep 27 17:12:53 ND-12053 postfix/smtpd[29098]: connect from mail-yw0-f44.google.com[209.85.213.44]
Sep 27 17:12:53 ND-12053 postfix/trivial-rewrite[29101]: warning: do not list domain mydomain.com in BOTH mydestination and virtual_mailbox_domains
Sep 27 17:12:53 ND-12053 postfix/smtpd[29098]: 9A8B69E0F9D: client=mail-yw0-f44.google.com[209.85.213.44]
Sep 27 17:12:53 ND-12053 postfix/cleanup[29102]: 9A8B69E0F9D: message-id=<CAOgJ1rEcfNDy2yr7mmj9zTi=0UYOS-DdZYSohR9Bv987MiFVPQ@mail.gmail.com>
Sep 27 17:12:53 ND-12053 postfix/qmgr[27094]: 9A8B69E0F9D: from=<[email protected]>, size=1482, nrcpt=1 (queue active)
Sep 27 17:12:53 ND-12053 postfix/trivial-rewrite[29101]: warning: do not list domain mydomain.com in BOTH mydestination and virtual_mailbox_domains
Sep 27 17:12:53 ND-12053 postfix/trivial-rewrite[29101]: warning: do not list domain mydomain.com in BOTH mydestination and virtual_mailbox_domains
Sep 27 17:12:53 ND-12053 postfix/trivial-rewrite[29101]: warning: do not list domain mydomain.com in BOTH mydestination and virtual_mailbox_domains
Sep 27 17:12:53 ND-12053 postfix/local[29103]: 9A8B69E0F9D: to=<[email protected]>, orig_to=<[email protected]>, relay=local, delay=0.04, delays=0.02/0.01/0/0.01, dsn=2.0.0, status=sent (delivered to maildir)
Sep 27 17:12:53 ND-12053 postfix/qmgr[27094]: 9A8B69E0F9D: removed
Email folder list:
drwx------ 2 postfix postfix 4096 sep 27 16:43 cur
-rw------- 1 postfix postfix 248 sep 27 16:43 dovecot.index.log
-rw------- 1 postfix postfix 48 sep 27 16:47 dovecot.mailbox.log
-rw------- 1 postfix postfix 51 sep 27 16:43 dovecot-uidlist
-rw------- 1 postfix postfix 8 sep 27 16:47 dovecot-uidvalidity
-r--r--r-- 1 postfix postfix 0 sep 27 16:43 dovecot-uidvalidity.4e82357b
drwx------ 2 postfix postfix 4096 sep 27 16:43 new
-rw------- 1 postfix postfix 21 sep 27 16:47 subscriptions
drwx------ 2 postfix postfix 4096 sep 27 16:43 tmp
ifconfig -a
eth0 Link encap:Ethernet HWaddr 00:25:90:60:1B:FC
inet addr:10.0.47.42 Bcast:10.255.255.255 Mask:255.255.255.248
inet6 addr: fe80::225:90ff:fe60:1bfc/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:4300 errors:0 dropped:0 overruns:0 frame:0
TX packets:12 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:416886 (407.1 KiB) TX bytes:812 (812.0 b)
Memory:fbce0000-fbd00000
eth1 Link encap:Ethernet HWaddr 00:25:90:60:1B:FD
inet addr:72.9.239.194 Bcast:72.255.255.255 Mask:255.255.255.248
inet6 addr: fe80::225:90ff:fe60:1bfd/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:82334 errors:0 dropped:0 overruns:0 frame:0
TX packets:53868 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:85116034 (81.1 MiB) TX bytes:22357038 (21.3 MiB)
Memory:fbde0000-fbe00000
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:5356 errors:0 dropped:0 overruns:0 frame:0
TX packets:5356 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:674981 (659.1 KiB) TX bytes:674981 (659.1 KiB)
Adresses assigned to server should be 5 usable:
72.9.239.194
72.9.239.195
72.9.239.196
72.9.239.197
72.9.239.198
Unfortunately when I do ping server answers only on: 72.9.239.194
OS=centOS 6/64bit
What could be wrong ?