Re: best mysql optimization tutorial and/or quick start guide?

John G. Heim wrote: - Original Message - From: "Darryle Steplight" To: "Stephen Edberg" Cc: "John G. Heim" ; Sent: Thursday, March 05, 2009 12:53 PM Subject: Re: best mysql optimization tutorial and/or quick start guide? High Performance MySql "Optimization, Backups, Replication,

Re: best mysql optimization tutorial and/or quick start guide?

- Original Message - From: "Darryle Steplight" To: "Stephen Edberg" Cc: "John G. Heim" ; Sent: Thursday, March 05, 2009 12:53 PM Subject: Re: best mysql optimization tutorial and/or quick start guide? High Performance MySql "Optimization, Backups, Replication, and more" 2nd Edition

Re: Can't create table

Octavian Râºniþã wrote: Hello, I've tried to create these 4 test tables, but when I try to create the last one, MySQL gives the following error: ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm' (errno : 150) It seems that the foreign keys are not created well i

Can't create table

Hello, I've tried to create these 4 test tables, but when I try to create the last one, MySQL gives the following error: ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm' (errno : 150) It seems that the foreign keys are not created well in the fourth table, and I don't

MySQL University session on March 19: How to Use Charsets and Collations Properly

How to Use Charsets and Collations Properly http://forge.mysql.com/wiki/How_to_Use_Charsets_and_Collations_Properly This Thursday (March 19th, 14:00 UTC), Susanne Ebrecht will give a MySQL University session on How to Use Charsets and Collations Properly. Susanne works at the MySQL Support team an

Re: W2008 Server Issues?

Duncan, Kurt (MCUSA) wrote: 1. Any issues running MySQL Ver. X on Windows 2008 Server? 2. Running a query to list all records of about 2600 records is very slow and gets an error of Extremely High Work Load, Each record does contain 1 LONGBLOB containing small voice recording. We are

W2008 Server Issues?

1. Any issues running MySQL Ver. X on Windows 2008 Server? 2. Running a query to list all records of about 2600 records is very slow and gets an error of Extremely High Work Load, Each record does contain 1 LONGBLOB containing small voice recording. We are using the SQL Query Browser an

Re: Ever-shrinking disk space after repeated DB restores

OK, I found the answer. The binary log files were filling up (/usr/ local/mysql/data on OS X/mysql-bin.x). Easy fix: mysql> reset master; And all the disk space is recovered On 15-Mar-09, at 10:47 AM, René Fournier wrote: It seems MySQL isn't releasing disk space on my laptop afte

Migrating all MySQL from Netware to Suse

Hi! Trying to migrate from Netware to Suse (SLES 10 sp 1 NOWS SBE 2). I already changed the my.cnf file: 1.added a datadir=/MySQL/data line 2.removed the comments from all INNOdb lines The tables on the Netware files are not big On the SLES server I already see a mysql folder containing tables

Re: MySQL 5.1 Rolling back a transaction containing Create Alter Drop table statements

On Mon, Mar 16, 2009 at 10:25 AM, Hatem Nassrat wrote: > Hi, > > Is there any way to rollback a transaction in MySQL 5.1 that contains > "Create", "Alter", "Drop", table statements. No. Sorry. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

MySQL 5.1 Rolling back a transaction containing Create Alter Drop table statements

Hi, Is there any way to rollback a transaction in MySQL 5.1 that contains "Create", "Alter", "Drop", table statements. i.e. is there any way to turn off the feature:     "Statements That Cause an Implicit Commit" or even remove some of the default statements that cause a commit. I tried using

Re: what will happen if the disk is full when mysql flush binlog to it

Hi Cui, On Sat, Mar 14, 2009 at 4:33 PM, Cui Shijun wrote: > hi, >  What will happen if the disk is full when mysql flush binlog to it? > >  If I use innodb engine(mysql-5.1.22) and turn on the binlog, is > there any chance > that mysql has data updated without binlog flushed? > >  Will mysql ret

Re: InnoDB - CREATE INDEX - Locks table for too long

Hi, I am using your procedure on MyISAM tables now and works but RENAME does not work with locked tables, (anyway it is already an atomic operation) =BARON Try something like this: create table new_table like old_table; alter table new_table add

Re: Getting single results per (left) record with INNER JOIN

Hi Nigel, all ! Nigel Peck wrote: > [[...]] > > My query is: > > SELECT > `People`.`person_id`, > `People`.`name` > FROM > `People` > INNER JOIN > `Person_postal_addresses` > ON > `Person_postal_addresses`.`person_id` = `People`.`person_id` > WHERE > `People`.`name` REGE

Can't send messages to the mailing list

Hello, I was subscribed for a long time to MySQL general mailing list but now I see that I can't send messages to the list because they are rejected, and in the error mail message that returns, I saw that it says something about SPAM. I didn't send spam mails to the list or to somewhere else bu