LAMP Experts Needed

I am looking for some serious coders that want to make a name for themselves and/or a lot of money. I need to talk to any one who is considered an Expert with any of these: Linux Apache MySQL or PostgreSQL PHP, Perl, Python HTML CSS XML XSL I am going to convince my employer to replace a very

Re: Insane execution time for JOIN query

On 8/31/06, Harrison Fisk <[EMAIL PROTECTED]> wrote: Hello, On Aug 31, 2006, at 5:12 AM, Kim Christensen wrote: > Hey list; > > I posted this message under an earlier thread which touched the same > subject - but I realized my case could be slightly different, thus > posting a new thread here.

Re: mysql_upgrade script problems on MySQL 5.0.24

error: Found option without preceding group in config file: /u07/mysql/data/upgrade_defaults at line: 2 Fatal error in defaults handling. Program aborted This is your problem. What's in that file (/u07/mysql/data/upgrade_defaults) ? -- MySQL General Mailing List For list archives: http://li

Re: limit clause on join results

Yup that works for me too. Thanks. On Aug 31, 2006, at 9:12 AM, Brent Baisley wrote: How about something like this: select * from states, cities, (select id from state limit 2) as stlimit where states.id = cities.state and state.id=stlimit.id I tried it in 4.1 and it works. - Original M

Re: www/dev.mysql.com?

Ashley M. Kirchner wrote: >Anyone else having trouble getting to either sites? We have been experiencing an intermittent and inconsistent routing problem with one of our ISPs. We use round-robin DNS and at this point we may need to simply drop that ISP from the mix until we can isolate the

www/dev.mysql.com?

Anyone else having trouble getting to either sites? -- W | It's not a bug - it's an undocumented feature. + Ashley M. Kirchner . 303.442.6410 x130 IT Director / SysAdmin / Websmith

MySQL 5.0.24a has been released

Hi, MySQL 5.0.24a, a new version of the popular Open Source Database Management System, has been released. This is a minor release to fix a few bugs, and a possible security flaw. The Community Edition is now available in source and binary form for a number of platforms from our download pages at:

Re: Group By question

select * from t where emailaddress in (select emailaddress from t group by emailaddress having count(*) > 1) order by emailaddress; Thanks, Michael -Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wed, 30 Aug 2006 5:17 PM Subject: Group By question I have a tab

mysql_upgrade script problems on MySQL 5.0.24

I've upgraded from 5.0.22 to 5.0.24 MySQL Server on Solaris 9 using the Solaris package utility (which means I de-installed 5.0.22 then installed 5.0.24 in the same location, environment, configuration). I'm having the following error when trying to execute the mysql_upgrade executable according to

Re: Insane execution time for JOIN query

Hello, On Aug 31, 2006, at 5:12 AM, Kim Christensen wrote: Hey list; I posted this message under an earlier thread which touched the same subject - but I realized my case could be slightly different, thus posting a new thread here. Sorry for any inconvenience. I have two tables, one of which

Re: SOLVED (was: Weird SELECT bug in 5.0.21)

In the last episode (Aug 31), Renald Buter said: > On 12:27 Thu 31 Aug , Duncan Hill wrote: > > On Thursday 31 August 2006 12:21, Renald Buter wrote: > > > The problem is that a simple 1-table query shows different > > > answers depending on whether you select 1 or 2 columns. > > *blush* > >

Re: CentOS 4.3 - MySQL - NIS user issue

In the last episode (Aug 31), Tom Brown said: > All my users are NIS users and they can access this box fine. I have > a MySQL server running on this box that is running fine. The OS > 'root' user can authenticate and use MySQL fine as this is not a NIS > user e.g. > > [EMAIL PROTECTED] mysql -u b

Re: Insane execution time for JOIN query

Kim, The first thing I'd do is run a MyISAMChk on the table to see if the index is damaged. The second thing I'd do is run Optimize on the tables regularly because after a lot of rows have been deleted it leaves holes in the table which slows down table performance. Of course you can

RE: Complex SQL for multiple joins

Something else you may or may not want to consider. You may want to have both users and user-groups be principles. Something like the following: Principle (ID, NAME, PERMS) User (P_ID, PASSWORD, ... ) UserGroup (P_ID, ... ) PrincipleLink (PID, CID) -> Many to Many (parent, child) Also consid

Re: Complex SQL for multiple joins

Also, depending on the number of permissions you are tracking, you could use a single INT field and do bitwise ORing in your application to determine permission checks... Though I usually don't recommend denormalizing the schema, this is one scenario that would potentially make life a bit easier.

Re: Incorrect information in file...

On Thursday, August 31, 2006 at 2:25:07 PM, Mikhail confabulated: > How much do you care about "test" table, Duane? > In your own words: "I do not have anything really set up yet", so drop > the table or even the whole testdb database and see if that helps Sure. That's a quick fix that does

RE: Incorrect information in file...

How much do you care about "test" table, Duane? In your own words: "I do not have anything really set up yet", so drop the table or even the whole testdb database and see if that helps Regards, Mikhail Berman -Original Message- From: Duane Hill [mailto:[EMAIL PROTECTED] Sent: Thursday,

Re: Incorrect information in file...

On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: > Hi Duane, > Have you tried to repair "test" table using "REPAIR" to see if that > solves your problem? That didn't seem to work. The result returned was: mysql> repair table test; +-++--+---

Re: Insane execution time for JOIN query

On 8/31/06, Brent Baisley <[EMAIL PROTECTED]> wrote: hmmm, not sure why it's only scanning 89K records from the products table, I would think it would scan the whole table. It is scanning the entire items table, which I would think it wouldn't do. Well, the query in question actually did do so

Re: Incorrect information in file...

On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: > Hi Duane, > Have you tried to repair "test" table using "REPAIR" to see if that > solves your problem? No I had not. The problem is easily duplicated and I do not have anything really set up yet. I will try that. Thanks.

RE: Incorrect information in file...

Hi Duane, Have you tried to repair "test" table using "REPAIR" to see if that solves your problem? Regards, Mikhail Berman -Original Message- From: Duane Hill [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 9:49 AM To: mysql@lists.mysql.com Subject: Incorrect information in f

Re: Insane execution time for JOIN query

hmmm, not sure why it's only scanning 89K records from the products table, I would think it would scan the whole table. It is scanning the entire items table, which I would think it wouldn't do. How about posting your "SHOW INDEX FROM items" result. Also, what are your memory settings? SHOW VARI

Incorrect information in file...

MySQL v5.0.24 on FreeBSD v6.0-RELEASE I was attempting to do some tweaking in a my.cnf to increase performance on a server here. I had copied the my-huge.cnf config file into /etc and uncommented the section on InnoDB from within. I also changed the thread_concurrency option

Re: Complex SQL for multiple joins

You should be able to do it 1 query, I can think of two ways. I'm not sure which one will run faster. I use table aliasing to keep the lines shorter. The first possibility would have user permissions in one column and group permissions in another: SELECT users.userid,perm_u.permissions,perm_g.p

Re: Insane execution time for JOIN query

On 8/31/06, Brent Baisley <[EMAIL PROTECTED]> wrote: How about posting the results of: EXPLAIN SELECT products LEFT JOIN items ON products.product_id = items.product_id WHERE items.product_id IS NULL; ++-+--+--+---+--+-+--++---

Re: limit clause on join results

How about something like this: select * from states, cities, (select id from state limit 2) as stlimit where states.id = cities.state and state.id=stlimit.id I tried it in 4.1 and it works. - Original Message - From: "Rob Nikander" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 30,

How to name a table based on the contents of a variable?

I'm writing a stored procedure that gets a VARCHAR(45) as a parameter. Inside my stored procedure, I want to create a table with a name based on that parameter. For example, if I do call my_sp('XXX'); I want the stored procedure to create a table named foo_XXX. I don't know how to do this. He

Re: Mass E-mail Options

Good comments, also, there is the option of simply interfacing mysql and your scripts with mailman, which is really one of the better ways to send mass emails, list serves pretty much have it down these days. "mailman"? Not sure what this is. Do you have any web sites where I could research t

Starting Mysql from unix root account with --user=mysql

I have a very simple question about starting mysql. I start manually the server under the unix account "mysql" with the following: /seqweb/mysql4/bin/mysqld_safe --user=mysql & in order to get the unix user "mysql" to run the process. I get the following with "ps -ef | grep mysql": mysql

Re: Mass E-mail Options

An equal probability is that you're actually generating INDIVIDUAL messages (one per recipient), rather than messages with a BCC: recipient list, in which case, my advise would be to switch to BCC: addressing, but if that isn't an option, look at a cascaded MTA queue (messages which don't deliv

Re: Insane execution time for JOIN query

How about posting the results of: EXPLAIN SELECT products LEFT JOIN items ON products.product_id = items.product_id WHERE items.product_id IS NULL; Your query looks fine to me. 6 hours is a very long time for tables that small. Are these MyISAM or InnoDB? - Original Message - From: "Ki

Re: Mass E-mail Options

How many messages are we talking here? Could be as many as 5,000 at one time. Perhaps create a server side script, that sends the emails in chunks, then sleeps a little, and sends another chunk. I hadn't thought of that, I may have to try to write something like this I would also try to un

Re: replication breaks

Hi, Give the command as Reset slave; and then run the change master to script. This will help you to solve. Pooly wrote: Hi, I recently upgrade our master to MySQL 5.0.24. But, I changed on option to log_bin=server-log-bin, as a result the binary log has changed from server-bin.000228 to ser

SOLVED (was: Weird SELECT bug in 5.0.21)

On 12:27 Thu 31 Aug , Duncan Hill wrote: > On Thursday 31 August 2006 12:21, Renald Buter wrote: > > > The problem is that a simple 1-table query shows different answers > > depending on whether you select 1 or 2 columns. *blush* Of course. I see. How stupid. Thanks and sorry to have bother

Re: Weird SELECT bug in 5.0.21

On Thursday 31 August 2006 12:21, Renald Buter wrote: > The problem is that a simple 1-table query shows different answers > depending on whether you select 1 or 2 columns. Relational databases are founded on mathematical set theory. Unless you specify an ORDER BY stanza in your query, the data

Re: Weird SELECT bug in 5.0.21

On 11:34 Thu 31 Aug , Renato Golin wrote: > Renald Buter wrote: > >Odd, eh? But what's worse, the JOIN between this column and other > >columns *also* uses this truncated values and the result is bogus. > > I wouldn't say odd, as you didn't specified any order I wouldn't rely on > the order o

Re: Weird SELECT bug in 5.0.21

Renald Buter wrote: Odd, eh? But what's worse, the JOIN between this column and other columns *also* uses this truncated values and the result is bogus. I wouldn't say odd, as you didn't specified any order I wouldn't rely on the order of the output. Try ordering things for what you want and

Weird SELECT bug in 5.0.21

Hello list, I've found this strange select bug in retrieving rows from a table. I can best illustrate this with an output of two queries: mysql> select id,jn from paper_2001 limit 10; +--+---+ | id | jn| +--+---+ | 19360350 | 6165 | | 19360351 | 6165 | |

Re: How to draw data model diagrams from existing schema?

Matthew Wilson writes: >I've spent the last month building a fairly elaborate database with >lots of foreign keys. >I want to draw a diagram that maps the relationships between all the >tables, but I haven't found any software that can do that. >Does anyone have any suggestions? I want to draw

Insane execution time for JOIN query

Hey list; I posted this message under an earlier thread which touched the same subject - but I realized my case could be slightly different, thus posting a new thread here. Sorry for any inconvenience. I have two tables, one of which is a list over products which all have unique product id's (pr

CentOS 4.3 - MySQL - NIS user issue

Hi I have what i think is a strange issue - All my users are NIS users and they can access this box fine. I have a MySQL server running on this box that is running fine. The OS 'root' user can authenticate and use MySQL fine as this is not a NIS user e.g. [EMAIL PROTECTED] mysql -u bugs -pxx

innodb-safe-binlog

Hi, I want to use --innodb-safe-binlog with mysql, but in the newest Version of Mysql it is obsolet: > Note: --innodb-safe-binlog is not needed in MySQL 5.1, having been made obsolete by > the introduction of XA transaction support in MySQL 5.0. See Section 13.4.7, XA Transactions. but how