Re: best practice: mysql_multi, VMs w/single instance per or doesn't matter?
Other people have answered with pros and cons of virtualisation, but I would rather ask another question: why do you feel it necessary to split up the database? If it's only used for QC, it's probably not in intensive use. Why would you go through the bother of splitting it up? You're staying on the same server, apparently, so you'll have to decide which instance gets what part of cpu, memory and other resources, you'll have to provide separate backup for all instances, et cetera; while leaving things as they are is zero effort. What is the problem with the current setup that will be resolved by splitting? -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how to RE-add innoDB storage?
I have recently noticed I can not access a PHP application's data files, and the errors I am getting seem to show that a recent update of the distro (mandriva) no longer supports innodb, and this may be a reason (if this is not some sort of catchall error). I would like to know how to add innodb plugin back into my mysql, or to convert the data to a usable format. I would be pleased with a pointer to the correct rtfd location. I guess wordwrap is going to mess this up; mysql show engines ; ++-+---+--+--++ | Engine | Support | Comment | Transactions | XA | Savepoints | ++-+---+--+--++ | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | CSV | YES | CSV storage engine| NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance| NO | NO | NO | ++-+---+--+--++ show plugins; ++++-+-+ | Name | Status | Type | Library | License | ++++-+-+ | binlog | ACTIVE | STORAGE ENGINE | NULL| GPL| | partition | ACTIVE | STORAGE ENGINE | NULL| GPL | | CSV| ACTIVE | STORAGE ENGINE | NULL| GPL| | MEMORY | ACTIVE | STORAGE ENGINE|NULL |GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL| GPL| | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL| GPL | check table vtiger_vendor; ++---+--+---+ | Table | Op| Msg_type | Msg_text | ++---+--+---+ | vtigercrm520.vtiger_vendor | check | Error| Unknown table engine 'InnoDB' | | vtigercrm520.vtiger_vendor | check | error| Corrupt | ++---+--+---+
Re: Isolation level per transaction?
On Fri, Mar 4, 2011 at 1:32 AM, Angela liu yyll2...@yahoo.com wrote: Can Isolation levels be set per transaction? I know isolation levels can be set per session or globally, but not sure at transaction level. Given that you can only have one transaction at a time in a session, there is no real difference between session-level and transaction-level. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: how to RE-add innoDB storage?
Hi ed, all! ed wrote: I have recently noticed I can not access a PHP application's data files, and the errors I am getting seem to show that a recent update of the distro (mandriva) no longer supports innodb, and this may be a reason Which version were you using before, and which one are you using now? (if this is not some sort of catchall error). I would like to know how to add innodb plugin back into my mysql, or to convert the data to a usable format. I would be pleased with a pointer to the correct rtfd location. From your output, I'd say they removed or unconfigured some parts in the source before creating binaries. (If your previous version was taken from the same source, they did an incompatible change IMNSHO, and I hope they did give a thorough warning. If not, you should raise a complaint.) I guess wordwrap is going to mess this up; mysql show engines ; ++-+---+--+--++ | Engine | Support | Comment | Transactions | XA | Savepoints | ++-+---+--+--++ | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | CSV | YES | CSV storage engine| NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance| NO | NO | NO | ++-+---+--+--++ show plugins; ++++-+-+ | Name | Status | Type | Library | License | ++++-+-+ | binlog | ACTIVE | STORAGE ENGINE | NULL| GPL| | partition | ACTIVE | STORAGE ENGINE | NULL| GPL | | CSV| ACTIVE | STORAGE ENGINE | NULL| GPL| | MEMORY | ACTIVE | STORAGE ENGINE|NULL |GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL| GPL| | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL| GPL | This is what show engines and show plugins report in my test build of post-5.1.57 (complete sources): = ENGINES = Engine Support Comment TransactionsXA Savepoints ndbcluster NO Clustered, fault-tolerant tablesNULL NULLNULL MRG_MYISAM YES Collection of identical MyISAM tables NO NO NO BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO CSV YES CSV storage engine NO NO NO MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO FEDERATED NO Federated MySQL storage engine NULLNULL NULL ARCHIVE YES Archive storage engine NO NO NO InnoDB YES Supports transactions, row-level locking, and foreign keys YES YES YES MyISAM DEFAULT Default engine as of MySQL 3.23 with great performance NO NO NO = PLUGINS = NameStatus TypeLibrary License binlog ACTIVE STORAGE ENGINE NULLGPL partition ACTIVE STORAGE ENGINE NULLGPL ARCHIVE ACTIVE STORAGE ENGINE NULLGPL BLACKHOLE ACTIVE STORAGE ENGINE NULLGPL CSV ACTIVE STORAGE ENGINE NULLGPL FEDERATED DISABLEDSTORAGE ENGINE NULLGPL MEMORY ACTIVE STORAGE ENGINE NULLGPL InnoDB ACTIVE STORAGE ENGINE NULLGPL MRG_MYISAM ACTIVE STORAGE ENGINE NULLGPL MyISAM ACTIVE STORAGE ENGINE NULLGPL ndbcluster DISABLEDSTORAGE ENGINE NULLGPL I don't think there is a way to add those missing parts back to your current binaries. If you have tables using the InnoDB engine, I see these approaches you could take: 1) Go back to the version you used previously. You have a full system backup, I trust ? 2) Build from source. 3) Use other binary packages, like those available directly from MySQL (now: Oracle). [[...]] HTH, Joerg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@oracle.com ORACLE Deutschland B.V. Co. KG, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven Amtsgericht Muenchen: HRA 95603 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: best practice: mysql_multi, VMs w/single instance per or doesn't matter?
The biggest issue for me is that you want your development environment to be as identical as possible to the production environment (to avoid mistakes when you move your application over). You don't want your production environment to accidentally access your development data; but at the same time you want to make sure that your development isn't accidentally playing with the live data. Since I'm running a *AMP application, I can just use localhost and not worry about forgetting to change the database name references. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Friday, March 04, 2011 6:21 AM To: Sid Lane Cc: MySql Subject: Re: best practice: mysql_multi, VMs w/single instance per or doesn't matter? Other people have answered with pros and cons of virtualisation, but I would rather ask another question: why do you feel it necessary to split up the database? If it's only used for QC, it's probably not in intensive use. Why would you go through the bother of splitting it up? You're staying on the same server, apparently, so you'll have to decide which instance gets what part of cpu, memory and other resources, you'll have to provide separate backup for all instances, et cetera; while leaving things as they are is zero effort. What is the problem with the current setup that will be resolved by splitting? -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: how to RE-add innoDB storage?
-Original Message- From: ed [mailto:eth...@earthlink.net] [JS] snip I guess wordwrap is going to mess this up; mysql show engines ; [JS] Next time, try SHOW ENGINES\G Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: how to RE-add innoDB storage?
On 03/04/2011 10:46 AM, Jerry Schwartz wrote: -Original Message- From: ed [mailto:eth...@earthlink.net] [JS]snip I guess wordwrap is going to mess this up; mysql show engines ; [JS] Next time, try SHOW ENGINES\G Regards, I see no differences. thanks for the reply -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org