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 something; This actually seems to work, but it makes me ill to look at it. I doubt this works: there is no FROM

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

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 something; This actually seems to work, but it makes me ill to look at it. I doubt this

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

[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

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

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 something 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

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: 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:

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: 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 COS

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 and

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 will be

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

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

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

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