InnoDB tables using 90% cpu

Hi, I have a whole database I wanted to convert to InnoDB from MyISAM, but do not want to use alter table because of the problems I had last time. I made a whole dump of the table using mysqldump and changed all of the table create definitions from MyISAM to InnoDB. Theoretically this should be jus

Re: Major problem converting MyISAM to InnoDB

Thanks to everyone who helped. It turned out that we added an index to the table that was not in the frm file. This apparently causes innodb tables to have weird behavior, but nonetheless it is solved. Thanks! - Original Message - From: "Sasha Pachev" <[EMAIL PROTECTED]> To: "Cliff" <[EM

Selectinmg most recent dates from multiple table items

On Sat, 06 Mar 2004 20:40:24 -0600, Paul DuBois wrote: > > You can use your LIMIT clause as well, as long as by that you don't > mean "5 most recent from *each* table". > This seems similar to something I'm working on which I haven't sorted out to my satisfaction yet. We have a system that colle

Re: query date ranges - step 2

This one time, at band camp, Kevin Waterson <[EMAIL PROTECTED]> wrote: > seasonDateFrom seasonDateTo seasonRateWeekly > 2004-06-02 00:00:002004-10-31 00:00:00 42.86 > 2004-01-01 00:00:002004-06-01 00:00:00 34.29 > > When I take a booking I have yet another ra

Re: COLLATION

It worked !!! I used the latin1_bin collation. Thanks! SLepetys - Original Message - From: "Jeremy March" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 07, 2004 12:14 AM Subject: COLLATION > > But when I do a select for specifcly word like sao, I get all the three !!

COLLATION

> But when I do a select for specifcly word like sao, I get all the three !!! > > Internally MySQL isn't distinguing the different words, assuming that à = A, > and O = Ã. > I don't think MySQL has a Portuguese collation yet. You could try one of the other collations to see if its compatible wi

Re: Join Definitions

Hi Rhino, - Original Message - From: "Benoit St-Jean" Sent: Saturday, March 06, 2004 9:00 AM Subject: Re: Join Definitions > Rhino wrote: > > > Can anyone point me to documentation describing the concepts behind > > MySQL's different join types? [snip] > > http://www.mysql.com/doc/en/JOI

Re: selecting rows from several tables with same column names BUT not joined

At 12:57 +1100 3/7/04, Mark Beauman wrote: I have 15 tables, all with the same column names (but different values) where i want to SELECT all rows over all tables but not to JOIN. Is there a way i can do this? I am sure I am missing something simple but cannot seem to find the answer in the manu

Re: NULL versus just empty

With NULL you can check it usign the IS NULL operator. NULL could be a different use from the programer, like a row that IS NULL is a ROW that never have a data in that column, but a row with no data could be a row that was changed to that value. You could define the default value when is constru

Need a better index on this multiple join?

I'm trying to retrieve the "most viewed articles" and the number of times viewed, Any ideas for optimizing this? I'm a little confused about the EXPLAIN results since the second *should* be faster according to my interpretation of the manual A couple explanations stats.vdate -> unix timestamp of

COLLATION

Hi, I am using MySQL for a textual database in portuguese (brasilian). When I use the FTS index, the search behavior is strange, and when I dump the index using the fts_dump, there are several words that repeat itself in the index. For my surprise, the performance of the FTS for boolean search w

selecting rows from several tables with same column names BUT not joined

I have 15 tables, all with the same column names (but different values) where i want to SELECT all rows over all tables but not to JOIN. Is there a way i can do this? I am sure I am missing something simple but cannot seem to find the answer in the manual, forums. Furthermore i want to read the

NULL versus just empty

What is the difference between allowing NULL value in a field vs not specifying allow NULL. R> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Using GREATEST with DATETIME/TIMESTAMP values

What is the best or most efficient way to compare a mix of DATETIME and TIMESTAMP values using GREATEST()? Some values are columns and some are literals. Should I convert TIMESTAMP values to DATETIME formatted strings using DATE_FORMAT or convert everything to integers using UNIX_TIMESTAMP and then

Re: [Repost] Drop table %foo_%

At 8:02 -0500 3/6/04, David Jackson wrote: I'm reposting this question, the online manual doesn't address that quetion: http://www.mysql.com/doc/en/DROP_TABLE.html Yet, it's a question asked by 3 different comments posted on the manaul page listed above. Also please post a solutons to the manual pa

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) de

Join Definitions

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) determine th

[Repost] Drop table %foo_%

I'm reposting this question, the online manual doesn't address that quetion: http://www.mysql.com/doc/en/DROP_TABLE.html Yet, it's a question asked by 3 different comments posted on the manaul page listed above. Also please post a solutons to the manual page the URL above. TIA, David -- MySQL G

Why would this statement slow down over time

Mysql 4.x stable on OS X, I get about 12-18 hours good use out of it before a certain query starts to take a 30 seconds or more to return. I did not write the code, it is phpBB.com's code. I printed out the sql statement, which I will include below, is there any reason anyone can think of as to ho

Re: What causes a crashed table?

"Eric B." <[EMAIL PROTECTED]> wrote: > Hi, > > I ran into a slight problem this morning where MySQL suddenly wouldn't > recognize a table anymore. After doing a myisamchk on it, it listed the > table as having crashed. myisamchk -r on the table fixed the problem, but I > am concerned that this e

Re: MySQL 5 Application Error

"Mulugeta Maru" <[EMAIL PROTECTED]> wrote: >Table structure: > >CREATE TABLE `players` ( > `PLAYERNO` smallint(6) NOT NULL default '0', > `NAME` char(15) NOT NULL default '', > `INITIALS` char(3) default NULL, > `YEAR_OF_BIRTH` smallint(6) default NULL, > `SEX` char(1) default NULL, > `

RE: MySQL 5 Application Error

What is your question? Lol exactly show some errors man :D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]