bfarber

I'm a bit curious about his experience. I can't speak for the emails (he said he did get responses - I'm curious what they were) however what it sounds like is that he is outside of the country. If he is, he likely would be calling at hours we are not open (9AM-5PM EST) and is why he never reached a human. Additionally, I don't believe the sales department returns calls outside of the country.

I could be wrong though. I'm very curious about the emails though. I replied to the topic. Thanks for pointing it out.

Hmm, couldn't say why that would happen, but the table type should not affect ability to export.

You should be able to export the table. You can only optimize MyISAM tables with MySQL, so that's normal.

No, changing the table type does not require mysql to be restarted

You can use that on a shared server.

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.

alter table ibf_sessions engine=heap

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.

I'll throw these out there for you start with.

apc.shm_segments = (experiment); 1 apc.shm_size = (experiment); 30 apc.optimization = 1 apc.num_files_hint = 1000 apc.user_entries_hint = 20 apc.ttl = 300 apc.user_ttl = 180 apc.gc_ttl = 60 apc.cache_by_default = 1 ;apc.filters = '' ;apc.mmap_file_mask = '' apc.slam_defense = 50 apc.file_update_protection = 2 apc.enable_cli = 0 apc.max_file_size = 1M apc.stat = 1 ; You may want to set this to 0 if you don't update your files often and are willing to restart webserver when you do apc.write_lock = 1 apc.report_autofilter = 0 apc.include_once_override = 1 apc.rfc1867 = 0 ;apc.rfc1867_prefix = 'upload_' ;apc.rfc1867_name = 'APC_UPLOAD_PROGRESS' apc.rfc1867_freq = 0 apc.localcache = 1 apc.localcache.size = (experiment); 512

apc.enabled = 1

The ones that say (experiment) I can't really define for you. Firstly, I don't know your setup - how many servers you have, whether it's shared/vpn/dedicated, how much memory you have, and so on. I put the default values after the comments basically so you can get an idea.

Some of these things you should also try out different settings, besides what I marked "(experiment)". i.e. apc.localcache you may get better performance with it off, or you may get better performance with it on. If you run other scripts on the server it can change your "optimal" configuration as well.

A very frequent topic discussion that I see come up involves resource usage. Questions like "My server isn't responding well" and "What can I do to improve performance" are very specific, but often times there are general guidelines you can follow that can help a lot.

We've decided to open a forum dedicated to optimizing your site, your server, the software on your server, and the like. Use this forum to ask specific questions about how to optimize Apache, why your processlist seems to be showing some active processes that shouldn't be, and so on.

To start the discussion off, note that there are already some articles available here that can help you tune your site. These are general guidelines ... i.e. places to start, not the end-all be-all of server optimization. Each site is different, so feel free to post for specific help with YOUR situation.

• Articles: Getting max from your hardware
• Articles: Server-level optimizations
• Articles: Using UDG for MySQL connections
• Articles: Optimizing the database
• Articles: Invision Board Optimization
• Articles: IPB Settings that make a performance difference
• Articles: Server Information Articles Category
• Client Area KB: Changing sessions table to HEAP
• Documentation: Using IPB's Caching Methods