Hi Peter, see below.
#1 Show Create Table:
CREATE TABLE `phpbb_77topics` (
`topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`icon_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`topic_attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topic_reported` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topic_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`topic_poster` int(10) unsigned NOT NULL DEFAULT '0',
`topic_time` int(11) unsigned NOT NULL DEFAULT '0',
`topic_time_limit` int(11) unsigned NOT NULL DEFAULT '0',
`topic_views` mediumint(8) unsigned NOT NULL DEFAULT '0',
`topic_status` tinyint(3) NOT NULL DEFAULT '0',
`topic_type` tinyint(3) NOT NULL DEFAULT '0',
`topic_first_post_id` int(10) unsigned NOT NULL DEFAULT '0',
`topic_first_poster_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`topic_first_poster_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
`topic_last_post_id` int(10) unsigned NOT NULL DEFAULT '0',
`topic_last_poster_id` int(10) unsigned NOT NULL DEFAULT '0',
`topic_last_poster_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`topic_last_poster_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
`topic_last_post_subject` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`topic_last_post_time` int(11) unsigned NOT NULL DEFAULT '0',
`topic_last_view_time` int(11) unsigned NOT NULL DEFAULT '0',
`topic_moved_id` int(10) unsigned NOT NULL DEFAULT '0',
`topic_bumped` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topic_bumper` mediumint(8) unsigned NOT NULL DEFAULT '0',
`poll_title` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`poll_start` int(11) unsigned NOT NULL DEFAULT '0',
`poll_length` int(11) unsigned NOT NULL DEFAULT '0',
`poll_max_options` tinyint(4) NOT NULL DEFAULT '1',
`poll_last_vote` int(11) unsigned NOT NULL DEFAULT '0',
`poll_vote_change` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topic_visibility` tinyint(3) NOT NULL DEFAULT '0',
`topic_delete_time` int(11) unsigned NOT NULL DEFAULT '0',
`topic_delete_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`topic_delete_user` int(10) unsigned NOT NULL DEFAULT '0',
`topic_posts_approved` mediumint(8) unsigned NOT NULL DEFAULT '0',
`topic_posts_unapproved` mediumint(8) unsigned NOT NULL DEFAULT '0',
`topic_posts_softdeleted` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`topic_id`),
KEY `forum_id` (`forum_id`),
KEY `forum_id_type` (`forum_id`,`topic_type`),
KEY `last_post_time` (`topic_last_post_time`),
KEY `fid_time_moved` (`forum_id`,`topic_last_post_time`,`topic_moved_id`),
KEY `topic_visibility` (`topic_visibility`),
KEY `forum_vis_last` (`forum_id`,`topic_visibility`,`topic_last_post_id`),
KEY `latest_topics` (`forum_id`,`topic_last_post_time`,`topic_last_post_id`,`topic_moved_id`)
) ENGINE=InnoDB AUTO_INCREMENT=168720 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
#2 Show Create Table:
CREATE TABLE `phpbb_77topics_posted` (
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`topic_id` int(10) unsigned NOT NULL DEFAULT '0',
`topic_posted` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`,`topic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
2. OK - can you suggest a size and provide the configuration line for me here? I am running 64G Ram
3. I am looking here:
https://www.artfulsoftware.com/infotree/tip.php?id=1339&r=1
Can you specifically copy/paste what you want me to run? Thanks