Ive got a fresh install of mysql on an ensim box from a dedicated provider. God i wish i didnt go with ensim :(
Anyway, its a 2.0ghz P4, 512mb ram.
Running RedHat7.3. (i havent had any problems with peformance, regarding apache and php)
Mysql loves to go away :
My.cnf =
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Extended Status
+--------------------------+---------+
Variable_name Value
+--------------------------+---------+
Aborted_clients 4
Aborted_connects 13
Bytes_received 1884112
Bytes_sent 9352914
Connections 119
Created_tmp_disk_tables 2
Created_tmp_tables 71
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 93
Handler_read_first 899
Handler_read_key 24469
Handler_read_next 11710
Handler_read_prev 0
Handler_read_rnd 23636
Handler_read_rnd_next 36313
Handler_update 292
Handler_write 7918
Key_blocks_used 120
Key_read_requests 156658
Key_reads 5
Key_write_requests 8529
Key_writes 1473
Max_used_connections 12
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 45
Open_files 87
Open_streams 0
Opened_tables 130
Questions 5875
Select_full_join 50
Select_full_range_join 0
Select_range 463
Select_range_check 0
Select_scan 902
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Tweaking the style of child elements inline - bytes::
6 posts - Last post: Mar 2, 2008we can do this as usual: <style type="text/css"> li{margin: 0;} </style> Thank you. . Default Re: Tweaking the style , Mr. Korpela
http://bytes.com/groups/html/777378-tweaking-style-child-elements-inlineHOME |
Slow_queries 0
Sort_merge_passes 0
Sort_range 463
Sort_rows 23636
Sort_scan 527
Table_locks_immediate 5661
Table_locks_waited 0
Threads_cached 0
Threads_created 118
Threads_connected 11
Threads_running 1
Uptime 118466
+--------------------------+---------+
Hopefully thats enough information to allow a decent my.cnf?
Or are there just some simple my.cnf options to allow a longer "Waiting" period before running away? :rolleyes:
Hrm, after a bit of mucking around, this seems to not work ?? :confused: :confused:
I am running mysql 4, so i guess thats the problem.
Where can i find an error log? :
Originally posted by merk
I tried quite a few different combinations of using the default config files supplied with mysql, medium, large, huge.
All 3 of those, 'MySQL has gone away' when i issue a mysql -uusername -p database < sql.file (the file is over 20mb)
Im just installing mysql3, maybe that might sort my problem, but is there some sort of trick if you want to load a sql dump > 20mb? you sure you have restarted mysql after changing my.cnf files ? gone away usually means either wait_time is too short or max_allowed_packet is less than 16MB in mysql 3.23.x AMX Mod Install Guide::
The mysql.cfg file in your addons\amx\config folder stores the information AMX Of course you can tweak this all if you feel like you can modify the
http://amxmod.net/doc/?p=amxmysqlHOME |
MySQL :: Re: Compiling MySQL using Rational Purify for Pentium.::
3 posts - Last post: Feb 20, 2007Recommended Servers for MySQL to the parameter that your usual script does have, so you may wish to tweak that to suit your needs.
http://forums.mysql.com/read.php?132,135593,140884HOME |
Okay you can go back to ignoring me. :(
/me hides in his corner.:rolleyes:
He must have been visiting my site prior to the move :)
Our old host had a constant load of around 35, which triggered me getting a ded host.
But i dont think my server could handle martz's site, he uses too much b/w !
I tried quite a few different combinations of using the default config files supplied with mysql, medium, large, huge.
All 3 of those, 'MySQL has gone away' when i issue a mysql -uusername -p database < sql.file (the file is over 20mb)
Im just installing mysql3, maybe that might sort my problem, but is there some sort of trick if you want to load a sql dump > 20mb?
Originally posted by merk
Hrm, after a bit of mucking around, this seems to not work ?? :confused: :confused:
I am running mysql 4, so i guess thats the problem.
Where can i find an error log? : did you restart mysql ? i recommend you downgrade to mysql 3.23.53a as vB is meant to work with 3.23.x
you both on same server ?
Originally posted by merk
He must have been visiting my site prior to the move :)
Our old host had a constant load of around 35, which triggered me getting a ded host.
But i dont think my server could handle martz's site, he uses too much b/w ! okay i see :)
i could of warned ya about ensim ;)
replace my.cnf with below and restart mysql
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=450
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=9600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
It was reasonably easy to get rid of, luckily someone wrote a sh script that does it automatically ;)
Thanks for that too. Hopefully soon (since i screwed up bind) when they get my server back online ill be able to test it! :(
eva2000, the legend.
Yeh, all is sorted now, my main problem was i wasnt checking /var/log/mysql.log.
the /var/mysql paths you gave me (or was it /var/lib/?), didnt exist, and the databases were actually in /usr/local/mysql/var(as per default install instructions in the mysql manual)
So i just took out those variables in your my.cnf, and she worked.
Thanks for the help :)
(and yeh, i did restart mysql, many times, i even tried rebooting the server :)
Originally posted by merk
Yeh, all is sorted now, my main problem was i wasnt checking /var/log/mysql.log.
the /var/mysql paths you gave me (or was it /var/lib/?), didnt exist, and the databases were actually in /usr/local/mysql/var(as per default install instructions in the mysql manual)
So i just took out those variables in your my.cnf, and she worked.
Thanks for the help :)
(and yeh, i did restart mysql, many times, i even tried rebooting the server :) ah strange the paths i used were based on your originally posted my.cnf ** shrugs *** oh well good to see it working now :)
Hopefully this has sorted out my "mysql connections exceeded" problem too, perisistant connections turned off didnt help :]
thanks for the help eva, i think that my.cnf came from ensims mysql.
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market |
PRINT
Add to favorites