Re: INNODB Questions and Optimization help

Hello. Have a look here: http://lists.mysql.com/mysql/194596 http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html If you feel uncomfortable with 10G ibdata size, you may want to switch to per-file tablespace: http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html http://dev

RE: INNODB Questions and Optimization help

:~> -Original Message- :~> From: Shaun Adams [mailto:[EMAIL PROTECTED] :~> Sent: Tuesday, February 07, 2006 4:32 PM :~> To: mysql@lists.mysql.com :~> Subject: INNODB Questions and Optimization help :~> :~> Questions: :~> :~> 1. The ibdata1 file size is 10GB. Does that sound right? Shou

Re: INNODB Questions and Optimization help

Shaun Adams wrote: 1. The ibdata1 file size is 10GB. Does that sound right? Should this file be this big? That sounds right. Innodb seems to incur large space overheads. but with the cost of diskspace nowadays... 2. Once a week, I have to perform HUGE insert imports into the database.

Re: innodb questions

On Feb 1, 2006, at 6:35 AM, Grant Giddens wrote: This is what I'm planning on doing, please let me know if you see any problems here. This is on my test server, so losing data isn't the end of the world. This is what I plan on doing in order: 1. Backup the database via mysqldump We've

Re: innodb questions

Ware, Thanks so much for your help. This is what I'm planning on doing, please let me know if you see any problems here. This is on my test server, so losing data isn't the end of the world. This is what I plan on doing in order: 1. Backup the database via mysqldump 2. Purge the master

Re: innodb questions

On Jan 31, 2006, at 9:54 PM, Grant Giddens wrote: Since changing these tables, I've noticed some large files in my / var/lib/mysql directory. This is on my test server and I'm running gentoo linux. The files in this directory look like: /var/lib/mysql/gentoo1-bin.01 (1 Gig in size) /v

Re: InnoDB table creation sequence

- Original Message - From: <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Cc: "mysql" Sent: Monday, January 16, 2006 10:54 AM Subject: Re: InnoDB table creation sequence "Rhino" <[EMAIL PROTECTED]> wrote on 01/16/2006 10:30:33

Re: InnoDB table creation sequence

"Rhino" <[EMAIL PROTECTED]> wrote on 01/16/2006 10:30:33 AM: > Can anyone help me with an InnoDB problem? > > I am trying to create a sequence of related tables using InnoDB but I'm not > having a lot of luck. The script I'm running would work fine in DB2 but the > rules are obviously differe

Re: innodb select

Hello. > Does this have anything to do with the variable: > > | tx_isolation| REPEATABLE-READ| It seems it is. If you use InnoDB only due to speed issues, change the transaction isolating level to READ UNCOMMITED. See: http://dev.mysql.com/doc/refman/5.0/e

Re: InnoDB per-table table spaces

At 23:44 + 1/10/06, Marvin Wright wrote: Hi, My innodb installation is using per-table table spaces for every table on the system. I originally configured 4Gig for the shared table space. However when I do a show table status I see the following. Comment: InnoDB free: 6144 kB So

Re: InnoDb assertion error

- a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, November 10, 2005 12:42 AM Subject: Re: InnoDb assertio

Re: InnoDb assertion error

Hello. I don't see any attempts from InnoDB to recover the data, so it is crashing before the recovering. To save your data, if you're unable to get tables with mysqldump, this might be helpful: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html > MySQL 3.2.3 installed in o

Re: InnoDB maintenance question?

Hello. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html Consider about switching to per-table tablespace: http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html > have an ibdata file that is growing and growing and growing >Are ther

Re: Innodb buffer pool allocation on Window 2000

Hello. It is a bit strange, usually MySQL should be able allocate up to 2G of memory. Check that summary memory usage of MySQL is less than 2G. You may be interested in PAE extention. But to be able to use it you should compile MySQL yourself. See: http://www.microsoft.com/whdc/system/p

Re: Innodb?

"Joe Herman" <[EMAIL PROTECTED]> wrote on 10/14/2005 01:42:41 PM: > Hello, I am just starting with MySQL and PHP, but this discussion about > innodb has rather piqued my interest. Can someone please give a brief > explanation as to what it is. > > Cheers, > > Joe. In a nutshell, InnoDB is one o

Re: Innodb open files issue

Jonathan, http://dev.mysql.com/doc/refman/5.0/en/innodb-start.html " innodb_open_files This option is relevant only if you use multiple tablespaces in InnoDB. It specifies the maximum number of .ibd files that InnoDB can keep open at one time. The minimum value is 10. The default is 300. The fi

RE: innodb locking

sujay -Original Message- From: Tony Leake [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 7:55 PM To: Sujay Koduri Cc: mysql@lists.mysql.com Subject: RE: innodb locking On Wed, 2005-10-05 at 07:12 -0700, Sujay Koduri wrote: > Is this happening every time you try this, or it

Re: innodb locking

Tony Leake wrote: Hi, I have a query: UPDATE dbseXyzOrders.tblOrder SET intPoUid = 98 WHERE intOrderUid = 10798 intOrderUid is the primary key There are 25 columns in the table and a further 8 of these have indexes on them. The table is innodb I have just tried to run the above query 3

Re: innodb locking

I have ever meet this problem, however i never found best solutions. Make sure that there're no other session that update the data with AUTOCOMMIT=0 If there's another session with autocommi=0 and update the data, kill it first so your session will not timeout lock use SHOW INNODB STATUS to s

RE: innodb locking

On Wed, 2005-10-05 at 07:12 -0700, Sujay Koduri wrote: > Is this happening every time you try this, or it happened first time? It's not every time but this is not the first. Mostly the query is ok, but I would like to find out why it's happening. > Also can you please tell what isolation level ar

RE: InnoDB error "unable to create temporary file"

Hi Joerg et all, [snip] > You said this is Solaris. > > AFAIK, Solaris uses the same disk area for "/tmp" and paging, so the > available space for files in "/tmp" may vary even without files being > manipulated. > > I propose you set TMPDIR to point to some other disk area. We're on Solaris,

RE: innodb locking

Is this happening every time you try this, or it happened first time? Yes you right that INNODB uses row level locks, and the only reason for that error should be that someone else is trying to update the same row. As we can see from the o/p of the show procee list, someone else is also trying to

Re: InnoDB error "unable to create temporary file"

Hi Jörg, On Thursday 29 September 2005 12:09, you wrote: > Hi Martijn, all! > > Martijn van den Burg wrote (reordered) > > > On Wednesday 28 September 2005 20:10, Gleb Paharenko wrote: > >>Martijn van den Burg wrote: > >>>Hi list, > >>> > >>>After the most recent reboot (which we used to increase

Re: InnoDB error "unable to create temporary file"

Hi Martijn, all! Martijn van den Burg wrote (reordered) On Wednesday 28 September 2005 20:10, Gleb Paharenko wrote: Martijn van den Burg wrote: Hi list, After the most recent reboot (which we used to increase the ulimit/open_files_limit on our Solaris 8 machine running 4.1.10-log), the follo

Re: InnoDB error "unable to create temporary file"

Hi, Thanks for your reply. TMPDIR is not set explicitly, and the first 'fallback' directory in that case is '/tmp', which is accessible and has enough diskspace. At least, when I checked this morning. The error occurred in the night, maybe there were other processes that filled the directory

Re: InnoDB error "unable to create temporary file"

Hello. Maybe some directory doesn't exist in the path where MySQL stores temporary files. See: http://dev.mysql.com/doc/mysql/en/temporary-files.html Martijn van den Burg wrote: > Hi list, > > After the most recent reboot (which we used to increase the > ulimit/open_files_limit

Re: Innodb dealing with blobs in 4.1: Error 139 from storage engine

sorry for this monologue-thread, but... Nico Sabbi wrote: [snip] If it can help, seems that the largest value I can store in a blob field without triggering that error is 192 characters long. I just read the restrictions on Innodb tables, and I'm not convinced that what is going on is expe

Re: Innodb dealing with blobs in 4.1: Error 139 from storage engine

Nico Sabbi wrote: Hi, with mysql 4.1[234], importing a dump of Innodb tables containing at least a blob field I invariably get_ ERROR 1030 (HY000) at line 21027: Got error 139 from storage engine I read in the bugzilla that this problem is due to low memory conditions, but surely it's not m

Re: innodb and myisam and db optimising

ow how to reach mysql logs? Can you explain me how can > I examine detailed mysql logs? > 2. Can you basicly define transaction and its advantages and disadvantages? > > Thank you > > > - Original Message - > From: "Pooly" <[EMAIL PROTECTED]> >

Re: innodb and myisam and db optimising

2005/9/16, OKAN ARI <[EMAIL PROTECTED]>: > I have a web site that have 100unique users online at the same time. I will > optimize DB structure. > > 1. Is there anysource about mysql optimization and performance tricks? you might want to look here : http://dev.mysql.com/doc/mysql/en/query-speed.h

Re: innoDB and autoincrement

At 15:17 +0530 9/12/05, [EMAIL PROTECTED] wrote: This is from the docs . "The auto-increment value of a deleted record will only not be reused until the server is restarted, then it will be reused. In other words, if you insert 10 rows into an InnoDB table and then delete them the AUTO_INC

Re: innoDB and autoincrement

Hello. > Now if i have records 1 to 10 and i delete some records in between , say, 5, > 7, 8. Now when i restart my server, will these values of 5, 7 and 8 be > reused?? No, they won't be reused until your column has values more than 5,7 or 8. The AUTO_INCREMENT counter initialized to

Re: innoDB and autoincrement

[EMAIL PROTECTED] wrote: This is from the docs . "The auto-increment value of a deleted record will only not be reused until the server is restarted, then it will be reused. In other words, if you insert 10 rows into an InnoDB table and then delete them the AUTO_INCREMENT value will stay

Re: innodb thread concurrency size [mysql performance tuning]

Clyde Lewis wrote: Hey guys, I'm looking for any best practices or a formula that is commonly used in setting the value for thread concurrency in the configuration file. I have 24 instances running on a sun 2900 server with 32GB or ram. Here is a sample of my configuration file. The best pr

Re: INNODB memory allocation error during startup

We see that error when we go above the memory limits of a 32 bit operating system. When we run a 64 bit binary on our 64 bit hardware we can allocate more memory and it fires up fine. I'm a Mac guy so your string of letters and numbers describing your hardware and MySQL version don't mean m

Re: InnoDB Record Lock Command

something along the lines of: mysql> select * from where = lock in share mode On Sep 5, 2005, at 4:01 PM, Rich wrote: Hi there. I am looking for the syntax to lock individual records in an InnoDB table. I can't seem to find anything outside of locking full tables. Rich Allen A kidn

Re: InnoDB: Error: tablespace size stored in header is 640000 pages, but the sum of data file sizes is 1056000 pages

Reply by me. How stupid i'm :( I've finished this warning error problem by adding 4 files --> 3 file each 3 Gbyte and 1 file 500Mbyte Thx mr. heiiki :D Sorry Ady Wicaksono wrote: |Dear All, As subject, Actually i've been ever meet this case when i see : InnoDB: Error: tablespace size

Re: InnoDB, FreeBSD and Memory: Cannot Allocate memory - raising limits

The limit you are running into is the maxdsiz or max data size for a process. It is defaulting to 512MB. In FreeBSD 5.x you don't have to recompile your kernel to set a different maxdsiz. See /boot/defaults/loader.conf. Putting kern.maxdsiz="1073741824" in /boot/loader.conf should work. T

Re: InnoDB, FreeBSD and Memory: Cannot Allocate memory - raising limits

On Tue, 23 Aug 2005, Jeremiah Gowdy wrote: The limit you are running into is the maxdsiz or max data size for a process. It is defaulting to 512MB. In FreeBSD 5.x you don't have to recompile your kernel to set a different maxdsiz. See /boot/defaults/loader.conf. Putting kern.maxdsiz="107374

Re: InnoDB, FreeBSD and Memory: Cannot Allocate memory - raising limits

The limit you are running into is the maxdsiz or max data size for a process. It is defaulting to 512MB. In FreeBSD 5.x you don't have to recompile your kernel to set a different maxdsiz. See /boot/defaults/loader.conf. Putting kern.maxdsiz="1073741824" in /boot/loader.conf should work. T

Re: InnoDB migration between servers

Hello. If you have a reproducible test case, you should report a bug. Andreas Unterkircher <[EMAIL PROTECTED]> wrote: > I can now isolate the problems with the appearing "lock" of some queries. > > I updated MySQL from 4.1 to 5beta > (mysql-standard-5.0.10-beta-linux-x86_64-glibc2

Re: InnoDB migration between servers

I can now isolate the problems with the appearing "lock" of some queries. I updated MySQL from 4.1 to 5beta (mysql-standard-5.0.10-beta-linux-x86_64-glibc23) to test if the problem still appears in the newer version. I made a full sqldump on the old server and import it successfully on the new

Re: InnoDB migration between servers

> > When I strace the mysqld process it doesn't do anything, it's waiting > > Do you use the official binaries? There're additional InnoDB monitors > mentioned at: > http://dev.mysql.com/doc/mysql/en/innodb-monitor.html > > which could provide more information. My first try was with the incl

Re: InnoDB migration between servers

Hello. > When I strace the mysqld process it doesn't do anything, it's waiting Do you use the official binaries? There're additional InnoDB monitors mentioned at: http://dev.mysql.com/doc/mysql/en/innodb-monitor.html which could provide more information. > When I strace the mysq

Re: InnoDB Netapp Snapshot

Hi Dobromir, Thanks for the feedback. So you have successfully restored from a Snapshot created in this way? Jeff On Wed, 2005-07-27 at 12:30 +0300, Dobromir Velev wrote: > Hi, -- Jeff Richards Consulting Architect Openwave Systems Asia Pacific +61 415 638757 -- MySQL General Mailing List Fo

Re: InnoDB Netapp Snapshot

Hi, This procedure works for me and until now I haven't had any problems with it. You should b aware that if your database is under heavy load you might experience problems with transactions timing out due to the lock. HTH On Wednesday 27 July 2005 09:14, Jeff Richards wrote: > Hi, > > I need a

Re: Innodb Questions

On Jul 24, 2005, at 9:13 AM, Michael Stassen wrote: Dan Tappin wrote (quotes from several posts, my thoughts interspersed): > I am running into repeatable table corruption with MySQL 4.x on Mac OS X > 10.x. Many people, myself included, are running mysql 4.x on OS X without reporting th

Re: Innodb Questions

Dan Tappin wrote (quotes from several posts, my thoughts interspersed): > I am running into repeatable table corruption with MySQL 4.x on Mac OS X > 10.x. Many people, myself included, are running mysql 4.x on OS X without reporting this sort of problem, so the trick is to find out what your in

Re: Innodb Questions (was: Mac OS X Table Corruption)

So I've been poking around my system and I found /usr/lib/mysql/ /usr/share/mysql/ The mod dates on these are really old. Can I delete these safely? I'm guessing the are from the Apple install. These files seem to be in the /usr/local/mysql/ path also. Hmmm... I looked at my old Mac OS

Re: Innodb Questions (was: Mac OS X Table Corruption)

On Jul 23, 2005, at 12:49 PM, Ware Adams wrote: Then I don't know what to say about the MyISAM error, though I'd watch InnoDB pretty carefully as I think MyISAM is pretty robust on OS X too. We did also see these when a disk is failing, but I assume you've run disk utility. I guess it co

Re: Innodb Questions (was: Mac OS X Table Corruption)

On Jul 23, 2005, at 1:58 PM, Dan Tappin wrote: On Jul 23, 2005, at 10:14 AM, Ware Adams wrote: Has your mysql crashed or have your restarted the machine without first shutting down mysql manually? We only saw this error when mysql was not shut down normally. You can look in your .err fi

Re: Innodb Questions (was: Mac OS X Table Corruption)

On Jul 23, 2005, at 10:14 AM, Ware Adams wrote: Has your mysql crashed or have your restarted the machine without first shutting down mysql manually? We only saw this error when mysql was not shut down normally. You can look in your .err file which should be in your data directory. Ever

Re: Innodb Questions (was: Mac OS X Table Corruption)

On Jul 23, 2005, at 11:56 AM, Dan Tappin wrote: I am all most ready to give up on MySQL at this point. I'm still getting regular table corruption on multiple installs of OS X. I went as far as reporting it as a bug: http://bugs.mysql.com/bug.php?id=12066 They seem to want more info but my

Re: innodb performance issues

On Fri, 2005-07-15 at 13:28 -0700, David Griffiths wrote: > David, Thanks for your suggestions, i'll give them a try. > There are other tuning choices (including the thread-pool-cache). The > best resource is the page on innodb performance tuning, and it can be > found here: > > http://dev

Re: innodb performance issues

Tony, Your my.cnf file is set up for MyISAM, not InnoDB. MySQL allows you to allocate memory and resources to any and all storage engines. Yours is set up to give lots of resources to MyISAM, and none to InnoDB. Reducing MyISAM key_buffer = 384M - this is way too much - I'd set to to 2-16 meg

Re: innodb performance issues

Hi David, On Fri, 2005-07-15 at 10:25 -0700, David Griffiths wrote: > Tony, > > " - not sure what version you are using 4.1.11. Server is a duel xeon machine with 4gb or ram running mysql and apache webserver and not much else. You should have used > my-innodb-heavy-4G.cnf as the starting p

Re: innodb performance issues

Tony, You said that you copied the my.cnf file from "huge.cnf" - not sure what version you are using (I missed your original post), but the my-huge.cnf in mysql 4.0.24 is for MyISAM. You should have used my-innodb-heavy-4G.cnf as the starting point for an InnoDB system. The my-huge.cnf alloc

Re: Innodb crash on failed read disk

Ady Wicaksono <[EMAIL PROTECTED]> writes: > Dear All > > I use RedHat 9 with 2,5 Gbyte RAM, Intel(R) Xeon(TM) CPU 2.80GHz > (Hyperthread), > filesystem ext3 standar linux journaling filesystem. > > Today my DB is crash :(, here is the log. Could it be that our stacks and your heaps might have m

Re: innodb crashes during heavy usage with exceeded memory error

Kasthuri Ilankamban <[EMAIL PROTECTED]> writes: > Hi, We are running mysql version 4.1.7 with innodb on i686 running > 2.4.26 linux kernal with 8G memory. Mysql crashes consistently during > heavy usage with fatal innodb error. We are running a high volume front > end application which inserts

Re: innodb crashes during heavy usage with exceeded memory error

Kasthuri, Maybe it's time to re-think your application architecture? A 200-meg BLOB is quite large for a highly-concurrent system, considering that MySQL will have to read/save it in its entirety _and_ allocate network buffers for it, so essentially you're allocating _400_ megs or so _per_ cl

Re: innodb crashes during heavy usage with exceeded memory error

Matthew has already responded. But I will also add, you must rethink how your application is coded. I can not possibly imagine a situation where a user session needs 200meg insert. No matter what database you use you will have a terrible time trying to scale this application. If you give more detai

Re: innodb crashes during heavy usage with exceeded memory error

A big part of your problem seems to be that 32bit OS's can not allocate more than 2G memory to a single process, and with each client connection needing so much buffer space, you quickly exceed that limit. Short of moving to a 64bit OS, the only solution I have come across that allows mysql to

Re: innodb crashes during heavy usage with exceeded memory error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kasthuri Ilankamban wrote: [snip] > > The table that's it's complaining about is a session table which > stores web session information. Basically the data in that table is a > throw away data and gets deleted when the user logs out. The session

Re: innodb crashes during heavy usage with exceeded memory error

Thank a lot for your quick reply. SInce we are not using myisam tables ( except for the system tables), I deallocated memory from myisam and allocated to innodb. When I allocated close to 1.7G to innodb buffer size, mysql used to crash more often. So I decreased innodb_buffer_size to 1G. Wh

Re: innodb crashes during heavy usage with exceeded memory error

You definitely should increase memory sizes in your my.cnf file. The settings that you have are for a very smal setup. You also need to allocate more space for innodb table extender. So instead of 10m have something like 50m or try and see which settings is better. The reason is under heavy load if

(More Data) Re: Innodb crash on failed read disk

Seems that i have a bad block :( # badblocks -sv /dev/sda3 Checking for bad blocks in read-only mode From block 0 to 10241437 Checking for bad blocks (read-only test): 102414360/ 10241437 done Pass completed, 1 bad blocks found. Ady Wicaksono wrote: Dear All I use RedHat 9 with 2,5 Gbyte RA

Re: Innodb Performance Measurement

Hello. A lot of statistics you could get from 'SHOW INNODB STATUS'. For example 'FILE I/O', 'INSERT BUFFER AND ADAPTIVE HASH INDEX', 'BUFFER POOL AND MEMORY' could be helpful. See: http://dev.mysql.com/doc/mysql/en/innodb-monitor.html Manoj <[EMAIL PROTECTED]> wrote: > Greetin

Re: innoDB and referential action

Hello. On my mysql-5.0.6 instance foreign key constraint from your example works. What output does the following statement produce: show variables like 'have_innodb'; "Jan Bartholdy" <[EMAIL PROTECTED]> wrote: > Dear All, I have two tables entity1 and entity2; the second one should >

Re: Innodb optimzation

Hi stephano, Just read the last comment at this link http://dev.mysql.com/doc/mysql/en/optimize-table.html and you will have positive answers to your questions. Mathias Selon [EMAIL PROTECTED]: > Hi all, > > I have an Innodb database (MySQL 4.0.21 on Linux). The db is made of 11 > tables. 10 of

Re: InnoDB to MyISAM

Nevertheless, foreign key constraints belong in the database, not in your application... If you have foreign keys (your wording), you need foreign key constraints. Period. Plain and simple. No discussion :-) How about a log database? We log every phone call to a calls table which currently has

Re: InnoDB to MyISAM

Peter Normann wrote: Martijn Tonies wrote: Nevertheless, foreign key constraints belong in the database, not in your application... If you have foreign keys (your wording), you need foreign key constraints. Period. Plain and simple. No discussion :-) Foreig

Re: InnoDB to MyISAM

> > Nevertheless, foreign key constraints belong in the database, not in > > your application... If you have foreign keys (your wording), you need > > foreign key constraints. Period. Plain and simple. No discussion :-) > > Foreign keys are foreign keys. Constraints are constraints. Foreign key >

RE: InnoDB to MyISAM

Martijn Tonies wrote: > Nevertheless, foreign key constraints belong in the database, not in > your application... If you have foreign keys (your wording), you need > foreign key constraints. Period. Plain and simple. No discussion :-) Foreign keys are foreign keys. Con

Re: InnoDB to MyISAM

> >> I think you're confusing referential constraints with foreign keys. > > > > In my book, referential constraints and foreign key constraints (the full > > name) > > are the same. > > Yes, referential constraints and foreign key constraints are the same thing. > Notice the word constraints. >

Re: InnoDB to MyISAM

I think you're confusing referential constraints with foreign keys. In my book, referential constraints and foreign key constraints (the full name) are the same. Yes, referential constraints and foreign key constraints are the same thing. Notice the word constraints. Let me say this again:

Re: InnoDB to MyISAM

Hi, If you're loocking for consurrent inserts/deletes, use innodb (row level locking). This will be better than myisam. I'm looking for concurrent inserts / selects, reading and writing. The key is to get the reads and blocking writes (writes that need the insert ID, which can't be done DELAY

Re: InnoDB to MyISAM

> >> >>key relationships? > >> > > >> > MyISAM can't FK's. > >> > >> Yes it can, they're just not enforced. > > > > LOL - that's just like saying that MyISAM supports transactions > > if you only do transactions that are a single statement... > > > > In other words: useles. > > Somehow I use these

Re: InnoDB to MyISAM

Hi, If you're loocking for consurrent inserts/deletes, use innodb (row level locking). This will be better than myisam. The text column can be created in aother table and stay referenced via a FK. This will ceratinly be faster since insert or delete on myisam implies a LOCK table implicit mecanis

Re: InnoDB to MyISAM

>>key relationships? > > MyISAM can't FK's. Yes it can, they're just not enforced. LOL - that's just like saying that MyISAM supports transactions if you only do transactions that are a single statement... In other words: useles. Somehow I use these "useles" foreign keys to create relational

Re: InnoDB to MyISAM

> > http://dev.mysql.com/doc/mysql/en/converting-tables-to-innodb.html > > He's converting InnoDB to MyISAM. > > I would recommend something like this: > > CREATE TABLE newtable LIKE oldtable; > > ALTER TABLE newtable ENGINE=MyISAM; > > ALTER TABLE newtable DISABLE KEYS; > > INSERT INTO newtable S

Re: InnoDB to MyISAM

- Original Message - From: "Rafal Kedziorski" <[EMAIL PROTECTED]> To: "Scott Purcell" <[EMAIL PROTECTED]>; Sent: Wednesday, May 25, 2005 6:06 AM Subject: Re: InnoDB to MyISAM http://dev.mysql.com/doc/mysql/en/converting-tables-to-innodb.html He&#

Re: InnoDB to MyISAM

hi, At 14:54 25.05.2005, Scott Purcell wrote: Hello, I posted last night but did not receive an answer. I am trying to create a fulltext index, but my table was created as an InnoDB type. There is quite a bit of data there (1000+ records) and I need to change to a MyISAM table for the indexi

Re: InnoDB to MyISAM

Scott Purcell wrote: Hello, I posted last night but did not receive an answer. I am trying to create a fulltext index, but my table was created as an InnoDB type. There is quite a bit of data there (1000+ records) and I need to change to a MyISAM table for the indexing for fulltext search. H

RE: innodb buffer pool size question

thanks -Original Message- From: Partha Dutta [mailto:[EMAIL PROTECTED] Sent: Monday, May 16, 2005 11:30 AM To: Sergei Skarupo; 'Mysql List (E-mail)' Subject: RE: innodb buffer pool size question The buffer pool size value is in 16K pages (from SHOW INNODB STATUS output) -- Pa

RE: innodb buffer pool size question

The buffer pool size value is in 16K pages (from SHOW INNODB STATUS output) -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification > -Original Message- > From: Sergei Skarupo [mailto:[EMAIL PROTECTED] > Sent: Monday,

Re: InnoDB memory usage clarification

Mayuran, It depends on a bunch of things. What else is running on this server? Does the distro you use have the ability to take advantage of all 16 gig (ie if you have apache running, will it be stuck in the same 4 gig as MySQL, or can it use the memory above the 4 gig limit). How big is your d

Re: InnoDB Writes blocking Reads

is be a > performance bug in the query cache? > > What is your my.cnf like? How big is your table cache? > > Best regards, > > Heikki Tuuri > Innobase Oy > Foreign keys, transactions, and row level locking for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB

Re: InnoDB Writes blocking Reads

/network/ - Original Message - From: ""Andy McCurdy"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, April 22, 2005 2:02 AM Subject: Re: InnoDB Writes blocking Reads I forgot to mention: we're running mysql version 4.0.23-standard-log --

Re: InnoDB Tablespace per Schema?

From: "Andreas Schildbach" > Is it possible to configure MySQL so that it uses one InnoDB tablespace > file per database schema, instead of mixing all data into the shared > tablespace? No, but you can use a file per table: http://dev.mysql.com/doc/mysql/en/multiple-tablespaces.html It still uses

Re: InnoDB: How do I know how much free space there is left on a raw device?

At 17:48 +0200 4/22/05, Jarle Aase wrote: Hi list, Just a simple question. How do I know how much free space there is left on a device assigned to InnoDB? Depends on what you mean by "free space." Do you mean not space on the device not assigned to the InnoDB tablespace file, or space free within

Re: InnoDB Writes blocking Reads

Andy, Can you send me the table layout and the script ? I'd like to try it here on one my test systems running 4.0.23. walt Andy McCurdy wrote: I haven't seen any other replies as of yet. After looking closer at the innodb status dump, the last known deadlock occured several days ago... so I don

Re: InnoDB Writes blocking Reads

Andy McCurdy wrote: I forgot to mention: we're running mysql version 4.0.23-standard-log -- Official MySQL-standard binary. Here's the innodb status output during a problematic period. = 050421 15:29:46 INNODB MONITOR OUTPUT

Re: innodb, optimizer and outer join

Boyd, You can tell Hibernate not to use outer-joins by setting hibernate.use_outer_join to false in the hibernate configuration properties file. It's an always-never proposition. Of course, you can code your own queries using the Hibernate Query object to write your own when you know you do ne

Re: InnoDB Writes blocking Reads

I forgot to mention: we're running mysql version 4.0.23-standard-log -- Official MySQL-standard binary. Here's the innodb status output during a problematic period. = 050421 15:29:46 INNODB MONITOR OUTPUT = Per second averag

Re: InnoDB Writes blocking Reads

Andy McCurdy wrote: I've been seeing some weirdness w/ MySQL and InnoDB over the past few days. I have a database that's entirely using InnoDB. The database is roughly 4.5G (one datafile) and contains a little over 50 tables. The web applications that hit this database do about 85-90% reads an

Re: InnoDB Performance

From: "David Lloyd" > journalling file system. It's not always that clear cut. I've just > switched a number of big customer databases to InnoDB and noone's > noticed any difference - if anything it's going faster. For small tables (<50,000 records) MyISAM is usually a lot faster. However, MyISAM

Re: InnoDB Performance

Eko and all, > >The MyIsam storage engine is a non transactional engine and InnoDb is > >a transactional engine. That is the main difference. So I think the > >MyIsam engine should be faster. However, some file systems that have journals are faster than non journalling file system. It's not alw

Re: InnoDB Performance

see this link http://dev.mysql.com/doc/mysql/en/ansi-diff-transactions.html Reto Eko Budiharto wrote: The MyIsam storage engine is a non transactional engine and InnoDb is a transactional engine. That is the main difference. So I think the MyIsam engine should be faster. what is transactional mea

Re: InnoDB Performance

>The MyIsam storage engine is a non transactional engine and InnoDb is a >transactional engine. That is the main difference. So I think the MyIsam >engine should be faster. what is transactional mean? - Do you Yahoo!? Yahoo! Small Business - T

Re: InnoDB lchange log file size

Hello. See: http://dev.mysql.com/doc/mysql/en/adding-and-removing.html >Hi, > > our logfile size is not set like: > > >Set the log file size to about 25% of the buffer pool size > > Could we remove the actual log file and set the new or is this > important? > > Without remo

<    1   2   3   4   5   6   7   8   9   10   >