yacenty Posted September 13, 2007 Share Posted September 13, 2007 Hello everybody, I'm not so familiar with server and my last admin make my server crashed, so I would like to ask You to help me tweak my server. Let me start from the begining: HW: Athlon64 3700+ 2gb memory sata disk General usage: IPB + IPG +ICB wit other small addons: average 150 users online, peak 220-250, 3k users 70k post, also on this server I have: small SMF forum, average 3users online small 2 wordpresses with only few visits monthly small Joomla cms - average 20 visits daily small oscommerce shop - average 100 visits monthly :( SOftware installed: Apache 2.2.6 PHP 5.2.4+ eaccelerator 0.9.5.2 mysql 4.1 here are my configs: my.cnf What should I do to tweak my server? Thanks in advance, BR YacentY[mysqld] default-character-set=latin2 init-connect = "SET NAMES latin2" language=polish skip-bdb #skip-innodb key_buffer = 192M #16MB myisam_sort_buffer_size = 34M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 1528 thread_cache_size = 286 tmp_table_size = 64M max_allowed_packet = 16M query_cache_limit = 2M query_cache_size = 256M #64M query_cache_type = 1 query_prealloc_size = 16384 query_alloc_block_size = 16384 tmpdir=/tmp #myisam-recover [mysqld_safe] open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 10M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M [client] default-character-set=latin2 my apache conf - threads section <IfModule mpm_prefork_module> StartServers 30 MinSpareServers 10 MaxSpareServers 30 MaxClients 150 MaxRequestsPerChild 0 </IfModule> Link to comment Share on other sites More sharing options...
bfarber Posted September 14, 2007 Share Posted September 14, 2007 key_buffer should be right around 25% of the memory since it's not a dedicated. I would increase it to 256M to start with though. Add to mysql config read_rnd_buffer_size = 1M Save the my.cnf and restart mysql. Make sure your ibf_sessions table is type HEAP. You can change it in phpmyadmin. Link to comment Share on other sites More sharing options...
yacenty Posted September 15, 2007 Author Share Posted September 15, 2007 these 2 values changed - but all my tables are MyISAM - how to exchange table to HEAP? thanks in advance BR YacentY Link to comment Share on other sites More sharing options...
bfarber Posted September 17, 2007 Share Posted September 17, 2007 alter table ibf_sessions engine=heap Link to comment Share on other sites More sharing options...
naeruj Posted January 23, 2008 Share Posted January 23, 2008 [quote name='bfarber' post='1674036' date='Sep 14 2007, 09:16 AM']key_buffer should be right around 25% of the memory since it's not a dedicated. I would increase it to 256M to start with though. Add to mysql config read_rnd_buffer_size = 1M Save the my.cnf and restart mysql. Make sure your ibf_sessions table is type HEAP. You can change it in phpmyadmin. how do i do this? thank you Link to comment Share on other sites More sharing options...
bfarber Posted January 23, 2008 Share Posted January 23, 2008 If you don't know how you are probably best off asking your host to do it. If you are on shared hosting, I wouldn't expect them to make any changes on your behalf. If you have a dedicated, you would edit the file /etc/my.cnf, save, and restart mysql. Link to comment Share on other sites More sharing options...
Axel Wers Posted January 25, 2008 Share Posted January 25, 2008 [quote name='bfarber' post='1674036' date='Sep 14 2007, 04:16 PM']Make sure your ibf_sessions table is type HEAP. You can change it in phpmyadmin. I am running on shared server. Can I use it too, or it's recommended only for dedicated servers? Link to comment Share on other sites More sharing options...
bfarber Posted January 25, 2008 Share Posted January 25, 2008 You can use that on a shared server. Link to comment Share on other sites More sharing options...
Axel Wers Posted January 26, 2008 Share Posted January 26, 2008 Thanks. Er... mysql server must be restarted then or not? Link to comment Share on other sites More sharing options...
bfarber Posted January 28, 2008 Share Posted January 28, 2008 No, changing the table type does not require mysql to be restarted Link to comment Share on other sites More sharing options...
Axel Wers Posted February 8, 2008 Share Posted February 8, 2008 OK, now I have this situation: ibf_sessions table has been switched to HEAP - when I tried to optimize database and export, in both cases I got error message (I wasn't able optimize nor export) and I had to switch ibf_sessions table back to MyIsam. Is it right procedure or can I optimize (export) database without this table? Link to comment Share on other sites More sharing options...
bfarber Posted February 8, 2008 Share Posted February 8, 2008 You should be able to export the table. You can only optimize MyISAM tables with MySQL, so that's normal. Link to comment Share on other sites More sharing options...
Axel Wers Posted February 8, 2008 Share Posted February 8, 2008 All right ;) I want to export whole database, all tables togheter. When I export gzip, file is big about 16 MB. When I exported whole database (ibf_sessions table HEAP included) downloading was suddenly aborted around 3,5 MB. I switched that table to MyIsam and gzip was successfuly exported in right size (16 MB).You can only optimize MyISAM tables with MySQL, so that's normal.You should be able to export the table. Link to comment Share on other sites More sharing options...
bfarber Posted February 11, 2008 Share Posted February 11, 2008 Hmm, couldn't say why that would happen, but the table type should not affect ability to export. Link to comment Share on other sites More sharing options...
Axel Wers Posted February 11, 2008 Share Posted February 11, 2008 OK never mind :) I switched table to MyIsam, exported whole database and then switched it to Heap again. Link to comment Share on other sites More sharing options...
Axel Wers Posted March 25, 2008 Share Posted March 25, 2008 Which tables could be switched to Memory for better performance?ibf_sessions is already there... what about ibf_search_results or ibf_admin_sessions, etc...? Thanks. Link to comment Share on other sites More sharing options...
bfarber Posted March 25, 2008 Share Posted March 25, 2008 Yes, both of those could. Essentially, any tables that won't get huge and do not hold critical data you can't afford to lose (since they are cleared when mysql restarts). Link to comment Share on other sites More sharing options...
ikillbill Posted March 26, 2010 Share Posted March 26, 2010 we tried to change ibf_search_results to HEAP on 3.0.5 it shows #1163 - The used table type doesn't support BLOB/TEXT columns any ideas please Link to comment Share on other sites More sharing options...
ikillbill Posted April 5, 2010 Share Posted April 5, 2010 please help? Link to comment Share on other sites More sharing options...
Owdy Posted August 15, 2010 Share Posted August 15, 2010 [quote name='bfarber' timestamp='1189782987' post='1674036'] Make sure your ibf_sessions table is type HEAP. You can change it in phpmyadmin. Is this still valid? Link to comment Share on other sites More sharing options...
3DKiwi Posted August 15, 2010 Share Posted August 15, 2010 You know for anyone wanting their server optimized, I would save all the heartache and get IPS to optimize your server for you. I had them do this for my dedicated server last week. The price was pretty reasonable and saved me tinkering with stuff I didn't have a clue with. 3DKiwi Link to comment Share on other sites More sharing options...
SecondSight Posted August 16, 2010 Share Posted August 16, 2010 Hello ! :) How did you get IPS to optimize your server ? Is your board hosted by IPS ? [quote name='3DKiwi' timestamp='1281864768' post='2006058'] stuff I didn't have a clue with. Can you tell us more, please. Thank you ! :) Link to comment Share on other sites More sharing options...
3DKiwi Posted August 16, 2010 Share Posted August 16, 2010 No my server isn't hosted with IPS. I just got in touch by email and asked them about making my server more reliable. They came back with a price. I agreed and they did it. 3DKiwi Link to comment Share on other sites More sharing options...
Leooooo Posted August 17, 2010 Share Posted August 17, 2010 [quote name='3DKiwi' timestamp='1281981510' post='2006889'] No my server isn't hosted with IPS. I just got in touch by email and asked them about making my server more reliable. They came back with a price. I agreed and they did it. 3DKiwi may we know for exemple how resonable was this price and wich kind of tweaks were performed ? Link to comment Share on other sites More sharing options...
JoN IPB Posted August 17, 2010 Share Posted August 17, 2010 [quote name='Leooooo' timestamp='1282007021' post='2007097'] may we know for exemple how resonable was this price and wich kind of tweaks were performed ? I would be interested in it too :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.