Welcome, Guest. Please Login or Register.
May 08, 2025, 04:16:16 PM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  Development  |  Mod Ideas and Creation  |  Innodb « previous next »
Pages: [1] Reply Ignore Print
Author Topic: Innodb  (Read 297 times)
groundup
Disciple of Joe, Head Cleric
Mod Team
YaBB God
*****
Posts: 2983


Error 309: Please notify the administrator of this

WWW
Innodb
« on: November 16, 2002, 07:38:50 PM »		 Reply with quote
I hear innodb is better for larger sites. Maybe we should make a mod to change this (all you do is just change the table type in mysql from what I understand).

www.innodb.com

PS: to purple raine & all high traffic sites: I think this might help ya out.

edit: forgot this http://www.mysql.com/doc/en/SEC446.html
« Last Edit: November 16, 2002, 07:40:50 PM by groundup » Logged
http://www.fastfinancialfreedom.org - financial freedom is a myth
http://www.fastfinancialfreedom.org - financial freedom is a myth
http://www.fastfinancialfreedom.org - financial freedom is a myth
fastfinancialfreedom.org
David
Destroyer Dave
Global Moderator
YaBB God
*****
Posts: 5761


I'm not a llama!

WWW
Re:Innodb
« Reply #1 on: November 16, 2002, 10:39:22 PM »		 Reply with quote
If you do this don't forget that you should change the my.cnf file to get better performance.
Logged

Forum-Forum.com, A Forum For Forum Owners and Enthusiasts!
Eloya
Full Member
***
Posts: 127


Magistrat

nschunter@eloya.net WWW
Re:Innodb
« Reply #2 on: November 19, 2002, 08:55:28 AM »		 Reply with quote
Hmmm... what must I change in this file to get better performance?

Greets,

Nico
Logged
"Der Unterschied zwischen Magie und Alltag ist die Betrachtungsweise!"
http://www.travar.de
groundup
Disciple of Joe, Head Cleric
Mod Team
YaBB God
*****
Posts: 2983


Error 309: Please notify the administrator of this

WWW
Re:Innodb
« Reply #3 on: November 19, 2002, 07:12:54 PM »		 Reply with quote
Pretty much all you have to do to get innodb to work is get mysql running it, change the table types to innodb, and remove the indices that are non-numerical.
Logged
http://www.fastfinancialfreedom.org - financial freedom is a myth
http://www.fastfinancialfreedom.org - financial freedom is a myth
http://www.fastfinancialfreedom.org - financial freedom is a myth
fastfinancialfreedom.org
Eloya
Full Member
***
Posts: 127


Magistrat

nschunter@eloya.net WWW
Re:Innodb
« Reply #4 on: November 20, 2002, 07:46:04 AM »		 Reply with quote
Hmmm... why is it necessary to remove all non_numerical indices? Just wondering...

Greetings,

Nico
Logged
"Der Unterschied zwischen Magie und Alltag ist die Betrachtungsweise!"
http://www.travar.de
groundup
Disciple of Joe, Head Cleric
Mod Team
YaBB God
*****
Posts: 2983


Error 309: Please notify the administrator of this

WWW
Re:Innodb
« Reply #5 on: November 26, 2002, 05:38:52 AM »		 Reply with quote
innodb requires it.
Logged
http://www.fastfinancialfreedom.org - financial freedom is a myth
http://www.fastfinancialfreedom.org - financial freedom is a myth
http://www.fastfinancialfreedom.org - financial freedom is a myth
fastfinancialfreedom.org
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  Development  |  Mod Ideas and Creation  |  Innodb « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
 Valid XHTML 1.0! Valid CSS

Page created in 0.160 seconds with 20 queries.