MySQL Workbench

Anyone have any info on MySQL Workbench? In it's latest state it isn't usable at all. It looks like it'll be really great.     Thanks,   Chris ParkerAardvark Tactical, Inc.IT Manager1002 W Tenth St. Azusa, CA 91702phone: 800.997.3773 x130 fax: 626.334.6860[EMAIL PROTECTED]  

Re: How many colums should a index contain?

John.H wrote: but why when I do a query with 'explain' ,it shows that the 'possible_keys' is null or primary rather than the index I just create Please always CC the list - you will get much faster responses and others will be able to offer their input as well. Post the query, the explain

Re: Will a subquery use a index?

John.H wrote: I found that when I use a query as a subquery it will not use the right index at all?? Post the query, the explain and the relevant table details and someone might have a suggestion. Also - not every single query is going to be able to use an index, this may be one of those ca

Re: MyISAM vs InnoDB

Em Thu, 02 Nov 2006 17:40:44 +0100, Martijn Tonies escreveu: > InterBase had two-phase commits ages ago, Firebird inherited it. > > If there's anything specific you want to know, ask I *am* asking — where is the specific piece of documentation? Because if you don’t read MySQL’s

Re: MyISAM vs InnoDB

Em Thu, 02 Nov 2006 17:30:14 +0100, Martijn Tonies escreveu: > Falcon has a transactional storage engine, including Foreign > Keys (Jim wouldn't do a database without em) Obviouſly. > MGA Ma ze? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrado

MySQL 5.1.12 Beta has been released

Dear MySQL users, We are proud to present to you the MySQL Server 5.1.12 Beta release, a new Beta version of the popular open source database. Bear in mind that this is a beta release, and as any other pre-production release, it should not be installed for production level systems or systems with

Re: MyISAM vs InnoDB

On 11/2/06, Leandro Guimarães Faria Corcete DUTRA wrote: Em Wed, 01 Nov 2006 09:34:05 -0600, mos escreveu: > Is there a better open source database out there for that amount of data? Several. MySQL's own MaxDB, PostgreSQL, Firebird if you are into Borland stuff, Ingres if you need XA

Re: MyISAM vs InnoDB

> >> Several. MySQL’s own MaxDB, PostgreSQL, Firebird if you are into > >> Borland stuff, Ingres if you need XA distributed transactions. > > > > Firebird isn't Borland > > Granted. But it is (even more) attractive if you are already a Borland > shop. > > > >> I usually recommend PostgreSQL

Re: MyISAM vs InnoDB

Em Thu, 02 Nov 2006 15:32:06 +0100, Martijn Tonies escreveu: >> Several. MySQL’s own MaxDB, PostgreSQL, Firebird if you are into >> Borland stuff, Ingres if you need XA distributed transactions. > > Firebird isn't Borland Granted. But it is (even more) attractive if you are alrea

Re: MyISAM vs InnoDB

>> > > Is there a better open source database out there for that amount of >>data? >> > >> > Several. MySQLâ?Ts own MaxDB, PostgreSQL, Firebird if you are into >> > Borland stuff, Ingres if you need XA distributed transactions. >> >>Firebird isn't Borland :-) >> >> > I usually recommend Postg

Re: MyISAM vs InnoDB

At 08:32 AM 11/2/2006, you wrote: > >> Always use a DBMS, and MySQL is no (proper) DBMS without a > >> transactional backend. There are InnoDB, which is not completely free (needs > >> a proprietary backup tool); BDB, which is deprecated until further notices; > >> and SolidDB, which is

Re: MyISAM vs InnoDB

> >> Always use a DBMS, and MySQL is no (proper) DBMS without a > >> transactional backend. There are InnoDB, which is not completely free (needs > >> a proprietary backup tool); BDB, which is deprecated until further notices; > >> and SolidDB, which is still β. > > > > Ok, so your soluti

Re: Can't create database

Mário Gamito wrote: Hi, I've installed MySQL 5.0.27, but can't create databases. I get "ERROR 1006 (HY000): Can't create database 'contineo' (errno: 28)" In the log file i have this: "InnoDB: Error: auto-extending data file ./ibdata1 is of a different size InnoDB: 0 pages (rounded down to MB) t

Re: MyISAM vs InnoDB

Em Wed, 01 Nov 2006 09:34:05 -0600, mos escreveu: > At 05:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote: >> >> Always use a DBMS, and MySQL is no (proper) DBMS without a >> transactional backend. There are InnoDB, which is not completely free (needs >> a proprietary backup

Re: Can't create database

Make sure that the UNIX or Linux Admins have added you to the User Group that will be writing data and making folders in the data directory of MySQL - Original Message - From: Mário Gamito <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Thursday, November 2, 2006 8:06:13 AM GMT-0500 US

Troubles starting MySQL

Hi, I'm having a hard time starting MySQL 4.1.21 I get: "Starting mysqld daemon with databases from /usr/local/mysql-4.1.21/var STOPPING server from pid file /tmp/mysql.pid 061102 14:06:13 mysqld ended" In the logs, i have: "061102 14:07:25 mysqld started InnoDB: Error: auto-extending data fi

Re: help trying to add an autoincrement col to an exisiting table

You are better off doing the following DROP TABLE IF EXISTS users_new; CREATE TABLE users_new ( uname varchar(20) NOT NULL default '', passwd varchar(15) NOT NULL default '', fname varchar(25) NOT NULL default '', lname varchar(40) NOT NULL default '', dir varchar(28) NOT NULL default ''

Re: Pushing mysql to the limits

Em Wed, 01 Nov 2006 00:00:23 -0800, Cabbar Duzayak escreveu: > We have huge amount of data, and we are planning to use logical > partitioning to divide it over multiple machines/mysql instances. This is a hard call. You will have to keep data consistent among servers, and MySQL does not

Re: How to view locks in MySQL

You may want to look into a MySQL paradigm called Advisory Locking. You could read MYSQL 5.0 Certification Study Guide, Chapter 28 pages 403,404 or got these URLs for more on GET_LCOK and RELEASE_LOCK functions http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html http://dev.mysql.com/doc/

Re: Last and Last-1

select idTable ... FROM FaxServer ORDER by DateFaxInsert DESC LIMIT 2 suomi Vittorio Zuccalà wrote: Hi, i've a table in a mysql database. It has a lot of field and three of them are: * A counter: IDTable * A date: DateFaxInsert * A Number: NumberFaxInsert I want to obtain the last and the last

Re: Manually Inserted Data

I did this on my computer create table site_calendar_v2 ( id int,start date,end date,global int, status varchar(20),time timestamp not null default now()); SELECT A.ID,A.Start,A.End FROM ((SELECT ID, Start, End FROM site_calendar_v2 as c WHERE Global='1' ) UNION ( SELECT '9', '2006-11-01', '

Re: Query ignoring index

Hi Johan, Thanks for that, it explains what's going on. I've added `date` to the `coords` index and that seems to have sped things up considerably. Thanks. - Jonathon Johan Höök wrote: Hi Jonathon, MySQL is using the index for both queries, as the column "key" in the explain result says.

Can't create database

Hi, I've installed MySQL 5.0.27, but can't create databases. I get "ERROR 1006 (HY000): Can't create database 'contineo' (errno: 28)" In the log file i have this: "InnoDB: Error: auto-extending data file ./ibdata1 is of a different size InnoDB: 0 pages (rounded down to MB) than specified in the

Re: Query ignoring index

Hi Jonathon, MySQL is using the index for both queries, as the column "key" in the explain result says. Using index means that MySQL can find all info it needs by looking at the index only, i.e doesn't need to look into the table. See: http://dev.mysql.com/doc/refman/5.0/en/explain.html for more

Re: More than one MyQSL in a server

hi, have you traced .err file for the nature of the error? if not you can try that. Thanks ViSolve DB Team - Original Message - From: "Mário Gamito" <[EMAIL PROTECTED]> To: "Nico Sabbi" <[EMAIL PROTECTED]> Cc: Sent: Thursday, November 02, 2006 4:31 PM Subject: Re: More than one MyQSL i

Query ignoring index

Hello, I've been working on some queries with a large dataset (7.5 million rows) and have been finding problems with indexes seemingly being ignored for some queries - this obviously slows the query right down, I've seen some queries take up to 30 seconds. This only seems to happen when I us

Last and Last-1

Hi, i've a table in a mysql database. It has a lot of field and three of them are: * A counter: IDTable * A date: DateFaxInsert * A Number: NumberFaxInsert I want to obtain the last and the last - 1 IDTable. If i write: SELECT MAX(IDTable) AS IDMax, DateFaxInsert, NumberFaxInsert FROM FaxServer

Re: More than one MyQSL in a server

Hi, I'm now trying to run the second MySQL with: # ./mysqld_safe --port=3307 --socket=/usr/local/mysql-5.0.27/share/mysql.sock2 --pid-file=/tmp/mysql.sock2 --datadir=/usr/local/mysql-5.0.27/var/ but i get: "Starting mysqld daemon with databases from /usr/local/mysql-5.0.27/var/ STOPPING server f

Re: More than one MyQSL in a server

Mário Gamito wrote: Hi, I have a 3.23 MySQL running in a server and i want to install 5.0.27 I made # ./configure --prefix=/usr/local/mysql-5.0.27 --with-tcp-port=3307 # make # make install and then # scripts/mysql_install_db --datadir=/usr/local/mysql-5.0.27/var # ./mysqld_safe --datadir=/

Will a subquery use a index?

I found that when I use a query as a subquery it will not use the right index at all??

More than one MyQSL in a server

Hi, I have a 3.23 MySQL running in a server and i want to install 5.0.27 I made # ./configure --prefix=/usr/local/mysql-5.0.27 --with-tcp-port=3307 # make # make install and then # scripts/mysql_install_db --datadir=/usr/local/mysql-5.0.27/var # ./mysqld_safe --datadir=/usr/local/mysql-5.0.27

Re: How many colums should a index contain?

John.H wrote: I have two tables and I must do : select `id`,`bid`,`title`,`link`,`bname` from table1 where `bid` in ( ...this is a subquery in table2 ) should I create a index (`id`,`bid`,`title`,`link`,`bname`) so that my query will take less time or should a index contain so many colums? I

How many colums should a index contain?

I have two tables and I must do : select `id`,`bid`,`title`,`link`,`bname` from table1 where `bid` in ( ...this is a subquery in table2 ) should I create a index (`id`,`bid`,`title`,`link`,`bname`) so that my query will take less time or should a index contain so many colums?