You are either not logged in or not registered with our community. Click here to register.
December 11, 2018, 06:32:59 PM

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length

Click here if you are having problems.
Default Wide Screen Beige Lilac Rainbow Black & Blue October Send us your theme!

Wiki Blogs Dicebot

Author Topic: Upgrading the forum: Read and vote  (Read 2857 times)

0 Members and 1 Guest are viewing this topic.

Offline VekseidTopic starter

Re: Upgrading the forum: Read and vote
« Reply #25 on: December 08, 2008, 09:46:04 PM »
What is innobd? Is there any way to explain it to a internet dummy?


Okay, if you are familiar with spreadsheets, you know how you can label columns on a sheet and give them appropriate values for a given row?

You can think of that as a 'table' in a database.

In a relational database, of which SQL is a type of and MySQL is a specific software package that runs it, you allow values to reference others between tables... I am being very simplistic there, sorry.

In a 'true' SQL setup, these values are not allowed to get out of synch (amongst other things). However, this limits performance in some aspects, with certain limited benefits.

MySQL provides a number of 'database engines'. MyISAM, which does not hold to SQL's rules as tightly as it needs, is focused on speed, however there are locking issues - causing lag. Innodb follows SQL more completely, specifically involving row-level locking.

This means that, I have changed the engine so that when two people view topics at the exact same time, the lag will only occur if they are viewing the exact same thread...

...hope that helps : /

Offline Moyra

Re: Upgrading the forum: Read and vote
« Reply #26 on: December 08, 2008, 10:51:43 PM »
I'm with most here. It will only be harder later and no less necessary.

I voted yes.