Mysql.server Setting

May 17, 2008

Running CentOS 4.6. Currently, the my.cnf contains:

Code:
[mysql.server]
user=mysql
basedir=/var/lib

If I moved all files and directories under /var/lib/mysql/ to /harddisk3/mysql/ what do I enter for the basedir path?

View 5 Replies


ADVERTISEMENT

Large Server: Get Rigth Setting For Mysql My.conf

Nov 10, 2007

on optimizing mysql

My server specs:

Quote:

Server: Quad Processor Quad Core Opteron 8344 - 1.80GHz - 16 x 512KB cache
Ram: 8 GB DDR2 Registered 667
Disk Controller: SA-SCSI RAID 1 Disk Controller
First Hard Drive: 147GB SA-SCSI 10K RPM
Second Hard Drive: 147GB SA-SCSI 10K RPM

my.conf file:

Quote:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=25
max_connections=500
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=8M
read_buffer_size=8M
max_connect_errors=10
thread_concurrency=16
"/etc/my.cnf" 57L, 893C
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=25
max_connections=500
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=8M
read_buffer_size=8M
max_connect_errors=10
thread_concurrency=16
myisam_sort_buffer_size=64M
server-id=1

#[mysql.server]
#user=mysql
#basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

#[mysqldump]
#quick
#max_allowed_packet=16M

[mysql]
no-auto-rehash

[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

is this good enough or we could fine tunning it more?

View 2 Replies View Related

Setting Up MySQL

Apr 12, 2007

I am setting up Geeklog and I have this question:

$_DB_host = 'localhost'; // host name or IP address of your DB server

What should I put as a 'localhost'?

1) domain.com

2) IP address of domain.com

3)?

where it says Database server IP, I don't know if that is the same IP of my domain name or how to find out the DB server IP

View 2 Replies View Related

MySQL - Setting Up Languages

Jun 1, 2007

I have a script that pulls information from a mysql database. The script pulls information on english, spanish and portuguese.

There are some spanish and portuguese characters that are not displayed correctly.

How can I setup MySQL database to correctly display those characters:

These are some of the wierd portuguese characters displayed:

nós, e foi. Nós jÃ

View 6 Replies View Related

How To Setting Mysql Date/time

Mar 5, 2007

how to setting mysql data / time?

server have -9 H from our

We have setting under WHM for time server but we also need to setting mysql

View 1 Replies View Related

Setting Root Password MySQL

Dec 18, 2007

I can't seem to get passed p21 of Database Driven Website by Kevin Yank. But I'm learning

Ive got the latest copy and and want to follow it through to see what i can learn (lots I'm sure)

Im on a mac osx and am trying to set the root password. He says to do this using terminal in the bin directory of my MySql installation.

Where is it? i know basics about getting round terminal i.e changing directories and stuff.

View 4 Replies View Related

Setting Up Free Email Service And Storing Mails In MySQL

Feb 14, 2007

I have a busy dating website with 30 000 registered users and ~200-600 users online all the time. I would like to offer free email with ~10 MB mailbox to all users.

I have an idea to use scripts provided by b1gmail.de. Its similar to Hivemail or Socketmail. It uses only one POP3 catch-all mailbox and stores all emails in MySQL database, including attachments.

My worries are about MySQL. If I have 30 000 users and each user has some 5000 messages in his/her mailbox:
30 000 x 5 000 = 150 000000

That's 150 million rows in one table!

I know, not all users will have 50000 messages in their mailboxes, but the number of users increases about +2000/month.

I can't imaggine how long time will need MySQL to find messages for each user in the table with 150 000000 rows.

I don't know - maybe it's not a problem at all. I just never had such large tables and I don't know if it's possible at all.

Another problem: I have Fedora Core 2 installed and even don't know yet if it supports files larger than 2 GB.

Maybe it's better to set-up normal POP3 mailboxes for all users instead of using one catch-all box and storing data in MySQL?

do not post warnings about spammers. In the beginning I'll provide email addresses only to "gold" members. I opened this thread because I don't want to set-up a system which will hang after a couple of months because MySQL will not be able to handle it or I will have other unknown problems.

View 4 Replies View Related

Cpanel Domain Name Server (DNS) Setting For Email On 2 Seperate Server

Nov 7, 2009

This is the scenario, domain.com are setup on server1, however server2 also has the same profile of domain.com as we use ns3 and ns4 using domain.com. This works fine with the nameserver setup on server2.

However I encounter problems as the emails from server2 won't reach server1 as there are duplicate profile on server2.

My question is how do I setup the DNS in cpanel/whm from server2 so the emails from server2 will reach server1?

Server1 (www.domain.com)
ns1.domain.com
ns2.domain.com

Server2
ns3.domain.com
ns4.domain.com

View 6 Replies View Related

What's The Best Setting For VPS Server

Jan 6, 2009

I got a VPS server and i want to setting up it.

View 5 Replies View Related

Setting Up Second DNS Server

Apr 16, 2009

I've bought a VPS and would like run it has a 2nd DNS server and host WHMCS on it. I run a typical CPanel setup.

View 2 Replies View Related

Setting My Own Server

Mar 26, 2009

I am interested in setting up my own server, more than anything just for the experience. I would like it to be a linux-based server and to be managed purly through the command line [i.e. no GUI].

Can anyone point me towards any goods book/resources for learning this? From what I read I believe that sitepoints own book does not cover any command line stuff, and everything happens purly through the GUI.

View 3 Replies View Related

Setting Up Dns Server

Feb 9, 2007

i bought a dedicated server but i dont know how to configure the dns,finally my brother said that he will setup the server on Wednesday after his work is over..but its quite a long time.can some one pls help me how to set the dns

my nameservers are ns1.vidztec.com and ns2.vidztec.com .

View 3 Replies View Related

Setting Up Dns Server

Aug 13, 2007

i bought the dedi recently. now since i will be moving all my sites over the server, the nameservers needs to be changed. i asked my host and they said they charge $90 to setup the nameservers, or i can buy the managed package. both costing more money than i thought.

i was wondering there must be a way for setting up one myself? it's a centOS 5. is there a tutorial out there?

View 3 Replies View Related

Setting Up A Server

Aug 7, 2007

I got a VPS, with Ubuntu server on it. I was wondering how i make it so that when it gets http requests, it shows a certain directory? I dont want to install a control panel, i want to learn to do everything manually, so that i can make the VPS show one domain only, with PHP and SQL and all that.

I can find out how to install PHP and SQL, but further than that,

FOr example. demonoid.com resolves to an IP. If you visit that ip directly, you get the site. How do i do that??

No control panel, nothing. ONly one domain.

View 8 Replies View Related

Setting Up A Web Server

Feb 25, 2007

We have a database developed in oracel which is accessed be a lot of clients in our organization in our own domain ( a lan within the same building).

My own laptop is a cleint and I have access to the oracle sever finely.

Now I have developed a website in asp which has several quries for the databse. I am using my laptop as a webserver and broweser and the website is working excellent.

Now I want to

(1)All the people in my domain should have access to this website.
I dont know how to do it. As it should be using a local network and my own computer should be a webserver. Please advise.

(2) Is it possible for my to uplodoad my site to a third-party webserver like yahoo or brainnet and people should have access to this site globally.

View 3 Replies View Related

Setting Up A Server Running ZFS As A Backup Server

Mar 30, 2009

setting up a server running ZFS as a backup server. My only problem is that it's very new to me, and naturally I'm skeptical of it's redundancy capabilities etc, I don't want to get burned. Anyone used ZFS, what's your experience with it?

View 2 Replies View Related

Setting Up My Own Server At Home

Sep 30, 2009

So I have designed some software for my brother who owns a business and needed a website to manage his clients and send emails to them and stuff. Right now we are using Hostmonster, which has been pretty good so far.

He was talking to me how it would be nice to be able to email the website and have the site automatically store the information in these emails into a database for information regarding his clients, which I know is possible, but not on a shared host it seems. I have tested my own email receiving script on a test server on my computer and it works fine. So we are continually finding our limits with a shared host. We have been looking into dedicated hosting, but as you all know its quite a price jump to go from $7 a month to $200+.

I got thinking and remembered that my dad has always had a business web plan from our ISP at home (cause he likes fast internet), which according to there website serves 1Mbps upload speed. We also have 2-3 old computers sitting at home that we don't use anymore (2)2ghz pentium 4 Dells and a 3.0ghz+ Pentium 4 HP. I was thinking we could probably just plug one of those into the router, forward some ports and have our own server up and running. For now we would only host this software I made for my bro, which is used by only 4 people, and that's not even at the same time usually. So there is very little load to deal with. But in the future we may put a few other sites that we have in mind which would use PHP and MySQL quite a bit.

I was just curious what some of your opinions were on creating a home server. I was looking at Ubuntu Server edition as a possibility, or XAMPP since all my machines are Windows XP. One machine doesn't work cause the hard drive is out, so if I use that I would probably have to put Ubuntu on it. Any suggestions on good server software would be great! I believe the business web plan my dad has also comes with a static IP as well, so that will help. Look forward to hearing your suggestions!

View 12 Replies View Related

Setting Up A Game Server

Nov 7, 2007

as you may know i am fairly new at setting up my own servers, well i was wondering if anyone out there could help me with setting up a dedicated game server to run halo or battlefield i have halo server installed on my windows xp box and followed the read me from start to finish, have port forwarded to the box but i just get the command line coming up saying dedicated server is running on map timberland <0 / 12 players>

im looking to host this game to the internet for people to play off my server not just for a lan server of the game.

View 8 Replies View Related

SSD Drives In A Server Setting

Oct 4, 2009

Does anyone have experience with SSD drives in a server environment? I've seen now a few offers with SSD (Intel) and wondering if the speed is noticeable?

Are they worth it? from what I have been reading is that they a superior in reliability, but have issues with limited write cycles.

View 14 Replies View Related

Setting Up A SMTP Server

Feb 5, 2009

I'm setting up an invite and request email notification system for my website. Its pretty process heavy (since all the invites and requests will need to be sent right away), so I'm planning to setup another machine that is only designed to send the emails.

So I guess a SMTP server right?

I have no problems installing PHP and linking the user generated emails, but how does this work in regards to the domain name?

When the user imports his or her contacts on the main server (domainname.com) which then triggers the invite emails to be sent out with the SMTP server then how does that effect the clients' inboxes?

Since the website that they've registered to is www.domainname.com and the SMTP server domain name is smtp.domainname.com?

How does this all work?

What I worried about is the inbox seeing the emails as apart of a different domain name and then tossing it all to the junk box.

View 2 Replies View Related

Setting Up Home Web Server

Oct 10, 2009

I am running windows 7 Ultimate.

I have installed Apache, PHP and MySQL cus they are |33t.

I am using free dns.. the domain name is PowerfulPlacement.com

localhost WORKS

PowerfulPlacement.com does not work... Here is my VirtualHost in my httpd.conf..

NameVirtualHost 72.219.185.53
<VirtualHost 72.219.185.53:80>
ServerName powerfulplacement.com
ServerPath D:/www
DocumentRoot "D:/www/"
<directory D:/www/>
allow from all
</directory>
</VirtualHost>

I dont know why powerfulplacement.com isn't working. I remember in linux I had to start up named or dns or something for it to work but I'm not quit sure with Windows.

View 4 Replies View Related

Setting Up A Simple Server

May 21, 2009

when I get a server it comes with cPanel and I don't have to do much to get it going, but this time I don't need all the bells and whistles. What should I do to get a server with only CentOS to start running a pretty simple web server that just listens on whatever ip? I just want it to run php,mysql, and a web server which I know how to setup already. What I want to know is what else is necessary to setup? Resolvers, the hostname, bind, named, etc?

View 2 Replies View Related

Setting Up A Preview Server

Jan 5, 2009

setting up a preview server.

We have a number of clients and develop our work on a local preview box running IIS and XAMPP.

We need to setup a preview server with CVS and client preview areas i.e. a directory for each client locked down for them to view.

View 0 Replies View Related

Setting Up Remote Sql Server

Apr 24, 2008

i am trying to setup a remote sql server , the web server which runs everything but sql is cpanel/WHM and the SQL server is Centos 5. I have installed mysql on the SQL server and it is running.

When i put the information in cpanel for remote sql setup it comes up with an error of :

usr/bin/mysqladmin: connect to server at 'IP Address' failed error: 'Host 'hostname' is not allowed to connect to this MySQL server' mysql has failed, please contact the sysadmin (result was "mysql has failed").

Is there something i have to enter in the remote sql server to allow the IP address of the cpanel server to be able to connect to the SQL server?.

View 6 Replies View Related

Setting Up Windows XP VPN Server

Jun 15, 2008

I am able to do a VPN connection to the Windows XP VPN server.

But however i cannot access the remote VPN computers.

View 3 Replies View Related

Setting Up My Own Ftp Backup Server

Jul 25, 2008

i just lease a server that comes with 2 hard drive.

i want to make use of both hard drive as fully dedicated backup server to backup my other server via ftp.

i have no problem with first hard drive as I can easily create the ftp user via directadmin to /home/backup1

the thing i am having problem is now, i've mounted the /dev/sdb1 as /backup2

now the question is, how am i able to create a FTP account (in DirectAdmin) pointing it to /backup2 ? Or how do I do it in ssh command?

View 0 Replies View Related

Setting Up A New Web Server At Home

Jun 24, 2008

ive got a windows server 2003 enterprise edition server at home and i have 8 static ip addresses that came with my adsl broadband

how can i set up a web server with that i also have a domain

step by step guide on setting up a web server at home

View 14 Replies View Related

Setting Up An Inhouse Server.

Aug 6, 2008

I have an old computer that I want to setup as a server, for some small projects that I would like to publish online. I don't want to install any GUI's if I don't have to. What I would like to do is install linux (not sure which one), apache, php, and a webhost manager to handle the domains on that box. Can someone point me to a tutorial or in the right direction here? I would like to practice installing these things on my home box for now so I can get used to. I was going to install ubuntu, but thought that was to excessive for what I want.

View 11 Replies View Related

Setting Up FTP On Dedicated Server

Jun 4, 2008

Ive just purchased dedicated server (Windows Server 2003) I need to upload a large ammount of files.

Im connecting to it via remote desktop at the moment but I want to use FTP.

Someone told me to look in the add/remnove programmes @ windows compononents & check that FTP was enabled in the IIS or something
I looked, couldnt find the IIS.

how to set up this dedicated server to accept FTP?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved