Why SMF doesn't delete a Instant Messages from table?

[el-brujo]

Hi,

I would like to delete the instant messages (IM) that are deleted by sender, because they are stored in the database.

Table --> prefix_instant_messages (I have 29296 rows) (more than 10MB)
Table --> prefix_im_recipients  (I have 30356 rows)

I can use a SQL Query something that "delete from instant_messages where deletedBySender = 0;" or "delete from im_recipients where deleted= 1;" ¿? or something like that...

¿Is there any way to to delete log_topics older?

Feature Request:

Delete messages with no answers (no replys) and older than xxx days.
Delete messages with xx < reads

I have a problem with  Total Topics: 58795 and Total Posts: 299064 (about 400MB of SMF Forum xDD)

But i dont want to delete "all" older posts, only instant messages, for example.

More things:

"More Stats" (?action=stats) consumes too many cpu usage, .

How to delete "Forum History (using forum time offset)"?

I have forum history from August 2002.....

Any ideas for deleting any logs or messages old and non-important? (to improve cpu loads)

Maybe using InnoDB instead of  MyISAM?

Thank you in advance.

[[Unknown]]

It deletes them when all recipients and the sender have deleted them.  It only stores the message text once.

How many posts do you have?

-[Unknown]

[el-brujo]

Total Posts: 299064

Total SMF size: about 400MB

I need to "optimize", but i don't like the idea of deleting old but useful posts.

Any suggestions will be appreciated.

Sorry for muy bad english.

Big forum....
http://www.simplemachines.org/community/index.php?topic=30542.msg275552#msg275552

[[Unknown]]

Total Posts: 299064

At this point, you're going to want to use InnoDB for at least a few tables.  Are you using a PHP Accelerator?

-[Unknown]

[el-brujo]

Are you using PHP Accelerator?

No.

Only i'm using a big query_cache_size, query_cache_limit and key_buffer on MySQL 4.0.x

I must use PHP Accelerator or InnoBD, or both?

Thank you.

[[Unknown]]

I strongly suggest looking into eAccelerator or similar, and using InnoDB for a few tables (for which, search for 'InnoDB".)

Accelerators can, for many people, halve the load on the server or thereabouts.

-[Unknown]

[el-brujo]

Hi again [Unknown],


Which tables are better using InnoBD?

Code Select Expand

ALTER TABLE smf_log_search
TYPE=InnoDB;
ALTER TABLE smf_log_online
TYPE=InnoDB;
ALTER TABLE smf_log_topics
TYPE=InnoDB;
ALTER TABLE smf_log_floodcontrol
TYPE=InnoDB;


Is this right?

Thank you so much.

[Ben_S]

[Unknown] has posted this list before so I'll repost it here.

ALTER TABLE smf_attachments
TYPE=InnoDB;
ALTER TABLE smf_collapsed_categories
TYPE=InnoDB;
ALTER TABLE smf_log_actions
TYPE=InnoDB;
ALTER TABLE smf_log_boards
TYPE=InnoDB;
ALTER TABLE smf_log_errors
TYPE=InnoDB;
ALTER TABLE smf_log_karma
TYPE=InnoDB;
ALTER TABLE smf_log_mark_read
TYPE=InnoDB;
ALTER TABLE smf_log_online
TYPE=InnoDB;
ALTER TABLE smf_log_search
TYPE=InnoDB;
ALTER TABLE smf_log_topics
TYPE=InnoDB;
ALTER TABLE smf_members
TYPE=InnoDB;
ALTER TABLE smf_pm_recipients
TYPE=InnoDB;
ALTER TABLE smf_sessions
TYPE=InnoDB;
ALTER TABLE smf_settings
TYPE=InnoDB;
ALTER TABLE smf_topics
TYPE=InnoDB;

[el-brujo]

I've successfully installed eAccelerator.

Now, wait for the load averages... 

Maybe tomorrow convert some tables to InnoDB.

Thank you for all.