Hi All,
I am very new. I wish to do some exercise before I go to real business.
Could anyone advise me any tutorial link or resources for beginner?
With best regards,
Abu Naser
School Of Life Sciences
Heriot-Watt University
Edinburgh EH14 4AS
Email: [EMAIL PROTECTED]
Phone: +44(0
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
After I replace with this DDL mysql back normaly,
the load average 13 if i change max_connection=150 and table_cache=96
using the second DDL.
mysqler expert please analyze this, i would know why.
the query just result total of record:
1st query:
+--+
| COUNT(*) |
+--+
|350
|
| 285 | udm_dba | localhost | udm | Query | 191 | Waiting for table | SELECT
COUNT(*)
FROM
ACCOUNT a,
DOMAIN b,
STATUS c,
USER_PROFILE d,
EMAIL_ADDRESS e,
D |
Abu([EMAIL PROTECTED])@Wed, Nov 28, 2001 at 12:50:21PM
I dont understand mysql eat system 13 load average after that mysql hang while
runing query via web using DBD-Mysql and DBI.
Everyone help me for your experience how to tuning mysql for this solution.
Thanks
-Abu-
kernel-2.4.9-6 on rh 7.1
mysql-3.23.36-1
mysql-devel-3.23.36-1
mysql-server
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 PR
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 assummi
