Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Mysql optimization

Quote Reply
Mysql optimization
This is a file I found on optimizing MySQL. Seems to be updated regularly.

http://www.mysql.com/...-20000719/index.html

And here is a page on performance tuning MySQL.

http://www.mysql.com/...ual_Performance.html


http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: Mysql optimization In reply to
Thanks,

this is a piece of useful information.
And an other reason to use a sparc :-)

regards, alexander

Quote Reply
Re: Mysql optimization In reply to
Thankyou for this information. extremely interesting. It sure seems that Solaris is an very interesting system to run MySQL applications on. Also the comparison chart of speed for different SQL servers near the middle of the first page is very useful piece of information in general.

If I may ask the question in this thread :-)
I was wondering whether you knew any hosting companies that provide dedicated sparcs or shared sparcs in-house. I mean where you don't have to ship them a Sparc, that they have a sparc in with the package and handle day to day management of the data center and the sparc. I don't actually see the advantage of owning one since the prices drop so quickly and/or newer servers are much more powerful for similar prices. Also I work in France and taking advantage of US prices for hosting would cost a bomb if I had to ship a server, let alone the danger of it being damaged during the transfer.

Thanks Jag

Quote Reply
Re: Mysql optimization In reply to
Several of the companies do. And the hosting package I am (still) working on with my ISP is all Sparc, no Intel unless you really, really get down and grovel. Sparc/Solaris has some very good features for this sort of project. Especially for the "back end".

Running "thin" apache to just serve web pages and proxy to the back end server, you could probably use an Intel box or a Raq with no problems, but for "through put" on the processor I have never had a machine that performed like this Sparc, and I have a "baby" sparc!!

Figure in general, a Sun/Sparc/Solaris box will be about 2x the hardware cost of an equivalent Intel box, but from everything I've seen you will get 2-4x the performance or more. It's hard to compare because memory management and process management is _very_ different on the two archetectures, and then toss the difference is Unix to NT on top of that and it's even more.

One feature Solaris doesn't have is site.ext -- that's the utility that allows you to execute commnds via FTP (such as CHMOD). I don't know if you can add it on, but that is probably why most ISP's do not offer Solaris in a "shared" environment, unless they are set up to offer telnet (you need to telnet in to do a permissions change). This is not a problem for a "stable" box like a database server, but a "front end" machine like a communal web server, it can be a nuisance.

One advantage of that though, is if you are hosted on a Solaris system, you probably have TELNET access :) And that is _much_ more valuable than the site.exe utility.

I recently tried to move a Links/Advert Pro/other-ad system to a new server without telnet, and I will _never_ do that again. We eventually gave up.

If you are doing a new install, you are adding files one at a time, and they'll have server permissions. If you do a "move" from another machine, they will have your permissions, so you have to CHMOD/CHOWN the files. By FTP it is a one at a time process, and with 800+ files is a _very_ long job. With telnet, you can do something like:

chmod -R 777 dir

and be done with it.

or, if you have coded the old server name into the scripts and templates (bad idea, but it's done a lot), you would have to edit each one, one at a time. If you had telnet access, you could do something like:

perl -pi.bak -e s/oldstring/newstring/g filename(s)

And be done with it. If I had a choice, I'd take telnet access over the site.exe ability :) And, I guess most people do, since solaris is still so wildly popular.

(For those who don't know what the above line would do:
Code:
1) it will execute (-e) Perl from the command line
2) it will substitute (s/) all occurrences of the oldstring with the newstring
3) globally (/g)
4) for all the filenames that follow.
5) Wildcards can be used.
6) In case you do make a mistake it also creates a backup of the original named
original_file.bak (-pi.bak)
)


http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/