Re: How can i drop tables with the same predix by using only one single statement?

Sorry for the multiple post screw up. My Bad On Thu, 2006-10-12 at 11:43 +0800, Ow Mun Heng wrote: On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote: Hey 方外 醉月 wrote: How can i do if i want to drop tables with the same predix? If you are using 5.0: DELIMITER // DROP

boolean search on phrase*

Hi All, I want a boolean search on a phrase. For example on olive oil, but it should return also olive oils etc. Now I use the following: SELECT Description FROM products WHERE MATCH (Description ) AGAINST('olive oil' IN BOOLEAN MODE); This works fine, but it does NOT return rows with olive oils.

MySQL and GFS

Hi, We are thinking of installing MySQL (4.1.x) on 2 nodes sharing the data over a SAN and using GFS. Is this setup correct, can the 2 nodes run active/active ? -- Taymour A El Erian System Division Manager RHCE, LPIC, CCNA, MCSE, CNA TE Data E-mail: [EMAIL PROTECTED] Web: www.tedata.net

Table status for innodb tables show innodb free 2 times

I recently deleted about 7.000.000 rows from a table, there are about 4.000.000 left. So I want to know how much space is free in table space now and execute: mysql show table status like table\G *** 1. row *** Name: table

Re: boolean search on phrase*

Hi The Boolen Search will itself satisfy your query. If you enclose the phrase within double quote (''), then the characters matches only rows that contain the phrase literally, as it was typed. Try removing quotes. Thanks ViSolve DB Team. - Original Message - From: C.R.Vegelin

Re: boolean search on phrase*

Thanks ViSolve, So far I have tried the next alternatives, not giving me what I need: a) ... MATCH (Description) AGAINST('olive oil' IN BOOLEAN MODE) giving only olive oil but not olive oils b) ... MATCH (Description) AGAINST('olive oil' IN BOOLEAN MODE) giving olive oil and olive oils

Re: boolean search on phrase*

Hi, Try with + and * fulltext boolean operators. For instance, MATCH (Description) AGAINST('+olive oil*' IN BOOLEAN MODE) Thanks, ViSolve DB Team. - Original Message - From: C.R.Vegelin [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday,

Re: Table status for innodb tables show innodb free 2 times

Dominik, what does SHOW TABLE STATUS show for other tables? Are you using innodb_file_per_table? Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM

Re: Table status for innodb tables show innodb free 2 times

what does SHOW TABLE STATUS show for other tables? It shows 2 values for about 3 of 260 tables. So most tables are okay. It does not seem to depend on table size, as the other tables only have a few hundred rows. Are you using innodb_file_per_table? Yes. -- MySQL General Mailing List

Re: Table status for innodb tables show innodb free 2 times

Dominik, I have now filed: http://bugs.mysql.com/bug.php?id=23211 about this. Is there any pattern that could explain why the double print is only in those 3 tables? What values does it print for the tables where the printout is wrong, and what values does it print for ok tables? Best

Re: Table status for innodb tables show innodb free 2 times

Heikki thanks for filing that report. You can close it again. I had a look at the create-table statements for these 3 tables. As it turns out, the person who initially created those tables had a create statement like create table ... comment='InnoDB free: 6144 kB' for some tables. All my

Re: OLAP for MySQL or an Aggregrate Table

You'd have to use another table. I don't believe mysql views will keep your 'moving average' values. If you're using 5.1, you can automate the select/insert with an event -- it's a cron like tool built into mysql. If you have a datetime field in either of the tables that represents the 'action'

Re: boolean search on phrase*

Hi ViSolve, I have tried various combinations with + and *, and with single and/or double quotes. But unfortunately I can't get the proper results. I get the impression that it's not possible ... Thanks anyway, Cor - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To:

RE: Boolean search on phrase*

Based on my experience, that wouldn't quite work. You'd need to preface each word with a plus sign: +olive +oil* and it would return records regardless of the order in which the two words appear, nor how far apart they are. That might be desirable, or it might not. Regards, Jerry Schwartz

Re: java mysql alias is being displayed blank?

On Wed, 2006-10-11 at 16:03 -0700, ADAM CZECH wrote: Does anyone know why a mysql alias would not display in the return a result? When I try to access say the first name with it's alias f_name, it is blank? , but it works for its column name first_name? This becomes more of a problem with

Finding duplicates

It seems to me I ought to be able to construct a query, probably using sub-SELECTs), that would do what I want. I have a table that looks roughly like this: CREATE TABLE prod (prod_num INTEGER UNIQUE, prod_title VARCHAR(255), updated DATE) UNIQUE PRIMARY KEY (prod_num); In this table there

Re: Finding duplicates

You're kind of heading down the right road. And this was discussed on the list not too long ago, how to delete duplicates. Here's one solution that will find the oldest duplicate(s): SELECT prod.prod_num,prod.prod_title,prod.updated FROM prod JOIN ( SELECT prod_title,max(updated) maxdate FROM

RE: Finding duplicates

Actually, the prod_num IS an auto-increment field, so you're suggestion would work. It would be much better than updated, especially since I found out that someone was busily updating the old products after the new ones were put in. I just started down the wrong road and never rethought the

RE: Slow Access When Inserting Records

Hi, I've tested the exact same ASP pages on my local computer, and the pages load very quickly. Therefore there must be a problem with dedicated windows server. Any ideas what the problem might be ? Thanks,Neil Date: Sun, 8 Oct 2006 17:17:07 -0500 To: mysql@lists.mysql.com From: [EMAIL

Grant privs to multiple tables at once?

Assume database 'biggie' with 15 tables, 10 of which start with 'foo_'. I want the user 'foouser' to have access only to those tables that begin with 'foo_'. I'm hoping that I am just being blind because I don't see anything in the manual or in the MySQL book on granting to multiple tables

best way to setup replication

I'd like to know what is the best way to setup the replication on my system. I hve all myisam tables and: - main db on production (master: system A; mysql 4.0.x); - slave db as backup/backoffice (system B; mysql 4.0.x); both are working and the replication works well. - system B is also the

Re: Grant privs to multiple tables at once?

I think you should try % that is used as wildcard instead for one or many characters. Granting on 'foo_%' might work. Regards, Anders -- Anders Lundgren Master Software Engineer Viba IT Handelsbolag Web: http://www.vibait.se David Felio wrote: Assume database 'biggie' with 15 tables, 10 of

Re: best way to setup replication

MAS - what you may have forgotten to do is tell system C where (or when if you think of it that way) to start replicating. Either that or system C wasn't empty when you started replicating into it. The procedure to set up replication like this would be: freeze master, flush data, record binlog

Re: Grant privs to multiple tables at once?

It doesn't. That was one of the multiple wildcard variations I already tried. David On Oct 12, 2006, at 3:13 PM, Anders Lundgren wrote: I think you should try % that is used as wildcard instead for one or many characters. Granting on 'foo_%' might work. Regards, Anders -- Anders

compiling mysql 4.2.1 with linux

Hello, We are trying to build from source MySQL standard ver. 4.2.1 on an Intel-based machine running LINUX FEDORA Core 5 without success Using a binary distribution. No RPMs Hardware being used: Optiplex GX620 Dell system. Pentium D-based processor and 1 GB of memory. Kernel

compiling mysql 4.2.1 with linux

Hello, We are trying to build from source MySQL standard ver. 4.2.1 on an Intel-based machine running LINUX FEDORA Core 5 without success Using a binary distribution. No RPMs Hardware being used: Optiplex GX620 Dell system. Pentium D-based processor and 1 GB of memory. Kernel

Re: compiling mysql 4.2.1 with linux

Hi, You're not using the correct version. The right one to compile is under Source and other files downloads section at the bottom of the page. Regards, Deckard abraham c wrote: Hello, We are trying to build from source MySQL standard ver. 4.2.1 on an Intel-based machine running LINUX

Moving DB to another System

Hi All, Wondering if it's possible for me to just tar up the DB (eg: TEST_DB) and then move it AS IS to another system? Is this possible or will I have to do a mysqldump (inclusive of create tables / data etc)?? It would be good if I can just copy (tar) the DB to another system and then

How do i initialize a new datadir in mysql ?

Dear all, If I am already have a datadir in /var/lib/mysql and I intend to start a new one in /var/lib/mysql2, how do i do it ? Thanks in advance, Low Kian Seong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: How do i initialize a new datadir in mysql ?

Hi, Create the initial databases and start the database with the following commands: shell mysql_install_db --datadir=/var/lib/mysql2 shell mysqld_safe --datadir=/val/lib/mysql2 Thanks ViSolve DB Team. - Original Message - From: Low Kian Seong [EMAIL PROTECTED] To: