RE: MySql Version difference

Thanks Peter. But is there any other way to do that. Can't i directly compare the 2 version, instead of reading Change Histroy section for all the version in between. Regards, Nilesh _ From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 11:56 AM T

Re: MySql Version difference

How could i know the difference between these 2 version and there compatiblity. Read the Change History section of the manual for versions 5.0.19 through 5.0.27. PB - Nilesh wrote: Hi, I have a webapplication developed using J2EE. For the application, the database is on MySQL

Re: speeding up a join COUNT

and also an index on users.entity_id (will help the join) should solve your problem. Thanks Alex On 1/24/07, Brent Baisley <[EMAIL PROTECTED]> wrote: You should create indexes on the fields you search on most. In this case, you are searching on the user_type field, so create an index on that f

mysqlmanager safe?

I've switched over to the mysqlmanager startup system instead of the old mysqld_safe because thats the only supported method in mysql5. I needed to restart a DB so I did a `/etc/init.d/mysqlmanager restart` which seemed to work, but there were some problems: - the daemon was no longer accepting c

Re: best way to query this table

At 03:31 PM 1/24/2007, Martijn Tonies wrote: Hello Randy, > I have a table that has a column that has a timestamp Column. > > This table is going to get very large ( 1 or 2 million rows) and will > be queried alot. > > Alot of these queries will be against timestamp column. > > These queries wi

Re: best way to query this table

Hello Randy, > I have a table that has a column that has a timestamp Column. > > This table is going to get very large ( 1 or 2 million rows) and will > be queried alot. > > Alot of these queries will be against timestamp column. > > These queries will be like, getting entries for today, this week

Re: New DBManager Released

Yes it is true. I downloaded it and installed it to try and manage my user accounts. In the feature list it says Object Maintenance and User Objects are listed. But when you try to manage a user account I get a message saying that the feature is not available in this version. - enjoy >>> "C

best way to query this table

Hello, I have a table that has a column that has a timestamp Column. This table is going to get very large ( 1 or 2 million rows) and will be queried alot. Alot of these queries will be against timestamp column. These queries will be like, getting entries for today, this week and this month I

Re: speeding up a join COUNT

You should create indexes on the fields you search on most. In this case, you are searching on the user_type field, so create an index on that field. Otherwise you need to scan the entire table to find out which users are of the type you are searching for. - Original Message - From: "J

Re: After backup/restore view turns to table

Hi All ! I did "mysqldump mydb -uroot -ppass --databases --add-locks --allow-keywords --create-options --extended-insert --routines -r file.sql" and after that in MySQL Command Line Client "source file.sql" After that my view was converted to an empty table. What should I do to backup and

RE: Alias a function result?

You are correct, I mangled the actual query. What I meant to type was SELECT book_author, GROUP_CONCAT(book_title) AS book_title FROM books WHERE book_title LIKE "" GROUP BY book_author; The key question was about the use of the true name of a column in the WHERE clause while using an alias of th

RE: Alias a function result?

I saw a reference that said standard SQL doesn't allow an alias to be used in a WHERE clause, but I thought perhaps I'd get an error message. I understand why, logically, it should be the way it is. Thanks for the reassurance. Regards, Jerry Schwartz Global Information Incorporated 195 Farmingto

[urgent] - Problem with index_merge

Hello all, I have struck with a big problem with MySQL 5.0.22 server on RHEL 3. After an upgradation from MySQL 4.1.11 to MySQL 5.0.22 almost all the queries are struggling to execute and the DB server is clogged. Below is an example of what is happening. This query usd to execute very fast on

Innodb Error 1030

I'm trying to fix a problem with a users innodb database (mysql 5.0).When they try a very simple insert they get "ERROR 1030 (HY000): Got error -1 from storage engine" I have dumped and reloaded the tables but the problem persists. CHECK TABLE does not indicate an error. I stopped and r

Re: Alias a function result?

Felix Geerinckx wrote: [EMAIL PROTECTED] ("Jerry Schwartz") wrote in news:[EMAIL PROTECTED]: SELECT book_author, GROUP_CONCAT(book_title) AS book_title GROUP BY book_author WHERE book_title LIKE ""; This actually seems to work, but it makes me ill to look at it. I doubt this works

MySQL5 becomes so slowly when bin log is open

MySQL5 becomes so slowly when bin log is open. I used sysbench to test mysql. MySQL version is mysql-standard-5.0.27-linux-i686-icc-glibc23.tar.gz OS is RHEL 4.0 my.cnf is : [mysqld] #log-bin=icc max_connections=3000 innodb_log_file_size=50M max_prepared_stmt_count=32765 #log=Buddha.log query_c

Re: Alias a function result?

[EMAIL PROTECTED] ("Jerry Schwartz") wrote in news:[EMAIL PROTECTED]: > SELECT book_author, GROUP_CONCAT(book_title) AS book_title GROUP BY > book_author WHERE book_title LIKE ""; > > This actually seems to work, but it makes me ill to look at it. I doubt this works: there is no FROM clause,