Server :: Slow Database Server On Processing / Make It Up?
Apr 15, 2010
I'm having trouble with my database server run with PHP & MYSQL; i just installed this system on a SUSE Linux Enterprise Sever; the Server its self is an HP Proliant ML370G with 4GB RAM
The system was fine for like 3 weeks until recently when it started slowing down. Apparently, eveything is normal when you are accessing the server, for example when you are browsing on the database web interface; but problem is when you start working in the database, when you try submitting into the database, its really slow on processing, i have to first restart the mysql;
Could it be RAM? or the SQL itself?
View 3 Replies
ADVERTISEMENT
Apr 13, 2010
When I'm trying to login to the ftp server with appropriate username and password its taking almost 10-15 seconds to authenticate making the login process slow, even when I'm uploading files its again hanging for 10-15 seconds before completing the job successfully.
Its not like its happening every time, but 7 times out of 10.
Any idea how can make the authentication fast?
View 5 Replies
View Related
Nov 9, 2010
I am using Redhat linux 9.0 and using squid proxy server.My problem is tht i my squid server is responsing very slowing. whenevr i try to open sites the site starts to open after 3 or 4 seconds and often squid does not open the complete site. its stop the site in middle. My squid Configurtion is below. Is there any need to tune the system parameters Like from 'SYSCTL.conf' for better diskd performence or another problem. at this time i am using default system parameters. Please help me in detail what is the reason of squid slow performence if there ia a need of any system tuning please tell me in detail. I am very thankfull to you.I am really worried about slow performence of the squid. I also try to offline_mode on but the same problem. code...
View 3 Replies
View Related
Dec 3, 2010
I have an Ubuntu Server 10.10 install on a VIA C7 chip. It seems to pause for about 5 min on a USB component.
It is a fresh install, here is a snip from my messages log code...
My KB is USB, so I would rather not disable it if at all possible. The next time I can take it down, I will test disabling it though...
View 4 Replies
View Related
Nov 16, 2010
I have CentOS 5.5 x86_64 with Apache, php and mysql.
I have just installed OTRS (helpdesk - trouble ticket system) on that server and no users.
This system works with perl, apache and mysql.
I notice that is slow to respond and at times unresponsive the apache welcome page. code...
View 5 Replies
View Related
Apr 21, 2011
I'm running a linux cloud server with the following config
1.2ghz Processor allocation
752MB Ram
The site loads slow and clicking a link almost freezes the page for a second. Also, the page loads could be much faster. We've been running mysqltuner and have pretty much optimized all slow queries. Is there anything we can do to fine tune the server for faster and more responsive?
Httpd.conf
Timeout 20
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
code....
View 2 Replies
View Related
Dec 27, 2010
I am running the Linux server ( debian etch ) on a virtual machine since more than a year. About a week ago the mail server ( exim4 ) stopped working. I've started aptitude and made something i cannot remember exactly ( said o.k. to an action aptitude proposed me solving some inconsistencies, but aptitude itself crashed several time with "cannot fork" and "SIGSEGV" ) - since then apache2 does not handle the PHP pages, delivers the php source to the browser.
I've tried reinstalling PHP5, but no success so far
- php5 is installed, also the libapache2-mod-php5
- The php5 module is activeted ( the symbolic links stay in mods-enabled. If i remove / rename the /usr/lib/apache2/modules/libphp5.so file, i get an error message when i restart apache2 - it seems me, the PHP5 module is loaded into apache2.
The apache2 configuration file 000-default contains my virtual hosts, among them for example:
<VirtualHost *:80>
ServerName bahnschranke.pxtr.de
DocumentRoot /home/laffin/index_bahnschranke
[code]....
When i try to load a page from this virtual host into my browser, i get the php source code (opened by a texteditor), and no log line is written, neither into error.log, nor into access.log As i said, the system worked correctly for monthes, it is not a new installation, but something went wrong in the last days.
View 1 Replies
View Related
Sep 9, 2010
A while back I was asking the forum for FTP server reco's, said what I needed and the response from all was only proftpd has post processing functionality.Basically we will have numerous users uploading data at a constant rate and after each successful upload, I would like to fire a script to do some work. The script is nearly done, so I am now looking to see how to do this.Not sure if it matters, but the server is running / allowing via MySQL not the local user's.
View 1 Replies
View Related
Nov 3, 2010
I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.
View 6 Replies
View Related
Mar 18, 2010
I'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.
Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.
View 1 Replies
View Related
Apr 11, 2010
Mails are not going out of the queue. Removed all frozen mails and tried to flush queue using exim -qf command. Also checked queue after restarting exim. Still messages are not going out of the queue.
View 1 Replies
View Related
Mar 19, 2011
I am currently deploying Nagios as my NMS on CentOS 5 and using pn4nagios to create graphs.I have successfully configured Nagios-3.3.3 along with nagios-plugins-1.4.15. its working fine and showing my windows machine and linux machine.But here is the problem, when I try to configure pnp4nagios-0.6.11 I am unable to restart nagios service as it gives me error in commands.cfgfile on line number 240.can sum1 tell me how to get rid of this error. i had encountered similar problem while using nagiosgrapher. kindly note that i have allowed perdata to be processed by setting its value to 1.
View 4 Replies
View Related
Dec 5, 2008
I want to use TightVNC on Linux to display a KDE desktop to VNC clients, do I have to have a super duper graphics card in my server, or is it down to the VNC client to process the graphics?
View 1 Replies
View Related
Mar 14, 2011
I would like to ask whether there is a way to postpone or delay message processing on postfix mail server. E.g. to postpone message transfer/relay for 5 minutes to be able to dequeue mis-targeted emails.I couldn't find anything because these keywords mislead to performance problems.
View 2 Replies
View Related
Jul 8, 2011
I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
View 2 Replies
View Related
May 16, 2009
I have a wordpress blogging server up and running and i've also got nagios monitoring the speed of webpage download etc.The thing is a couple of weeks ago nagios alerted me that the blog was returning pages really slow loading, when i went to the blog homepage for me also it was very slow. After about 30mins of http connections some finally loading and some not nagios stopped reporting issues, but thats not the end of the story, the graphing of speed i've got set-up on nagios shows quite clearly that ever since that big slow down the pages take avg of extra 2-3 seconds to load. However nothing drastic has changed and the datasize of the page hasn't really changed at all (also monitored).
During that weird period I carried out checks on the server itself like top, free -m, netstat (looking for maybe DOS attack number of connections), looked at mysql see if that was running slow and what processes it was running, checked on number of http processes see if they had ramped up, checked on php and web server errors see if they had increased some what as well. None of these things turned up anything noticeable to be causing such slow blog response.Now its still that average amount high and i'm lost at why this could be? Its niggling at me that something may have got in but i've taken several security steps to try and lock down the wordpress install etc.
View 5 Replies
View Related
Jan 12, 2010
I have changed my home network a bit, and everything works extremely fast, except for my apache server, which seems to serve webpages so slowly, it is abnormal. Even simple directroy pages are served in around 5 sec, and this is not a joke! It used to work pretty fast. What I have changed is that i replaced a hub with a switch, and that I linked my personal PC with my server together through a hub. I also installed Gnome desktop on the webserver machine. My network now looks like follows:
Internet
/
||
[code]....
View 5 Replies
View Related
Oct 25, 2010
there is any other way to make oracledb on CentOS 5.4 and HP Proliant DL360 G5 Server fast access from a vb application. modified, reconfigured all to make faster but no use
View 2 Replies
View Related
Apr 1, 2010
we have qmail server installed on rhl 9. it was working perfectly fine for last 1 year. suddenly it stopped accepting emails from internet. when i telnet on port 25 it takes about 90 secs to show the SMTP ready state.I have tried many things
1. stopped Reverse DNS Lookup by adding -H to qmail-smtpd/run file
2. stopped spamassing and AV
3. reverified DNS server settings in resolv.conf
4. dig is resolving dns query properly.
i also observed that when i do telnet to
telnet localhost 25 response is very quick
but when i do
telnet local_server_IP_address 25
it takes aprx 90 secs to show me SMTP ready messege.
can someone shed some light on this as what should i do next to rectify this problem..
View 1 Replies
View Related
Oct 25, 2010
We recently shifted our applcation and database to LINUX from UNIX.so now application server(weblogic 8.1) is on linux and oracle database 9i is on linux.previously there is a process in application server(which access the Database dor the data) which took only 1 hour to run on UNIX after shifting to LINUX the same process is taking 4 to 5 hours to run.
but when individually ran the queries on the database it is quck than UNIX.our ADMIN tried changing the kernel parameters for the database server, but it is still the same.
View 10 Replies
View Related
Jun 13, 2010
Running RHEL 5.5 x64 with the latest updates. Running Oracle 11gR2. Server has 8gb ram 2xcpu 2.4 xeon.Only running one fresh instance of Oracle, no applications are even pointed at the DB.Two Issues...
1. Logins via SSH to server are extremely slow, about 30 seconds after typing password
2. Once I am logged in, launching sqlplus is very slow. After typing password, sqlplus hangs for 15 or so seconds.
Even when I am actually at the console, login of course is instantaneous.. but sqlplus still has the same issue. CPU is at 0% no swap is being used. Shouldn't be a network issue, on the same network.
View 2 Replies
View Related
May 30, 2010
My sites on the server are loading very slow, though my server load is under 1.00.What can be the problem, when ever i restart httpd the sites starts to load instantly.
View 14 Replies
View Related
Jan 15, 2011
I have 2 servers each one with a RAID and I want them mirror they data so if one of them goes down the other one take the job with out disruption. I've heard of multipath by I want to know it in detail or learn of more options.
View 2 Replies
View Related
Mar 16, 2011
I am trying to make an application server that would contain simple ones like edit, openoffice, gimp, so on and so forth. I know how to access these using ssh but what I want is that the application runs on that server as it already does, but to open local files and save them locally.
View 7 Replies
View Related
Dec 22, 2010
I want to make a transparent squid proxy server in centos. The squid proxy version is 2.6 stable. I made a normal squid server but want to make it transparent so that users do not need to enter the proxy settings in web browser. Even i searched about this on google but not getting it properly.I have two lan cards on centos system. ETH1 used for LAN and ETH2 used for WAN. And in this squid.conf i written "http_port 172.16.31.1:3128 transparent" and i also added a rule in iptables which is "iptables -t nat -A PREROUTING -i eth1 -p tcp --dport 80 -j REDIRECT --to-port 3128" but still i have to enter proxy settings at client's web browser to use internet
View 4 Replies
View Related
Jul 6, 2010
i just one to emulate the windows 2003 - windows XP easy VPN deployment, with my ubuntu server.I got my server side (ubuntu) and client side ( openVPN gui) and everything looks okbut now, i cant make a //server/SHARED and get from my house to the office's docs, despite the conection its ok... whats wrong?
View 14 Replies
View Related
Mar 27, 2010
I wanted to know how can I cross compile SMS SERVER TOOL for an embedded computer and make just one binary file for it or how can I change all of its default files places like its demon and object file and gather all of them to one directory to execute and use and run.let me explain it better for you : I have an embedded computer with Linux OS that its file system is read only and I can not add any file to /usr /lib and ..... and I can just mount a SD memory card to it and copy all of my programs to it and run them from there as you understand I have two choices to choose, first make one big binary file for each program that I am doing it now and it is not a suitable solution and the second is finding the way to change default place of shared object file of my program.now you tell me what can I do to solving this problem.
View 1 Replies
View Related
Apr 19, 2011
I've installed PostgreSQL on Arch Linux & also self generated self signed certificates in /etc/ssl/ directory. My PostgreSQL 'data' directory is /var/lib/postgres/data & I've edited my postgresql.conf file to use SSL however I'm having permission / access problems starting my database using SSL. It can't access the certificates and errors out when I try and start the database engine:
Code:
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
FATAL: could not load server certificate file "server.crt": No such file or directory
code....
I don't know what I need to chown or chmod in order to get PostgreSQL to access my self signed certificates.
View 3 Replies
View Related
Nov 4, 2010
I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?
View 2 Replies
View Related
Nov 8, 2010
I have got 2 postgresql databases on separate servers. i want to sync one database to the other. how it can be done ?
View 1 Replies
View Related
