Forum Replies Created
-
AuthorPosts
-
NeshiMember
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 🙄 🙁 🙄 🙁 🙄 🙁
NeshiMemberRitesh, 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!
NeshiMemberYes, they have indexes!
I really have no idea where the problem is!
I will check the InnoDB homepage!!!
Thank you!
NeshiMemberHELLO?!?!?
🙁 😀
NeshiMemberOkay, 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!
NeshiMemberI am using InnoDB tables!!!! So where is the problem?!
NeshiMemberIt is working now!!!
Thanks for your help!
But now I have another problem… but therefore I have to create a new topic….
NeshiMemberNo, the value for innodb is disabled!!!! It seems as if it's ignoring the my.cnf (were I have the innodb info) completely!
NeshiMemberI am using win 2000 at home and at work win nt!
Do you think there could be the problem?!
Please help!
NeshiMemberIt is not working ….
Yesterday I changed the my.ini file at my computer at home and there it is working… Today I changed the my.ini file at work – but still innoDB table is disabled.
What is wrong here?!?! Do you have any idea???
The my.ini looks like this now:
[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-max-nt.exe
[mysqld]
mysqld-max-nt
basedir=c:/mysql/ibdata
innodb_data_file_path=ibdata1:30M:autoextend
innodb_data_home_dir=c:/mysql/ibdata
Do you need any more information? Can I send you a screenshot of my winmysqladmin (the part where you can see the information about my environment?
It is so urgent…..
NeshiMemberI think it is working !!! 🙂 🙂 🙂
But now I have the next problem: where are the tables?! I can't find them!
The folder ibdata is empty…
Thank you for your help!
NeshiMemberHello!
Here you get the contenct of the my.ini file:
[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-max-nt.exe
[mysqld]
innodb_data_file_path = ibdata1:10M:autoextend
set-variable = innodb_buffer_pool_size=70M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_log_file_size=20M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
So, I hope this will bring us forward….
Thank you a lot!!!
NeshiMemberHello!
I have the correct MySQL server and I also changed the my.ini…..
But it is still not working!
Do you have any ideas how to enable the innoDB in this case?!
Thanks so much!
-
AuthorPosts