InnoDB Netapp Snapshot

Hi, I need a procedure that will allow me to take an online (i.e. database up) Netapp Snapshot of a large InnoDB-based database. Could someone please confirm that this is a valid way of making a Snapshot: * Issue a flush tables with read lock; * Issue a flush logs; * Create the Snapshot * Issue

Re: Where on count(*)

Pupeno SELECT `Plans`.`id`, `Plans`.`name`, count(*) as 'count' FROM `Plans` JOIN `TechsPerPlan` ON `Plans`.`id` = `TechsPerPlan`.`plan` WHERE `TechsPerPlan`.`id` IN (17, 48, 54, 64, 75, 13, 30, 37, 45, 55, 65, 76, 11, 33, 46, 58, 68, 80) AND count = 3 GROUP BY `Plans`.`id` but it selected

Re: malloc troubles on 64-bit machine

Hi Jigal, all; Jigal van Hemert wrote: Hi Joerg, From: Joerg Bruehe Jigal van Hemert wrote: 050726 14:13:12 mysqld started 050726 14:13:12 InnoDB: Error: cannot allocate 7340048384 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 78086952 bytes. Operating

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: all user command

I think what you are looking for is show processlist; http://dev.mysql.com/doc/mysql/en/show-processlist.html You could also use Jeremy Zawodny's mytop (http://jeremy.zawodny.com/mysql/mytop/) or any of the MySQL administraion software available on the Internet On Wednesday 27 July 2005

port option ignored by commands

Hi, using mysql 4.0.22-standard-log. one instance on port 3307 one instance on port 3306 (each binary in its own independent directory) unix 'root' account submits following commands and connects to mysql on default 3306 port instead of awaited 3307 port : ~mysqld/bin/mysql --port=3307 -p

Re: port option ignored by commands

[EMAIL PROTECTED] wrote: Hi, using mysql 4.0.22-standard-log. one instance on port 3307 one instance on port 3306 (each binary in its own independent directory) unix 'root' account submits following commands and connects to mysql on default 3306 port instead of awaited 3307 port :

Re: Problem Escaping a Boolean Query

I ran into this problem a few months ago and the only workaround I could think of was to escape the quotes in the table with quot;. Then your query should be something like this select * from feeds where MATCH(feed_title, feed_content) AGAINST('Sean quot;P. Diddyquot; +Combs' IN BOOLEAN MODE)

Re: concat function problems

Hello Averyanov, [EMAIL PROTECTED] wrote: Hello Nuno, Tuesday, July 26, 2005, 8:53:33 PM, you wrote: [EMAIL PROTECTED] wrote: (...) When i try to execute the following query (...) i get this error: ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect...

Re: concat function problems

Hello Nuno, Tuesday, July 26, 2005, 8:53:33 PM, you wrote: [EMAIL PROTECTED] wrote: (...) When i try to execute the following query (...) i get this error: ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:6 Current database: test

Re: Urgent Pls....

Hello. chown: `mysql:mysql': invalid user Add mysql user and group (though, I thought that RPM package automatically does this). Please, next time send you replies to the list as well. Ashok Kumar wrote: Hi Gleb, Thank u for ur reply. I downloaded the following files.

Re: Update Debian 2.0 (mysql 3.21 to 3.22)

Hello. Thanks for the information, I will look more. What are the specifications (libraries) for compile mysql 3.22? Your compiling problem was that 'configure' script had failed while checking compiler. configure: error: installation or configuration problem: C++ compiler

Re: Which Engine to use...

'Bands', 'CREATE TABLE `bands` ( `BandID` int(11) NOT NULL auto_increment, `Band_Name` varchar(255) default NULL, PRIMARY KEY (`BandID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1' 'cd_type', 'CREATE TABLE `cd_type` ( `CD_ID` int(11) NOT NULL auto_increment, `Type` varchar(255) NOT NULL, PRIMARY KEY

Re: Which Engine to use...

OOPS!!! Wrong tables On 7/27/05, Scott Hamm [EMAIL PROTECTED] wrote: 'Bands', 'CREATE TABLE `bands` ( `BandID` int(11) NOT NULL auto_increment, `Band_Name` varchar(255) default NULL, PRIMARY KEY (`BandID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1' 'cd_type', 'CREATE TABLE `cd_type` (

Re: Which Engine to use...

'Batch', 'CREATE TABLE `batch` ( `QAID` int(10) default NULL, `Order` varchar(9) default NULL, `Errors` tinyint(1) NOT NULL, `Comments` varchar(255) default NULL, `QEID` int(10) default NULL, KEY `Index_1` (`QAID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1' 'QAErrors', 'CREATE TABLE `qaerrors` (

Re: port option ignored by commands SOLVED

Wolfram wrote : [EMAIL PROTECTED] wrote: Hi, using mysql 4.0.22-standard-log. one instance on port 3307 one instance on port 3306 (each binary in its own independent directory) unix 'root' account submits following commands and connects to mysql on default 3306 port instead of

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

RE: Correct way to use innodb_file_per_table?

Hi Bruce, I tried Heikki's solution but it did not work. The databases were there and table names but it could not open the idb files. This must be because of the table definitions are being stored in the shared space (according to the documentation)? Anyway looks like I will have to dump all

Re: mysql bug

Hello. Have you been at: http://dev.mysql.com/doc/mysql/en/starting-server.html Check the error log: http://dev.mysql.com/doc/mysql/en/error-log.html Maurizio Dudine [EMAIL PROTECTED] wrote: SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed

Re: Re search and replace in large text fields

Hello. Use TEXT or BLOB columns' types. See: http://dev.mysql.com/doc/mysql/en/blob.html Use hexademical values in your scripts which load pages in the database. See: http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html Possibly you'll need to increase packet size. See:

Re: Mysql +events

Hello. You could implement your own event notifiers using UDFs and TRIGGERs (triggers are available only in MySQL 5, which is not production ready yet). See: http://dev.mysql.com/doc/mysql/en/adding-functions.html http://dev.mysql.com/doc/mysql/en/triggers.html

Re: UNION in JDBC - WAS Re: use of indexes

Hello. Check with SHOW PROCESSLIST in which state MySQL thread which performs the query is. See: http://dev.mysql.com/doc/mysql/en/show-processlist.html Chris Faulkner [EMAIL PROTECTED] wrote: Hello again Following on from this index question, the UNION worked. From a normal

Re: Mysqld chewing up cpu in the background.

Thanks for the suggestion. That did help me find out. It wasn't idle. The problem is that its taking 10 seconds to insert a single record, composed mainly of one longtext field. The index is killing me. Does anyone know of how FT indexing can be changed to do inserts quicker or something? On

RE: query on a very big table

I have tables that are over 7 million records and I originally had the same issue, however if you will create indexes in those tables, on the columns that you will be using for your queries this will GREATLY speed up your queries. I am sure that there is a more concise way to state how you should

Doubt about query optimization

Hello, I´m using MySQL-4.1.7, and I have a query that seems, even using where clause, an specific table isn´t being optimized properly: I have four tables: real_state: cod, name, city, ag_cod, sell agency: cod, name, ag_status front: cod, rs_cod, ag_cod photo: cod, rs_cod These table have the

Continued x86_64 install problems

I managed to install MySQL-client-4.0.25-0.ia64.rpm MySQL-server-4.0.25-0.ia64.rpm MySQL-devel-4.0.25-0.ia64.rpm but MySQL-shared-4.0.25-0.ia64.rpm was still giving me the same error about missing a glibc library even though glibc 2.3 is installed. Though the install worked, I now get: [EMAIL

Re: Which Engine to use...

Scott Hamm [EMAIL PROTECTED] wrote on 07/27/2005 07:48:56 AM: 'Batch', 'CREATE TABLE `batch` ( `QAID` int(10) default NULL, `Order` varchar(9) default NULL, `Errors` tinyint(1) NOT NULL, `Comments` varchar(255) default NULL, `QEID` int(10) default NULL, KEY `Index_1` (`QAID`) )

Re: Which Engine to use...

mysql EXPLAIN - SELECT * - FROM QA - LEFT JOIN Batch - ON Batch.QAID=QA.ID - LEFT JOIN QAErrors - ON QAErrors.ID=Batch.QEID - WHERE QA.ID http://QA.ID BETWEEN 106805 AND 107179 - ORDER BY QA.ID http://QA.ID;

Re: Which Engine to use...

(I don't like top-posting but we are already in that pattern...) This looks good, except for the Using temporary; Using filesort (http://dev.mysql.com/doc/mysql/en/explain.html) From http://dev.mysql.com/doc/mysql/en/order-by-optimization.html If you want to increase ORDER BY speed, first see

Hour counts

Hello All! I would like to calculate the hour counts from 2 'datetime'. Example: 2005-07-27 18:00 and 2005-07-27 19:30 = 1,5 hour I try this but not good! R1 : munkaido_end-munkaido_start /simple substract/ R2 : ROUND(ROUND((end-start)/1)+

Re: Which Engine to use...

Created QAID QEID indices, now select time went down to .2787 seconds. Sorry about top-posting, it's a nice feature in gmail where it hides the text that was previously posted. Here is the updated explain result. mysql EXPLAIN - SELECT * - FROM QA - LEFT JOIN Batch - ON Batch.QAID=QA.ID -

Re: Hour counts

Hi, Check out the TIMEDIFF function. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com I would like

RE: Hour counts

There are a few options, for more information see http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html TIMESTAMPDIFF(interval,datetime_expr1,datetime_expr2) Returns the integer difference between the date or datetime expressions datetime_expr1 and datetime_expr2. The unit for the

Re: Hour counts

mysql select *,timediff(end,start) from foo; +-+-++-+ | start | end | id | timediff(end,start) | +-+-++-+ | 2005-07-14 15:00:00 |

cygwin build of client

I have make going right now, but does anyone have any suggestions? google was not much help for 4.1.x -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc.

Re: Hour counts

Hi, You can use Timediff : mysql SELECT TIMEDIFF('2005-07-27 18:00', '2005-07-27 19:30'); +--+ | TIMEDIFF('2005-07-27 18:00', '2005-07-27 19:30') | +--+ | -01:30:00

Re: Hour counts

Hi, You can use Timediff : mysql SELECT TIMEDIFF('2005-07-27 18:00', '2005-07-27 19:30'); +--+ | TIMEDIFF('2005-07-27 18:00', '2005-07-27 19:30') | +--+ | -01:30:00

Re: Hour counts

TIMESTAMP() is available as of MySQL 4.1.1. I can't use this version because replication working :( I use version 4.0.22 - Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: Gyurasits Zoltán [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Wednesday, July 27, 2005 6:31 PM

Re: Hour counts

Gyurasits Zoltán [EMAIL PROTECTED] wrote on 07/27/2005 12:57:42 PM: TIMESTAMP() is available as of MySQL 4.1.1. I can't use this version because replication working :( I use version 4.0.22 - Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: Gyurasits Zoltán

Re: Hour counts

Working!!! Thank you!!! - Original Message - From: [EMAIL PROTECTED] To: Gyurasits Zoltán [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, July 27, 2005 7:09 PM Subject: Re: Hour counts Gyurasits Zoltán [EMAIL PROTECTED] wrote on 07/27/2005 12:57:42 PM: TIMESTAMP()

Re: Mysqld chewing up cpu in the background.

At 09:16 AM 7/27/2005, you wrote: Thanks for the suggestion. That did help me find out. It wasn't idle. The problem is that its taking 10 seconds to insert a single record, composed mainly of one longtext field. The index is killing me. Does anyone know of how FT indexing can be changed to do

Insert with prefix

Hello, I have the following dilemma, that I do not know how to handle. I have the need for a table where I create a identifier. The identifier consists of a two character string, eg: UP + the next AUTO_INCREMENT Here is what I have. category_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

Re: Doubt about query optimization

Can you send us the actual show indexes from table and explain output that isn't shortend? Ronan Lucio wrote: Hello, I´m using MySQL-4.1.7, and I have a query that seems, even using where clause, an specific table isn´t being optimized properly: I have four tables: real_state: cod, name,

Re: Insert with prefix

Try this: concat('UP', lpad(category_id, 6, '0')); Scott Purcell wrote: Hello, I have the following dilemma, that I do not know how to handle. I have the need for a table where I create a identifier. The identifier consists of a two character string, eg: UP + the next AUTO_INCREMENT Here is

Re: Hour counts

This does make his code fall under the limitations of unix timestamps. In 30 years or so when we are all retired millionaires ;) some poor intern is going to have to figure out why the hour diff calculation is failing. [EMAIL PROTECTED] wrote: Gyurasits Zoltán [EMAIL PROTECTED] wrote on

Re: Insert with prefix

Eric Bergen [EMAIL PROTECTED] wrote on 07/27/2005 05:03:40 PM: Try this: concat('UP', lpad(category_id, 6, '0')); Scott Purcell wrote: Hello, I have the following dilemma, that I do not know how to handle. I have the need for a table where I create a identifier. The identifier

RE: Continued x86_64 install problems

Hi Anne, I managed to install MySQL-client-4.0.25-0.ia64.rpm MySQL-server-4.0.25-0.ia64.rpm MySQL-devel-4.0.25-0.ia64.rpm ... x86_64 != ia64 You have installed the wrong architecture executables. Try downloading the x86_64 versions instead. Also have a read of our Opteron (x86_64) HOWTO:

Total Sum of Monthly Counts for Older MySQL 4.0.22 (Please Help)

Hello MySQL users, Currently, I use MySQL 4.0.22 and I can do a straightforward count of employees hired for each month. select employee_hire_date, count(employee_id) from table_employee where employee_hire_date between 2005-01-01 and 2005-4-30 group by month(employee_hire_date) Date |

search in all tables in the data base ..

Hi all. Please could you advise. I would like to know if one could do a recursive search through a data base and get a result of wich column and field is holding the string ? Many Thanks . -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za Web Hosting Solutions Scalable