Re: Risks involved in MyISAM to Innodb

On 21/09/2012 9:26 AM, Girish Talluru wrote: Hi Guys, I have requirement to change my production database tables which are using myISAM and now bcoz of some changes we have to move to Innodb. Can anyone suggest how the plan should be and risks involve? Thanks, Girish Talluru Whats the size

Re: Max connections being used every 10-12 day.

Fredrik Carlsson wrote: It is a single PIII 500MHz, so i just changed thread_concurrency to 2 :), thanks The slow query log don't show that many slow queries, but they did show alot of queries that was'nt using any index, can these queries cause some kind of occasional lock up? Is there a

Re: scanning 2 rows slow index fast 26GB MyISAM

Bryan Heitman wrote: I am experiencing extreme slowness performing a query in which 2 rows are returned hanging in the sending data status. Performing an index only query such as SELECT COUNT(*) is extremely quick so I know the only extra step is retrieving the data from the MYD. I am looking

LOAD DATA INFILE

every time. I just don't want the MySQL server to slow down to a point where my website becomes unresponsive while I'm loading a few Gigs of data... Any idea? Thank you! = - Benoit St-Jean MySQL DBA Yahoo! Messenger: bstjean -- MySQL General Mailing List For list archives

Re: Queries per second average

Dan Johnson wrote: The site that I am working on is experiencing MySQL freeze ups any time after the 'Queries per second average'; seen on the STATUS output; is at 48-50 in value. When the site owner asked the hosting service about this they told him that the MySQL cannot go above that limit.

Re: Another Performance query

A Z wrote: Thanks for your replies regarding to my previous query. We have encountered another problem: MySQL 4.0.14, INNODB. A table does have an Index on Field1, this field (Field1) is also the Primary Key. Querying on this field takes a long time, running along with Explain command it

Re: Join Definitions

Rhino wrote: Can anyone point me to documentation describing the concepts behind MySQL's different join types? I've got a lot of experience with DB2 but I want to do four things: a) verify that 'natural join', 'left outer join', and 'right outer join' mean the same in both MySQL and DB2. b)

Re: InnoDb Table Performance problem

Michael McTernan wrote: Hi, SELECT COUNT(*) for InnoDB tables is a know problem... The table handler (for InnoDB) has to do a table scan to count all rows... This particular case is optimized with MyISAM ... Sure. But why is the tablescan ~100 times faster for the table without the

Re: InnoDb Table Performance problem

Michael McTernan wrote: Hi there, I'm making something similar to a file revision control system, and using MySQL on Linux as the database to drive it. Almost all my tables are InnoDB, and generally it is going very well, with the exception of one table that is always very slow. This table

Re: Order by problem

Martijn Tonies wrote: Hi, == I have an ID field in my database...it reads like this ASS1 ASS23 ASS4 ASS10 ASS6 when i'm retrieving the data by taking ORDER BY clause it is sorting like this ASS1 ASS10 ASS23 ASS4 ASS6 means its only sorting by the 4 the character. i want the sorting to be done

Stopping InnoDb recovery and fixed columns

dynamic ones. In a table with a few millions rows, it can make a big difference! tia filter: mysql, sql, table, database = - Benoit St-Jean [EMAIL PROTECTED] Yahoo! Messenger: bstjean http://cactus.swiki.net

InnoDb tablespace file compaction

Hi MySQL , I have made a test database for performance testing and my InnoDb tablespace grew from 1Gig to 8 Gig... After I dropped that test database, the tablespace stayed to the same size. How can I resize it to its original size? = - Benoit St-Jean [EMAIL

Re: Fastest way to get the number of rows in a table ?

section 4 of the InnoDb manual. http://www.innodb.com/ibman.html Hope this helps = - Benoit St-Jean [EMAIL PROTECTED] Yahoo! Messenger: bstjean http://cactus.swiki.net

Caldera OpenLinux eDesktop 2.4 and MySQL

Anyone has tried MySQL 3.23.5x (or even 4.x) on Caldera OpenLinux eDesktop 2.4 ? I am considering setting up a server on Linux but I want to know if MySQL has any preoblem on Caldera's . Thanks filter: SQL, database, MySQL = - Benoit St-Jean [EMAIL PROTECTED] Yahoo

2 MySQL Servers running on the same machine

= - Benoit St-Jean [EMAIL PROTECTED] Yahoo! Messenger: bstjean http://cactus.swiki.net - __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com

RE: dos trouble

want to run it as a service (I assume you have Windows NT or 2000), use the --install option. Now, you could open another command prompt window and start mysql with, for example: mysql --user=someguy --password=secret Hope this helps. = - Benoit St-Jean [EMAIL