Re: configure my.cnf
You can use server parameters see capter 10.1 Tuning server parameters. and any other for maximum performance. we use mail server, http server, app. server, on pentium 1 GHz, 800 MB of ram, nothing problem. Ady Wicaksono([EMAIL PROTECTED])@Thu, Nov 29, 2001 at 06:54:32PM +0700: Hi guys, i have 256 RAM and dual Pentium III This machine will run mail server, web server, and database MySQL server there's CGI Application that use MySQL server WITHOUT persistent connection - uh... the lack of my CGI Application What is the best configuration of my.cnf if : there will be 250 hit, concurrent access every 2 seconds HTTP (using Apache) start run with 200 Daemon MailServer use about 100 Thread -- __ (oo) Open Solution Provider visit http://www.trabas.com / \/ \ GnuPg public information pub 1024/EBD26280 `V__V' A9A9 8F57 9E9D 14E3 05B4 3EDB C241 A313 EBD2 6280 You never hesitate to tackle the most difficult problems. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect via IP, but can via hostname
Please read mysql manual, your question covered by manual. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Ady Wicaksono([EMAIL PROTECTED])@Tue, Nov 13, 2001 at 07:14:58AM +0700: Check your users and db table at mysql database probably the problem comes from there On Tuesday 13 November 2001 02:47 pm, Alex wrote: Dear Sirs, My MySQL is not configured properly... I can connect using localhost with -h flag , but when I'm using IP instead of hostname it doesn't connects at all... What'd I do? Thank you. -- ady -- email: ady at ebdesk.com adiwicaksono at yahoo.com ady at students.if.itb.ac.id homepage: http://ady97.hypermart.net/ To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- __ (oo) Open Solution Provider visit http://www.trabas.com / \/ \ GnuPg public information pub 1024/EBD26280 `V__V' A9A9 8F57 9E9D 14E3 05B4 3EDB C241 A313 EBD2 6280 You have a deep appreciation of the arts and music. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hadware SPEC
Hai, We dont know exactly how to count spec hw (CPU+RAM) to handle big database, the manual not cover it. I mean everymonth always add complex data on several db, than 1 year maybe handle 1 GB of data, how i count a RAM and (or) CPU for speed. Any document or url where i can read. We can assumming for oracle not for MySQL/DB2. Thanks ~yusril~ -- __ (oo) / \/ \ GnuPg public information pub 1024/EBD26280 `V__V' A9A9 8F57 9E9D 14E3 05B4 3EDB C241 A313 EBD2 6280 Beware of low-flying butterflies. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php