Can't manage relationships…

[Neshi]

I can't manage the relationships (foreign keys…).

Do I have to activate something before I start to manage the relationships?

I am getting a list of possible problems, but I have no idea…

Thank you!

[CalEvans]

Relationships are only available on tabletypes that support them. (InnoDB and I believe Gemini)

=C=

[Neshi]

I am using InnoDB tables!!!! So where is the problem?!

[Ritesh]

Quote:

I am using InnoDB tables!!!! So where is the problem?!

Check out the columns which you are using in the relationship have proper indexes created on them.

It would be very helpful if you can tell me the structure of the two tables and the steps you are following to create the index.

[Neshi]

Okay, i try to explain it properly….

I have one table “user”

User has the columns:

-UserID (PrimaryKey)

-WorkshopID (SHOULD BE the foreign key)

-TeamID (should also be a foreign key)

I tried to connect to the Tables “workshop” and “team”

in both tables is an ID (as PrimaryKey obviously) and the name…

So, I hope this helps!!!

Thank you!

[Neshi]

HELLO?!?!?

🙁 😀

[Ritesh]

Quote:

TeamID (should also be a foreign key)

Quote:

WorkshopID (SHOULD BE the foreign key)

The above two fields dont have indexes defined on them? For foreign keys to be defined on columns, those columns should have indexes defined on it.

For more information you can check out the InnoDB docs at InnoDB Homepage

[Neshi]

Yes, they have indexes!

I really have no idea where the problem is!

I will check the InnoDB homepage!!!

Thank you!

[Neshi]

Ritesh, I have an important question:

I want to modify my my.ini with the InnoDB options.

I have 512 MB RAM and lots of space for the tables (there are 200GB free, but of course I won't use them…).

What kind of values would do I have to set up for a pretty good performance?

Thanks a lot!

[Neshi]

This is what I have so far:

[mysqld]

datadir=C:/mysql/data

innodb_data_file_path=ibdata1:30M:autoextend

innodb_data_home_dir=C:/mysql/ibdata

set-variable = innodb_buffer_pool_size=80M

set-variable = innodb_additional_mem_pool_size = 20M

set-variable = innodb_log_file_size = 20M

set-variable = innodb_log_buffer_size = 8:

innodb_flush_log_at_trx_commit = 1

Do I need to create a new folder for the logs? And where do I have to create it if I have to???

Oh, there are so many questions 🙄 🙁 🙄 🙁 🙄 🙁

[Ritesh]

The .inf seems OK.

You need to create the iblogs directory manually and give the information in my.inf

[Neshi]

where do I have to create the log directory???

On C: or on C:mysql or somewhere else???

[Neshi]

innodb_log_file_path = C:/mysql/log

is this okay?

[Neshi]

okay done!

Thank you so much!

are there any more values/options I should in put in my.ini?

[Ritesh]

Quote:

where do I have to create the log directory???

Create c:mysqliblogs

[Neshi]

I forgot: It is still not possible to manage the relationships.

[Neshi]

Ritesh, it is not working with those options:

[mysqld]

datadir=C:/mysql/data

innodb_data_file_path=ibdata1:30M:autoextend

innodb_data_home_dir=C:/mysql/ibdata

default-table-type = innodb

innodb_log_file_path = C:/mysql/iblogs

set-variable = innodb_buffer_pool_size=80M

set-variable = innodb_additional_mem_pool_size = 20M

set-variable = innodb_log_file_size = 20M

set-variable = innodb_log_buffer_size = 8:

innodb_flush_log_at_trx_commit = 1

I can't connect to MySQL and it ist not possible to start the MySQL manually!!!

I tried this:

[mysqld]

datadir=C:/mysql/data

innodb_data_file_path=ibdata1:30M:autoextend

innodb_data_home_dir=C:/mysql/ibdata

#default-table-type = innodb

#innodb_log_file_path = C:/mysql/iblogs

#set-variable = innodb_buffer_pool_size=80M

#set-variable = innodb_additional_mem_pool_size = 20M

#set-variable = innodb_log_file_size = 20M

#set-variable = innodb_log_buffer_size = 8:

#innodb_flush_log_at_trx_commit = 1

and it is working!? So there must be a problem?!

[Ritesh]

There seems to be some other problem. The same configuration works perfectly for me. Probably you have missed out something. Please read the InnoDB docs. I am sure that will help you more then I can 🙂

[Neshi]

Well, this is excactly what they write on the innodb homepage!!!!!!!

[Author]

Posts