RE: Considering migration from MyISAM to InnoDB

PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 7:00 PM To: Stembridge, Michael Cc: mysql@lists.mysql.com Subject: Re: Considering migration from MyISAM to InnoDB see the my.cnf examples in the install dir, and look at innodb* variables. you can migrate each table just using

Considering migration from MyISAM to InnoDB

I currently use MyISAM on an internal web application server; our data takes up 10mb at this time, though this is likely to grow substantially in the coming year. The database sees moderate heavy read and moderate write usage from 50 users. We're upgrading our sever from Red Hat 7.3 to SuSE

SET question - @ or @@?

While I was RTFM to find out how long SET variables last, I noticed that my book uses @@VarName but the sample code I'm using has @ VarName. I didn't see a reference to the single @ in the SET section of my book. So, what is the difference between @@ and @? Thank you.

SELECT rows from the previous business day

A table exists with id and datetime columns; I need to SELECT records from the previous business day. I began with this: SELECT id FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(datetime) =1 But if NOW() is a Monday, it pulls records from Sunday (there are none since records are inserted

SELECT assistance

I have a table containing three columns: Int intint ++-++ | id | serialbegin | serialend | ++-++ | 1 | 10 | 20 | ++-++ And say we have serial number 11. Is there a way to

Optimising COUNT()

I noticed another listmember used COUNT(fieldname) instead of COUNT(*). Is there a noticeable performance increase with COUNTing a column name instead of all columns? (ie, like SELECTing specific columns instead of using SELECT *) Thanks! -- MySQL General Mailing List For list archives:

RE: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');

RE: Import Access Data... I'll try and import using ODBC. Is there any good web sites about ODBC and its operations that I can learn about it? Scott If you haven't found this by now: http://forums.mysql.com/list.php?65 - MySQL forum for Access conversion. Many people use ODBC to migrate

Illegal mix of collations - new twist on a familiar problem...

When running this simple query: SELECT fileid FROM test WHERE ecn='0' MySQL yields this error: #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' The table collation is latin1_swedish_ci. I ran SHOW CREATE TABLE fileid and

mysqldump vs. 'mysql [db] file.sql'

mysqldump vs. 'mysql [db] file.sql' I stumbled across the latter method early on but notice that most folks suggest using mysqldump instead; are there performance benefits with using mysqldump, or some other reason? The same question could be applied to using mysqlimport vs. 'mysql [db]

Upgrading bundled ver of mysql included with php 4.3.1

What steps are needed to upgrade (or remove) the builtin mysql [3.23.49] included with php 4.3.1 source? I have mysql 4.x installed and working by itself, but php continues to use 3.23.49. I have tried recompiling php 4.3.1 without --with-mysql on the configure line. Doing so did not remove

PHP reports 3.23.49, command line reports 4.0.1

I installed PHP 4.3.1 via source and used the following option when configuring: ./configure --with-mysql The database has worked great for a couple of years, however I noticed a problem today. Phpinfo() returns MySQL Version 3.23 from a php script. Client API version

RE: PHP reports 3.23.49, command line reports 4.0.1

I installed PHP 4.3.1 via source and used the following option when configuring: ./configure --with-mysql The database has worked great for a couple of years, however I noticed a problem today. Phpinfo() returns MySQL Version 3.23 from a php script. Client API version

RE: PHP reports 3.23.49, command line reports 4.0.1

So I assume the version of MySQL bundled with PHP 4.3.1 is in fact 3.23.49 and this is overriding my standalone installation. It's not overriding anything, it's doing what you asked: in your configure you told PHP to use its built-in (MYSQL_MODULE_TYPE) MySQL support. Without

SELECT a percentage range of a given value

Hello, I have a music database containing song BPM (Beats Per Minute) data values stored as FLOAT. I need to pull a range of BPM values based on a user-supplied integer. The range should pull all records which are 8% higher and lower than the given integer. I tried this query for

RE: SELECT a percentage range of a given value

Ah, this is not as complex as I imagined. Thanks! -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 4:52 PM To: Stembridge, Michael Cc: [EMAIL PROTECTED] Subject: Re: SELECT a percentage range of a given value SELECT * FROM test

MySQL Gamma 4.0 - safe for production?

I've been researching the possibilities of upgrading from MySQL 3.23 to 4.0 and have read opinions supporting why I should stay with what I have, upgrade, or move to another DB altogether. I thought it would be in my best interests to ask this list the same question. I'm not interested in

Sluggish performance on medium sized table.. EXPLAIN SELECT's included.

A database is being used to log support calls for a call center. There are around 25,000 clients in the database. The existing call notes were imported from flat text files. One table (call_notes) contains the call time, ticketid, noteid, ect.. Another table (call_notes_text) only contains

Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.

A database is being used to log support calls for a call center. There are around 25,000 clients in the database. The existing call notes were imported from flat text files. One table (call_notes) contains the call time, ticketid, noteid, ect.. Another table (call_notes_text) only contains

All records returne with JOIN

The following query takes a very long time to process. It finally returns only the row I'm wanting, but when I run an EXPLAIN SELECT on it, it looks like all 14687 rows are being examined for the record -- instead of mysql honing in on the desired row immediately. SELECT

RE: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.

: Brent Baisley [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:18 PM To: Stembridge, Michael; [EMAIL PROTECTED] Subject: Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded. Try changing your WHERE clause from: WHERE call_notes.ticketid = '1

RE: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.

Thank you Keith - I worked with your example and LEFT JOIN has solved the problem. Best Regards, Mike -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:26 PM To: [EMAIL PROTECTED] Cc: Stembridge, Michael Subject: Re: Sluggish

Inserting files from command prompt

Can a file be inserted to a mysql table from a unix(linux) command prompt? Also, can I query the same table and output the data to a filename.ext in a specified directory? Not sure if this is an appropriate question for the list, but all clues/examples would be greatly appreciated.

RE: Inserting files from command prompt

PROTECTED]] Sent: Wednesday, March 20, 2002 2:34 PM To: Stembridge, Michael Cc: [EMAIL PROTECTED] Subject: Re: Inserting files from command prompt I do this from the command line sometimes: mysql -h HOST -pPASSWORD DATABASE statements.sql The statements.sql file should contain full sql