Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

I need a MySQL expert. Very badly.


  • Please log in to reply

#1
wynnyelle

wynnyelle

    Member

  • Member
  • PipPipPip
  • 116 posts
Before I get too into detail I will just say that I have a website, that has some kind of serious database issues that need to be fixed, very badly. They constantly lock up the MySQL queries and the whole website goes down.

I'm beside myself and need a true expert, very badly. I don't know where to look.

The website is an SMF forum.
  • 0

Advertisements


#2
modernsavage

modernsavage

    Retired Staff

  • Retired Staff
  • 51 posts
Well I know MySQL very well and I have a couple of websites myself that use MySQL. I also have some friends who worked at Sun Microsystems in the UK before in got bought by Oracle. Having said that though, whether or not I'll be able to help you within the confines of a forum is another matter.
  • 0

#3
wynnyelle

wynnyelle

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 116 posts
Thanks for answering. I have to start somewhere, so might as well here. Out of all the places I've looked, you answered me first.

The situation is very bad. The site crashes almost daily. I've been informed by my host that database problems are about 90% of my site's technical issues. It's a hobby site, but it's my baby, it's my labour of love.

I have a list of errors if you wanted to see them, or if you want any more information just let me know. Thank you again.
  • 0

#4
modernsavage

modernsavage

    Retired Staff

  • Retired Staff
  • 51 posts
Sure lets see the error list and any other information you can give. Also the URL.
  • 0

#5
wynnyelle

wynnyelle

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 116 posts
of course. the url is http://warriorcatsrpg.com

I also need a top to bottom coding fix, but that's second to the database right now.

i will list some of the errors the database got {too many to fit here}


)
SELECT lt |
| 5699753 | warrior_acorn | localhost | warrior_smf | Query | 332 | Locked | SELECT
t.id_topic, t.num_replies, t.locked, t.num_views, t.is_sticky, t.id_poll, t.id_previous_b |
| 5699754 | warrior_acorn | localhost | warrior_smf | Query | 332 | Locked | SELECT
t.id_topic, t.num_replies, t.locked, t.num_views, t.is_sticky, t.id_poll, t.id_previous_b |
| 5699755 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5699757 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT id_member, real_name
FROM smf_members
WHERE id_member IN (26427) |
| 5699759 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5699758 | warrior_acorn | localhost | warrior_smf | Query | 332 | Locked | SELECT
t.id_topic, t.num_replies, t.locked, t.num_views, t.is_sticky, t.id_poll, t.id_previous_b |
| 5699760 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT m.subject, IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body
FRO |
| 5699761 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5699762 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '76.172.105.25', member_ip2 = '76.172. |
| 5699763 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | INSERT INTO smf_messages(`id_board`, `id_topic`, `id_member`, `subject`, `body`, `poster_name`, `pos |
| 5699764 | warrior_acorn | localhost | warrior_smf | Query | 55 | Locked | CREATE TEMPORARY TABLE smf_log_topics_posted_in (
PRIMARY KEY (id_topic)
)
SELECT lt |
| 5699766 | warrior_acorn | localhost | warrior_smf | Query | 55 | Locked | SELECT
lo.id_member, lo.log_time, lo.id_spider, mem.real_name, mem.member_name, mem.show_online,
|
| 5699767 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,
t.id_member_s |
| 5699769 | warrior_acorn | localhost | warrior_smf | Query | 55 | Locked | SELECT
lo.id_member, lo.log_time, lo.id_spider, mem.real_name, mem.member_name, mem.show_online,
|
| 5699770 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,
t.id_member_s |
| 5699771 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from
FROM smf_topics AS t
LEF |
| 5699772 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | INSERT INTO smf_messages(`id_board`, `id_topic`, `id_member`, `subject`, `body`, `poster_name`, `pos |
| 5699773 | warrior_acorn | localhost | warrior_smf | Query | 332 | Locked | CREATE TEMPORARY TABLE smf_log_topics_posted_in (
PRIMARY KEY (id_topic)
)
SELECT lt |
| 5699774 | warrior_acorn | localhost | warrior_smf | Query | 332 | Locked | SELECT
ms.subject AS first_subject, ms.poster_time AS first_poster_time, ms.id_topic, t.id_boar |
| 5699776 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
lo.id_member, lo.log_time, mem.real_name, mem.member_name, mem.show_online,
mg.online |
| 5699777 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,
t.id_member_s |
| 5699778 | warrior_acorn | localhost | warrior_smf | Query | 332 | Locked | CREATE TEMPORARY TABLE smf_log_topics_posted_in (
PRIMARY KEY (id_topic)
)
SELECT lt |
| 5699779 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '66.220.177.70', member_ip2 = '66.220. |
| 5699780 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '70.65.28.103', member_ip2 = '70.65.28 |
| 5699781 | warrior_acorn | localhost | warrior_smf | Query | 332 | Locked | SELECT

t.id_topic, t.num_replies, t.locked, t.num_views, t.id_board, b.name AS board_name,

I |
| 5699782 | warrior_acorn | localhost | warrior_smf | Query | 332 | Locked | CREATE TEMPORARY TABLE smf_log_topics_posted_in (
PRIMARY KEY (id_topic)
)
SELECT lt |
| 5699783 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | INSERT INTO smf_messages(`id_board`, `id_topic`, `id_member`, `subject`, `body`, `poster_name`, `pos |
| 5699784 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '206.188.93.204', member_ip2 = '206.18 |
| 5699785 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
b.id_parent, b.name, 239 AS id_board, IFNULL(mem.id_member, 0) AS id_moderator,
mem.r |
| 5699787 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5699788 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | CREATE TEMPORARY TABLE smf_log_topics_posted_in (
PRIMARY KEY (id_topic)
)
SELECT lt |
| 5699789 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5699790 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '99.35.214.61', member_ip2 = '99.35.21 |
| 5699791 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,
t.id_member_s |
| 5699792 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | INSERT INTO smf_messages(`id_board`, `id_topic`, `id_member`, `subject`, `body`, `poster_name`, `pos |
| 5699793 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
b.id_parent, b.name, 89 AS id_board, IFNULL(mem.id_member, 0) AS id_moderator,
mem.re |
| 5699794 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '174.20.86.1', member_ip2 = '174.20.86 |
| 5699795 | warrior_acorn | localhost | warrior_smf | Query | 55 | Locked | SELECT
lo.id_member, lo.log_time, lo.id_spider, mem.real_name, mem.member_name, mem.show_online,
|
| 5699796 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '98.246.126.131', member_ip2 = '98.246 |
| 5699797 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,
t.id_member_s |
| 5699798 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
FROM smf_members AS mem
|
| 5699799 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
b.id_parent, b.name, 121 AS id_board, IFNULL(mem.id_member, 0) AS id_moderator,
mem.r |
| 5699800 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,
t.id_member_s |
| 5699801 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5699802 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '174.26.201.210', member_ip2 = '174.26 |
| 5699804 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | SELECT
b.id_parent, b.name, 89 AS id_board, IFNULL(mem.id_member, 0) AS id_moderator,
mem.re |
| 5699805 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '67.1.5.91', member_ip2 = '67.1.5.91', |
| 5699806 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '203.100.211.183', member_ip2 = '203.1 |
| 5699807 | warrior_acorn | localhost | warrior_smf | Query | 56 | Locked | UPDATE smf_members
SET last_login = 1327368841, member_ip = '71.236.227.217', member_ip2 = '71.236 |
| 5699808 | warrior_acorn | localhost | warrior_smf | Query | 55 | Locked | CREATE TEMPORARY TABLE smf_log_topics_posted_in (
PRIMARY KEY (id_topic)
)


the site would just suddenly start going down because these queries locked up. there was nothing i could do. it's the slow time right now but in about 12 hours it will start picking up again and that's when the disasters happen. if i am lucky, there is no permanent damage from them on that day, only down time.

here is what my host went through and told me

I am going to let it run the processes for the next 10 minutes as I am logging the queries for you. If it doesn't finish it by the next 10 minutes, then I can restart the SQL server for you if you wish.


Following are the queries shown under your website when the "mysqladmin processlist" command is executed during the peak CPU MySQL usage.


{he listed the errors then}

Shall I simply restart the MySQL server? It could solve the issue temporarily. The query locking is something that you will have to consult a MySQL expert to fix it.


he restarted it then. it stopped misbehaving for the most part at that point.

You will have to do your homework on this issue and look for a fix. I can simply provide you with evidence wherever possible.


The whole MySQL and Email issues are completely different. Yes, both of them relate to a certain extent, but by solving the email problem, you might be resolving only 10% of your problems while the MySQL issue contributes to the other 90% of your issues.

MySQL databases are very sensitive and unless a person has 100% of what they are doing, they shouldn't play with it.

After explaining the problems you are facing, you keep on coming back to the coding issues shown in the error log. There is a much bigger picture put forward to you. The coding fixes may help, however the MySQL database locking queries is a bigger issue than any other issue that you may be facing in my opinion.


Edited by wynnyelle, 24 January 2012 - 03:55 AM.

  • 0

#6
modernsavage

modernsavage

    Retired Staff

  • Retired Staff
  • 51 posts
Some more questions for you ..

Is the site written in PHP ?

Are you using a content management system ?

Is the site on shared hosting or are you renting a server ?

What OS is on the server ?
  • 0

#7
wynnyelle

wynnyelle

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 116 posts
Yes, it is written in PHP, boy is it.

I am not sure what a content manager is...

It is a dedicated server; we are renting.

I am not sure of the OS. I can posit these questions I don't know to my host, but he could take a while to get back to me, but I will ask. I hate to be in a hurry, but I am.

Wait--is content management, like Cpanel? Because I have that.

Edited by wynnyelle, 24 January 2012 - 04:04 AM.

  • 0

#8
modernsavage

modernsavage

    Retired Staff

  • Retired Staff
  • 51 posts
Content management would be something like Joomla, Drupal etc.

Here is a list of them http://en.wikipedia....agement_systems

I'm thinking this is a record level locking issue.

Also what version of MySQL is on the server ?
  • 0

#9
wynnyelle

wynnyelle

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 116 posts
Oh geez, I don't even know the answer to that, I just posted it to my host to ask. I know we do not use Joomla, Drupal probably not. Waiting on an answer for the questions. Is there any place I could look these things up on my server? I'm so sorry I don't know more.
  • 0

#10
modernsavage

modernsavage

    Retired Staff

  • Retired Staff
  • 51 posts
If you create a php file with the following code in it...

<?php phpinfo(); ?>

upload it to your site and then view the page in your browser.
  • 0

#11
wynnyelle

wynnyelle

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 116 posts
I got the info back, from my host:

"You are using CentOS 6.0 64 bit as your operating system on your server.

Your MySQL server is 5.1.56 and you have the latest stable cPanel/WHM 11.30.5 as your control panel."
  • 0

#12
wynnyelle

wynnyelle

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 116 posts
I have more info.

I was given this as being my full process list. I am using memcached. The tables are myISAM.

ame, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 18754
|
| 4418331 | x | localhost | warrior_smf | Query | 7 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
id_attach, a.filename, a.attachment_type,
IFNULL(sub.id_parent, 0) as id_parent
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.id_member = 43318)
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE mem.id_member = 43318
LIMIT 1
|
| 4418332 | x | localhost | x | Query | 7 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, c.name AS cname, IFNULL(mem.id_member, 0) AS id_moderator,
mem.real_name, b.id_board, b.child_level,
b.id_theme, b.override_theme, b.count_posts, b.id_profile, b.redirect,
b.unapproved_topics, b.unapproved_posts, t.approved, t.id_member_started, b.post_template
FROM smf_boards AS b
INNER JOIN smf_topics AS t ON (t.id_topic = 178270)
LEFT JOIN smf_categories AS c ON (c.id_cat = b.id_cat)
LEFT JOIN smf_moderators AS mods ON (mods.id_board = t.id_board)
LEFT JOIN smf_members AS mem ON (mem.id_member = mods.id_member)
WHERE b.id_board = t.id_board
|
| 4418333 | x | localhost | x | Query | 7 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
id_attach, a.filename, a.attachment_type,
IFNULL(sub.id_parent, 0) as id_parent
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.id_member = 33393)
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE mem.id_member = 33393
LIMIT 1
|
| 4418334 |x | localhost | x | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 37312
|
| 4418335 | x | localhost | x | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 27525
|
| 4418336 | warrior_acorn | localhost | warrior_smf | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 33603
|
| 4418337 | x| localhost | x | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 20084
|
| 4418338 | x | localhost | x | Query | 7 | Locked | UPDATE smf_members
SET last_login = 1327810157, member_ip = '24.154.26.173', member_ip2 = '24.154.26.173', total_time_logged_in = 1393548
WHERE id_member = 11103
|
| 4418339 | x | localhost | x | Query | 7 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
id_attach, a.filename, a.attachment_type,
IFNULL(sub.id_parent, 0) as id_parent
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.id_member = 23271)
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE mem.id_member = 23271
LIMIT 1
|
| 4418340 | x | localhost | x| Query | 7 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, c.name AS cname, IFNULL(mem.id_member, 0) AS id_moderator,
mem.real_name, b.id_board, b.child_level,
b.id_theme, b.override_theme, b.count_posts, b.id_profile, b.redirect,
b.unapproved_topics, b.unapproved_posts, t.approved, t.id_member_started, b.post_template
FROM smf_boards AS b
INNER JOIN smf_topics AS t ON (t.id_topic = 341288)
LEFT JOIN smf_categories AS c ON (c.id_cat = b.id_cat)
LEFT JOIN smf_moderators AS mods ON (mods.id_board = t.id_board)
LEFT JOIN smf_members AS mem ON (mem.id_member = mods.id_member)
WHERE b.id_board = t.id_board
|
| 4418341 | x | localhost | x| Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 21527
|
| 4418342 | x | localhost | x| Query | 6 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 39045
|
| 4418343 | x | localhost | x | Query | 6 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 37558
|
| 4418344 | x | localhost | x | Query | 6 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
id_attach, a.filename, a.attachment_type,
IFNULL(sub.id_parent, 0) as id_parent
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.id_member = 15244)
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE mem.id_member = 15244
LIMIT 1
|
| 4418345 | x | localhost | x | Query | 6 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
id_attach, a.filename, a.attachment_type,
IFNULL(sub.id_parent, 0) as id_parent
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.id_member = 36868)
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE mem.id_member = 36868
LIMIT 1


  • 0

#13
modernsavage

modernsavage

    Retired Staff

  • Retired Staff
  • 51 posts
When your site crashes what do you normally have to do to reset it ?

Register an account with http://www.pingdom.com it will let you know by email when the site stops responding and when it starts again.
It might help give you see the exact times the site crashes.

Edited by modernsavage, 29 January 2012 - 05:16 AM.

  • 0

#14
risingphoenix1985

risingphoenix1985

    Member

  • Member
  • PipPipPip
  • 131 posts
Hello,

I had a similar problem with a friends site a while back and found that the tables were MySAM. After some checking we found that this database engine locks the table when a query is run and can be the cause of some bottlenecks.

He changed it to innodb which fixed the problem.

He never told me how he did it, and I never investigated myself but the change did speed things up dramatically.
  • 0

#15
admin

admin

    Founder Geek

  • Administrator
  • 24,501 posts

It is a dedicated server; we are renting.

You really need someone to optimize your MySQL configuration file, or "my.cnf". The table locking you're experiencing is common with the MyISAM engine. Unless you have a very popular forum it should be resolved through optimization. Especially the "key buffer" setting. Selective use of InnoDB may also be required, but that takes a different tuning strategy.

Two popular MySQL tuning scripts are tuning-primer.sh, and mysqltuner.pl

Since it sounds like all this is a little over your head, I'd recommend renting a server admin to help you. Running a Linux server requires some hardening and regular patches for security, in addition to tuning. If you don't have regular help, consider renting help. I've used http://www.rack911.com/ for some projects, and have no trouble recommending them. Or for recurring monthly admin services: http://www.telnap.com/contact.htm
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP