Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )



Advanced DNS Management
New ZoneEdit. New Managment.

FREE DNS Is Back

Sign Up Now
 
Reply to this topicStart new topic
> Slow MySql after fedora core 5 install, Slow MySql after fedora core 5 install
andy1974
post Apr 6 2006, 03:24 PM
Post #1


./configure
***

Group: Members
Posts: 133
Joined: 24-February 04
Member No.: 2,454



Hello All

long time since my last post

I just upgraded my fedora core 3 to core 5 yesterday and everything went great. but after the reboot of the server i noticed that my forums on my web site is retriveing the data very slowly page wont pop up till like 30 sec of thinking. Any ideas.....i run the latest mysql server and apache and php for the forums
Go to the top of the page
 
+Quote Post
Termina
post Apr 6 2006, 09:15 PM
Post #2


RMS is my Hero
******

Group: Support Specialist
Posts: 862
Joined: 18-February 04
From: Wisconsin
Member No.: 2,404



While loading some pages, check 'uptime'. What kind of load do you see?

Also keep an eye on the 'top' command; what exactly is eating up alot of CPU?

You are aware that Fedora isn't meant to be used for a server, right? smile.gif


--------------------
*Points finger at the author above him* They're a witch! Burn them!
---
Vist my website!
Join me in IRC! Server: st0rage.org Channel: #UnhandledExceptions
Go to the top of the page
 
+Quote Post
andy1974
post Apr 6 2006, 10:52 PM
Post #3


./configure
***

Group: Members
Posts: 133
Joined: 24-February 04
Member No.: 2,454



Not supposed to be a server??
when installing it, it asks if you want to install as a server....
i have been running it fine as a sever for over a year now.....but just wanted to upgrade from core 3 to core 5.....
Go to the top of the page
 
+Quote Post
Hemant
post Apr 7 2006, 03:28 AM
Post #4


RMS is my Hero
******

Group: Support Specialist
Posts: 782
Joined: 6-October 02
From: Trichy,INDIA
Member No.: 29



I agree with Termina on this...you should not use Fedora as a production server.....If you are using it as a development platform...then its fine.

But...have you checked..which version of MySql is shipped with FC5... is it, 5? If yes..you have to tune few things...but still. first ...i would go with termina's suggestion...and then try to tune SQL things.

On a sidenote, i would love to have MySQL5 running...my webapp.... they have really nice things like stored procedures.. so you can put your business logic in the database.


--------------------
Hemant Kumar
user posted image
hemant@linuxhelp.net
Go to the top of the page
 
+Quote Post
DS2K3
post Apr 8 2006, 07:04 PM
Post #5


Its GNU/Linuxhelp.net
*******

Group: Support Specialist
Posts: 1,284
Joined: 14-November 04
From: Southampton, Hampshire
Member No.: 4,165



Continuing the sidenote - From a security point of view, storing logic inside a database seems a risky buisness - IMO, only data should be in a databse, logic should be somewhere, read-only at the filesystem level.


--------------------
Fixed your problem? Let us know!
richard@linuxhelp.net

www.Gathr.co.uk Online Event Management
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 24th October 2017 - 06:27 AM