I don't recall exactly what options I selected in September when I
installed the beta v5.0.4 on my development machine, But, as I started
to develop and then backup data, I noticed that my tables are all using
the storage engine: InnoDB.
Can someone jog my memory and tell me what options cause that to be the
default ?
I'm on the fence, b/w choosing MyISAM and InnoDB
- I don't think I'll be using any transactions or foreign keys, in my
DB/app.
- Re: Performance: With a max of 50 users, I don't think this app will
need stress testing and I don't expect performance to degrade with
either engine.
Since I'm using InnoDB, why is there nothing in the Directory set up
specifically for InnoDB ?
Does that only get used when you start defining foreign keys ?
I'm looking for clarification, advice on a few issues:
Table Locking : the manual's use of the word "thread" made in unclear,
what this does ??
autocommit : ?set to 1 for all non-InnoDB engines ?
Also, whats the best way to convert these tables, if I decide which is
best ?
I notice, that it can be done using, "Alter Table" command.
Suggestions and advice, most welcome. TIA for your replys while I
stew on this. 2 1170
anyone have any comments on InnoDB storage or performance ? TIA in*****@rcn.com wrote in news:1132353304 .978371.81730
@z14g2000cwz.go oglegroups.com: I don't recall exactly what options I selected in September when I installed the beta v5.0.4 on my development machine, But, as I started to develop and then backup data, I noticed that my tables are all using the storage engine: InnoDB.
the 5.0 full release is out... upgrade!
Can someone jog my memory and tell me what options cause that to be the default ?
all tables are by default created as InnoDB instead of MyISAM in MySQL 5.0
unless specified after installation
I'm on the fence, b/w choosing MyISAM and InnoDB
depends what you're doing.... no transactions (are you really sure? never
more than one table is updated at a time?) then go MyISAM
Since I'm using InnoDB, why is there nothing in the Directory set up specifically for InnoDB ?
InnoDB stores data completely differently than MyISAM. It's in the
ibdata.0 file or something. No directories are made.
I'm looking for clarification, advice on a few issues: Table Locking : the manual's use of the word "thread" made in unclear, what this does ??
table locking prevents alterations to a table while an update is going on
(i think). InnoDB tables can do row-level locking, but MyISAM tables can
only lock the entire table.
autocommit : ?set to 1 for all non-InnoDB engines ?
that means that your 'inserts' and 'updates' happen right away, no
transaction type of action
most of these questions can be answered with a MySQL book or at the very
least some googling This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jeff Wagner |
last post by:
I just tried to install Python Win32 (win32all-163.exe) and right after the install, I am getting
the message:
"As this is being installed as a non-admin user, certain COM features will not work correctly.
You will not be able to implement COM objects in Python (but you should be able to use other COM
objects).
Active Scripting is also not supported."
I am on a WinXP box logged on as admin. Why am I getting this message? Is there...
|
by: Pete Shinners |
last post by:
I've been spending the last few night upgrading some 'classic' type
objects to the more modern 'newstyle' types. Unless I am not finding
some important page, this entire process is almost entirely
undocumented. I've found the "Noddy" example, which was a helping start.
But Noddy only gets you halfway there, and where it leaves off there is
no further assistance.
I've been using the builtin Python types source as example, but this
isn't...
|
by: Richard Hanson |
last post by:
Over the last few days, I reinstalled Win2kSP2 to a spare harddrive I
had just swapped into my Fujitsu LifeBook P1120 (long story <wink>).
Subsequently, I DL'ed the newest Python alpha (2.4a2), and when trying
to install it, I immediately got this error:
This installation package cannot be installed by the
Windows Installer service. You must install a
Windows service pack that contains a newer version
of the Windows Installer service.
|
by: Toby Austin |
last post by:
I'm trying to replace <table>s with <div>s as much as possible.
However, I can't figure out how to do the following…
<table>
<tr>
<td valign="top" width="100%">some data that will 'stretch'</td>
<td valign="top" width="300">some data that won't 'stetch'</td>
</tr>
</table>
|
by: Neal |
last post by:
Patrick Griffiths weighs in on the CSS vs table layout debate in his blog
entry "Tables my ass" - http://www.htmldog.com/ptg/archives/000049.php . A
quite good article.
| |
by: Chuck Arney |
last post by:
After installing Office 2003 PRO and attempting to run
SETUP to install the Visual Studio Tools for Office
version 2003, I get the error message "Your computer must
have Microsoft Office Professional Edition 2003 installed
before you can install Microsoft Visual Studio Tools for
the Microsoft Office System.". SETUP terminates after
clicking OK.
I have VS Ent Arch 2003 installed on the machine. In
fact, I previously had the beta...
|
by: Gordon Burditt |
last post by:
What's the easiest way to copy a row from one table to another
(with the same schema), without knowing in advance the number and
types of the columns?
The problem: I have several sets of tables with a primary key of
'account', which contains an email address. If someone changes
their email address, I need to change the 'account' field.
Unfortunately, someone thought it would speed up lookups if instead
of having one table 'settings',...
|
by: mosscliffe |
last post by:
I wanted to install the SQL SERVER 2005 Express Advanced Services,
because I wanted the import / export features of the data manager.
I chose the route of deleting the template files and then installing,
as my version of SQL Server express was part of the install, with
Visual Web Developer 2005 Express Edition and I was not confident of
re-installing just SQL Server Express.
The install progressed quite nicely until I got the following...
|
by: tonytech08 |
last post by:
How valuable is it that class objects behave like built-in types? I
appears that the whole "constructor doesn't return a value because
they are called by the compiler" thing is to enable built-in-like
behavior for objects of class type. That leads to the "necessity" for
the exception machinery so that errors from constructors can be
handled. Is all that complexity worth it just to get built-in-like
behavior from class objects? Maybe a...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |