Re: Problem with query

Naz, That query logic runs without a error on the server I have to hand (5.0.37), but it has three issues: (i) unless there is an exceptionless 1:1 relationship between group_post_mod_option.option_id and group_post_mod_option.option_name, results for the latter column will be meaningless be

Re: #1017 - Can't find file: './support/orderpc.frm' (errno: 13)

Thanks Mike. Thanks Mike. Don't know why the permissions were read only all of a sudden but that was the problem. Haig Mike Zupan wrote: [EMAIL PROTECTED] ~]# perror 13 OS error code 13: Permission denied check permissions that it is read/write for the mysql user On 9/14/07, Haig Dedeyan

Re: What is up with = and trailing spaces?

At 7:00 PM -0700 9/14/07, Daevid Vincent wrote: From: Matt Gordon Sent: Friday, September 14, 2007 6:37 PM To: Daevid Vincent Subject: Trailing space thing to post to mysql list I searched Google and didn't find anything obvious. Here is minimal SQL to repro

Re: #1017 - Can't find file: './support/orderpc.frm' (errno: 13)

[EMAIL PROTECTED] ~]# perror 13 OS error code 13: Permission denied check permissions that it is read/write for the mysql user On 9/14/07, Haig Dedeyan <[EMAIL PROTECTED]> wrote: > > Hi everyone, > > all of a sudden today, I keep getting the error mentioned in the subject > when I open the dbas

What is up with = and trailing spaces?

From: Matt Gordon Sent: Friday, September 14, 2007 6:37 PM To: Daevid Vincent Subject: Trailing space thing to post to mysql list I searched Google and didn't find anything obvious. Here is minimal SQL to reproduce the problem. # # Running mysql 5.0.41 #

#1017 - Can't find file: './support/orderpc.frm' (errno: 13)

Hi everyone, all of a sudden today, I keep getting the error mentioned in the subject when I open the dbase in phpmyadmin.. I have a dbase with 14 tables. When I open it in phpmyadmin, it will list all the tables until it reaches the table "orderpc" and then stops right there. I went into

Problem with query

I am running this query: SELECT group_post_mod_option.option_id, group_post_mod_option.option_name, COUNT(group_post_moderation.group_post_moderation_option) AS count FROM group_post_mod_option LEFT OUTER JOIN group_post_moderation ON (group_post_mod_option.option_id =

Re: Performance Problems With JOINS - Tunnng required or upgrade hardware?

Hi, Your English is fine :) Your queries don't look too bad. It could be there are no good indexes. Have you tried running EXPLAIN on them? What version of MySQL are you using? You can also try profiling the queries (by hand with SHOW STATUS, or more easily with MySQL Query Profiler) to s

query kills mysqld

MySQL Ver 8.41 Distrib 5.0.27 Intel Xeon 3.60 GHz 2.0 G of RAM Windows Server 2003 Service Pack 1 The following query will sometimes work and sometimes fail. When it fails it kills the mysqld service and requires it to be restarted. Sometimes if I add additional id's to t

Re: trouble selecting DB

At 12:26 PM -0400 9/14/07, Martin Gainty wrote: Morning All- I connect to Mysql 4.0.13 using mysql_connect AND returned handle is not false then I call access to mysql_select_db which always returns NULL and causes Exception I also tried mysql_connect with supplied 4th param as DB with no jo

RE: [mysql] duplicating lines

Thank you Jay and Baron for your help. This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who

Re: The current version is 5.0.48, no?

Jim wrote: Can these be legally run without a license? They ARE licensed: under the GPL. http://www.gnu.org/copyleft/gpl.html Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: The current version is 5.0.48, no?

Can these be legally run without a license? Is the only difference that MySQL AB doesn't publish links to the current version on their web page, instead purposely choosing to leave the community version several revisions behind? Yeah, I'm a little confused. - Original Message - Fro

Performance Problems With JOINS - Tunnng required or upgrade hardware?

Hi all, First sorry my bad english :) I having a problem with a large join with 10 tables with 70Gb of text data, some joins executed by index but some others not. I´m work with HP SERVER (Proliant NL-150) a 2 Xeon 2 Duo with 3Gb Ram and RAID 0. When executed to a client with small datasets the

Re: [mysql] duplicating lines

I think you want to use a GROUP BY query. Try this article: http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/ Baron Weston, Craig (OFT) wrote: Hi, I have narrowed the query - I just want to return the FIRST instance of each ticket, ie the Source. Here i

trouble selecting DB

Morning All- I connect to Mysql 4.0.13 using mysql_connect AND returned handle is not false then I call access to mysql_select_db which always returns NULL and causes Exception I also tried mysql_connect with supplied 4th param as DB with no joy The DB name is uppercase..does this matter?

Re: Conflicting server IDs on slaves

Jeremy, We observed thousands of errors in the logs of one of our slave servers suggesting that it was making repeated failed connections to our master. Example: 070905 20:15:21 [Note] Slave: received end packet from server, apparent master shutdown: 070905 20:15:21 [Note] Slave I/O thre

trouble sending mail to [EMAIL PROTECTED]

Has anyone else been having problems sending mail to mysql- [EMAIL PROTECTED] I tried it with two mail accounts (one at work and also GMail) I get this as a response...for some reason it doesn't seem to be getting to the list at all. The mail servers are somehow taking that address and tu

RE: [mysql] duplicating lines

Hi, I have narrowed the query - I just want to return the FIRST instance of each ticket, ie the Source. Here is the table: CREATE TABLE `Thedata1` ( `Source` varchar(15) collate latin1_general_ci NOT NULL default '', `Close_Time` datetime NOT NULL default '-00-00 00:00:00', `start_Time`

Re: REVOKE ERROR

Krishna Chandra Prajapati wrote: Hi All, I have create a user on server 192.168.1.10 by the command below. grant all on test .* to 'test'@'192.168.1.%' identified by 'test'; flush privileges; after fewday i don't want the user to access the test database. So i have given a revoke command as be

Re: query using connected username

Peter Teunissen wrote: Hi All, I'd like to restrict queries using the username of the user that issued the query. I know about the available user restrictions in the database, but they seem limited to whole tables and columns. What I need is limiting the access on row level. If I can access

REVOKE ERROR

Hi All, I have create a user on server 192.168.1.10 by the command below. grant all on test .* to 'test'@'192.168.1.%' identified by 'test'; flush privileges; after fewday i don't want the user to access the test database. So i have given a revoke command as below mysql> revoke all privileges on

Re: adress stored as an array

Ross Hulford wrote: Hi, I have an address stored as a serialized array address[0] = "my street"; address[1] = "Edinburgh"; address[2] = "Scotland"; This is what I have. I want if it is possible to extract all the UNIQUE towns from my database. This is what the on of the entires looks like i

query using connected username

Hi All, I'd like to restrict queries using the username of the user that issued the query. I know about the available user restrictions in the database, but they seem limited to whole tables and columns. What I need is limiting the access on row level. If I can access the username, I'd b

adress stored as an array

Hi, I have an address stored as a serialized array address[0] = "my street"; address[1] = "Edinburgh"; address[2] = "Scotland"; This is what I have. I want if it is possible to extract all the UNIQUE towns from my database. This is what the on of the entires looks like in my database. a:7:{

Re: DIAGNOSTIC MYSQL

Krishna Chandra Prajapati wrote: Hi Bullington, MySQL Monitering Service is a paid one. There is any open source free software which can moniter mysql heaths and tells the changes need to be done on system variables. You get what you pay for. Try mysqlreport, nagios, and innotop. Baron --

Re: excessive time spent in "statistics" status

On Fri, 14 Sep 2007, Jeremy Cole wrote: > Just to correct a point here... if a query uses only LEFT JOIN or RIGHT JOIN, > the join order is fixed by the query's order itself, so using STRAIGHT_JOIN > should have no effect whatsoever. Equally important, since the join order is but experimentally

Re: DIAGNOSTIC MYSQL

Hi Krishna, No, nothing like what you're asking for exists free or open source. Look into Groundwork and Nagios, though they will not do any really fancy monitoring directly out of the box, with a bit of configuration you can get most of what you want. Regards, Jeremy Krishna Chandra Praja

Re: excessive time spent in "statistics" status

Hi Shawn, Lucio, SELECT STRAIGHT_JOIN FROM ... LEFT JOIN ... WHERE ... ... Just to correct a point here... if a query uses only LEFT JOIN or RIGHT JOIN, the join order is fixed by the query's order itself, so using STRAIGHT_JOIN should have no effect whatsoever. Equally important, sin

Re: Is bad hardware confusing MySQL and InnoDB?

Hi Maurice, You say the MySQL data wasn't on the stuck volume, but were the InnoDB logs? What is the disk configuration? It sounds to me like bad hardware/software, which, unfortunately MySQL and InnoDB cannot protect you from... Regards, Jeremy Maurice Volaski wrote: Some processes on a s

Re: The current version is 5.0.48, no?

Hi Maurice, Yep, it's very very confusing these days. Unfortunately for all of us, MySQL's sales organization seems happy with the situation. Blame them. And, yes, you're correct, compared to MySQL Enterprise, 5.0.45 is indeed out of date now. The releases are sequential, but the community

Re: Conflicting server IDs on slaves

Hi David, This sounds strange, and should NOT occur because of a server_id conflict. Regards, Jeremy David Schneider-Joseph wrote: Thank you. We had a situation recently where two slaves had a conflicting server ID for several minutes, and shortly thereafter the master started reporting