LocK Manager in MySql

[Parag Agrawal]

Hi, 
   I am a Computer Science student here at IIIT hybd and our team is
going to implement a speculative lock manager in MySql 4.0 or higher.
   Can someone Plz tell if the mysql code shipped with FC2 has Two
Phase Locking? or does any other version has it? or if  any other
commercial version has it and what might be the cost.

  I went through the Documentation but couldnt make out if the table
level locking for ISAM , MyISAM tables and page level for BDB tables
and similar stuff is the same as a Two Phase Locks.


-- 
When the going gets tough only the tough gets going

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: counting question

[Parag Agrawal]

Try this out:

select user.name, skill.skill_name, count(user_skill1.skill_id)
 from user , skill, user_skill , user_skill as user_skill1 
 where user.id=user_skill.user_id and user_skill.skill_id=skill.id and
skill.id = user_skill1.skill_id
 order by user.id.

I think this would work.

--
Parag 
B. Tech
IIIT, Hybd

select 

On 7/31/05, Dean Karres <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I have three simple tables:
> 
> user
> {
>   id int PRIMARY
>   name varchar UNIQUE
> }
> 
> skill
> {
>   id int PRIMARY
>   skill_name varchar UNIQUE
> }
> 
> user_skill
> {
>   user_id int
>   skill_id int
>   UNIQUE KEY id (user_id, skill_id)
> }
> 
> Each user can have zero or more associated skills.  So you might have
> these associations:
> 
> User_1: Skill_1, Skill_3
> User_2: 
> User_3: Skill_2, Skill_1
> 
> Assuming that is all the users and skills, I would like to produce a
> report that lists each user and then the list of skills each has (if
> any).  Along with each skill I want to print the count of how many times
> this skill has been mapped to a user.  Using the info above then
> something like:
> 
> User_1
> Skill_1 (2)
> Skill_3 (1)
> User_2
> User_3
> Skill_1 (2)
> Skill_2 (1)
> 
> The skill "usage counts" are in parens.  I get that there will prolly be
> a join in order to pick up the fact that User_2 has no listed skills.
> What I'm not sure about is how to get the over all skill counts.  Do I
> need to do the query that returns the user and skill list then go
> through the per user skills and do additional queries to get the skill
> counts?
> 
> help?
> 
> Dean...K...
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


-- 
When the going gets tough only the tough gets going

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL vs XML

[Parag Agrawal]

Hi ,

First of all it should be clear that XML is only a well organised
representation of data a mere text file.
It is not a software . U will have to append entries all by urself to
the file, and marking up suitable tags ( say the attribute of ur
relational table) .
Data will have to be extracted via suitable scripts ( viz php, python,
perl etc)

Database facilitates inthe way that u can access info easily with out
much hues and cries . U can always create a XML representation with
the data stored in ur database with proper scripts thus making ur task
simpler.
So it all depends on the kind of application u want.

-
Parag Agrawal
B. Tech 
IIIT



On 7/30/05, David Blomstrom <[EMAIL PROTECTED]> wrote:
> I've been gathering data for an animal kingdom
> database for quite some time and am now trying to
> figure out how to organize and display it. So far, I
> have a table that lists every order, suborder, family,
> subfamily, genus and species of mammal in a
> child-parent relationship, like this:
> 
> NAME | PARENT
> Carnivora | Mammalia
> Canidae | Carnivora
> Canis | Canidae
> lupus (the wolf) | Canis
> 
> I also broke that table into separate tables listing
> only orders, families, genera, species, etc., which I
> can then display via joins. I haven't yet figured out
> which methid is going to work best.
> 
> I think I'd like to make a content management system,
> possibly modeled after Wikipedia, though I'm also
> looking at the Tree of Life website at
> http://tolweb.org/tree/phylogeny.html
> 
> They use a recursive array technique called Edge
> Representation, which is discussed about halfway down
> this page:
> 
> http://www.phyloinformatics.org/pdf/7.pdf
> 
> Another possible guide is the Animal Diversity Web -
> http://animaldiversity.ummz.umich.edu/site/about/technology/index.html
> - which uses something called Mousetrap and TaxonDB.
> 
> This is all new and very confusing to me. Making
> things even more confusing, I read that XML can be
> used in lieu of databases, and at least one reference
> seems to suggest that it's the superior choice. So,
> before I get in any deeper, I'd like to ask about the
> differences between XML and MySQL. What are the pros
> and cons, and which would be better for an animal
> kingdom database? Or could I use both at the same
> time?
> 
> I'm new to XML, too, but it looks like it might not be
> too complex. But it's hard to envision how this all
> fits together.
> 
> Thanks.
> 
> 
> __
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


-- 
When the going gets tough only the tough gets going

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]