Arbitrary Boolean Functions as Relational Database Structure?

Hi, I'm implementing a software release database. Users may aribtrarily be members of groups (a many-to-many mapping), and each software release may contain multiple files. I'd like to allow users the maximum flexibility in deciding who may view what software releases. The most obvious approac

Re: MySQL 5 & W2K - SOLVED

Peter Brawley wrote: Amer >I'm having no luck getting MySQL 5 installed under Windows 2000 Professional. >The service does not start, either automatically on bootup, or manually. Reading >through the manual does not address the issue, at least that I could find. From %mysql_home%\bin tr

Re: MySQL 5 & W2K

Peter Brawley wrote: Amer >I'm having no luck getting MySQL 5 installed under Windows 2000 Professional. >The service does not start, either automatically on bootup, or manually. Reading >through the manual does not address the issue, at least that I could find. From %mysql_home%\bin tr

Re: MySQL 5 & W2K

Amer >I'm having no luck getting MySQL 5 installed under Windows 2000 Professional. >The service does not start, either automatically on bootup, or manually. Reading >through the manual does not address the issue, at least that I could find. From %mysql_home%\bin try running it first in a cm

Re: When will partitioning be included in the MySQl stable release ?

I've been running 5.1 for "a while", seing no issues at all, on a production system. Respect! On Fri, June 8, 2007 19:51, Joerg Bruehe wrote: > Hi all ! > > > Michael Dykman wrote: >> It is my understanding that there is no intention of adding partioning >> into the 5.0 release. > > Right. Any GA

MySQL 5 & W2K

I'm having no luck getting MySQL 5 installed under Windows 2000 Professional. The service does not start, either automatically on bootup, or manually. Reading through the manual does not address the issue, at least that I could find. There isn't a previous version on the system - this is a bra

Re: When will partitioning be included in the MySQl stable release ?

Hi Michael, all! Michael Dykman wrote: On 6/8/07, Joerg Bruehe <[EMAIL PROTECTED]> wrote: Hi all ! Michael Dykman wrote: [[...]] >It will be avilable when 5.1 hits relase > status.. it is currently in beta and no official date has been set for > that release. There a

Re: When will partitioning be included in the MySQl stable release ?

Hi all ! Michael Dykman wrote: It is my understanding that there is no intention of adding partioning into the 5.0 release. Right. Any GA release will not get features added, as this would change functional behavior and also introduce the risk of losing stability.

mysqld_safe 100% CPU: how to kill it? On Linux

Hi when I stop mysql server with "sudo /etc/init.d/mysql stop" the "mysqld_safe" process go to 100% of CPU and I must to kill it manually. What's happens? Ho can I stop it without killing? -- Scripts: http://www.spacemarc.it -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: When will partitioning be included in the MySQl stable release ?

On 6/8/07, Joerg Bruehe <[EMAIL PROTECTED]> wrote: Hi all ! Michael Dykman wrote: > It is my understanding that there is no intention of adding partioning > into the 5.0 release. Right. Any GA release will not get features added, as this would change functional behavior and also introduce the

Re: When will partitioning be included in the MySQl stable release ?

It is my understanding that there is no intention of adding partioning into the 5.0 release. It will be avilable when 5.1 hits relase status.. it is currently in beta and no official date has been set for that release. There are rumours of course but the MySQL team is keeping that date pretty cl

RE: Select and COUNT

SELECT tableA.*, COUNT(*) AS Tot FROM tableB LEFT OUTER JOIN tableA ON tableA.uid=tableB.uid GROUP BY tableA.uid Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.

SOLVED Re: totaling count column where separate column's record values are alike

I changed it around a bit to count distict requests and dates and group by ip. This did the trick! On 6/8/07, Ally Messi <[EMAIL PROTECTED]> wrote: Can someone please help me with the following: code so far SELECT DISTINCT ip, COUNT(DISTINCT round_to_nearest_five_minutes(date)) as url_hit_cou

Re: Advanced Indexing

On 6/7/07, Cory Robin <[EMAIL PROTECTED]> wrote: The issue I have is that the ratio of queries on old vs. new data is like 1:10. And searches would be MUCH faster if I could force my queries that are looking at current or future data to use an index that ONLY had that information in them..

Re: Select and COUNT

Hi, spacemarc wrote: 2007/6/8, Baron Schwartz <[EMAIL PROTECTED]>: Use a LEFT OUTER JOIN, but reverse it; join from tableA to tableB. You may be looking for a FULL OUTER JOIN, I'm not sure. MySQL doesn't support that, but see: http://www.xaprb.com/blog/2006/05/26/how-to-write-full-outer-joi

Rewriting replica db

Hi, I set up a slave server, replicating one db on the master MySQL server. No problems with that. I would also like, anyway, to backup the "mysql" database from the master server, changing its name to something like mysql-master. I tried with these instructions in my.cnf: replicate-do-db

Re: repairing/verifying tables

Hi, Octavian Rasnita wrote: Hi, Is there a way of checking which of the tables of a database have errors without checking each table separately? Try mysqlcheck. I believe it lets you do all tables in all databases, and lets you do things like repair if there is an error. Baron -- MySQL

repairing/verifying tables

Hi, Is there a way of checking which of the tables of a database have errors without checking each table separately? Thanks. Octavian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Shape Command

Hello, Does anyone knows if MySQL supports ADO´s "shape" command ??? Guillermo

totaling count column where separate column's record values are alike

Can someone please help me with the following: code so far SELECT DISTINCT ip, COUNT(DISTINCT round_to_nearest_five_minutes(date)) as url_hit_count, request from logs_empty GROUP BY substring_index(request, '/', 3) ; I would like to add on to the the code an additional column that adds up the

Re: MYSQL data replication

Hello, Hmmm, I just reread your post and noticed the requirement of 50-60 slaves hanging off a single master. DRBD would NOT be the right solution here. -- Jimmy Jimmy Guerrero wrote: Hello, Although you state that there is no requirement for near real time synchronization, an alternative

Re: MYSQL data replication

Hi sol, sol beach wrote: I have limited experience with MYSQL replication; which is why I am hoping others with more experience can answer a question or two. Let's say I have a MASTER MYSQL database. Let's say there are 50 - 60 other systems where I'd like to have MYSQL running on these "slave"

Re: MYSQL data replication

Hello, Although you state that there is no requirement for near real time synchronization, an alternative might be to look into DRBD. Which if you are not familiar with, is block-level replication. See: http://www.mysql.com/products/enterprise/drbd.html Combining DRBD with Linux Heartbeat al

Re: Advanced Indexing

Hi Cory, Cory Robin wrote: Is there a way to only include certain matching conditions in indexes? Example if I have a row I want to index that is mysql dates (2007-06-07) and I only want to include CURRENT and FUTURE dates in the index and ignore any past dates. Is that possible at all? The

Re: String Locks

Hi Michael, Michael Dykman wrote: I saw mention of something called string locks in an earlier thread, yet I see nothing like it in the mysql documentation. Could somebody please point me at a reference? It is the function GET_LOCK() you want: http://dev.mysql.com/doc/en/miscellaneous-functi

Re: Select and COUNT

Hi spacemarc, spacemarc wrote: Hi all, I have this query: SELECT tableA.*, COUNT(*) AS Tot FROM tableB LEFT JOIN tableA ON tableA.uid=tableB.uid GROUP BY tableA.uid This query shows only the users (tableA) that are in tableB with at least 1 record (like total) but not the users that have 0 rec

Add column from another table

I would like to add a column to a table where the column to be added is in another table. The column entries are to be matched using a particular column from each table. I have one table detailing phone calls, indexed by CallID. I have created another table with the same index and a column C

Re: Alternative command of SET GLOBAL SQL_SLAVE_SKIP_COUNTER

Hi, We have some options in order to skip type of errors in the replication process. Please, identify your number error in slave machine and put into my.cnf "slave_skip_errors= 1087" for example, where 1087 is a recurrent error for your replication architecture. Regards, Juan On 6/8/07, Asho

Re: only select privilege

Thanks Jon. regards anandkl On 6/8/07, Jon Ribbens <[EMAIL PROTECTED]> wrote: On Fri, Jun 08, 2007 at 04:25:00PM +0530, Ananda Kumar wrote: >So, what ever i did is right? Yes. User 'ab' can SELECT on all tables in database 'abc'. -- MySQL General Mailing List For list archives: http://l

Re: only select privilege

On Fri, Jun 08, 2007 at 04:25:00PM +0530, Ananda Kumar wrote: >So, what ever i did is right? Yes. User 'ab' can SELECT on all tables in database 'abc'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: only select privilege

Hi Juan, Do you me "all table in database abc". Please confirm. Is it a typo or something else. regards anandkl On 6/8/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote: Hi, Try to do that : GRANT SELECT ON abc.* to 'qa'@'%' identified by 'qa'; flush privileges; Explain : The user qa hav

Re: only select privilege

Hi, Try to do that : GRANT SELECT ON abc.* to 'qa'@'%' identified by 'qa'; flush privileges; Explain : The user qa have access of all tables of user abc. In this command, only SELECT is possible is you connect using user qa. Regards, Juan On 6/8/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:

Re: only select privilege

Hi Jon, So, what ever i did is right? please let me know. regards anandkl On 6/8/07, Jon Ribbens <[EMAIL PROTECTED]> wrote: On Fri, Jun 08, 2007 at 03:14:18PM +0530, Ananda Kumar wrote: > How do i give only select privilege to a specific database. > > GRANT SELECT ON abc.* to 'ab'@'%' identi

Re: only select privilege

On Fri, Jun 08, 2007 at 03:14:18PM +0530, Ananda Kumar wrote: > How do i give only select privilege to a specific database. > > GRANT SELECT ON abc.* to 'ab'@'%' identified by 'ab'; Like that. > mysql> select select_priv from user where user='qa'; > +-+ > | select_priv | > +-

Alternative command of SET GLOBAL SQL_SLAVE_SKIP_COUNTER

Hi List, I want to know the alternative command of "SET GLOBAL SQL_SLAVE_SKIP_COUNTER" OR How i skip the counter of Relay Log Position. Thanks Ashok -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

only select privilege

How do i give only select privilege to a specific database. I did this GRANT SELECT ON abc.* to 'ab'@'%' identified by 'ab'; FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> select select_priv from user where user='qa'; +-+ | select_priv | +-+ | N

Select and COUNT

Hi all, I have this query: SELECT tableA.*, COUNT(*) AS Tot FROM tableB LEFT JOIN tableA ON tableA.uid=tableB.uid GROUP BY tableA.uid This query shows only the users (tableA) that are in tableB with at least 1 record (like total) but not the users that have 0 record. How can I obtain all users,

RE: Administrative Tools

> Check out http://www.sqlmanager.net/en/products/mysql > http://www.sqlmanager.net/en/products/mysql > > AndrewMcHorney wrote: > > > > Hello > > > > I am looking for the tools that I would use to be able to do > > administrative duties and to be able to create and update databases > > (table