This is intended behaviour.Any hints?
Yes, it works for 1.6 final.Manual update (for MP 1.6 pre). I think it also works in MP 1.6.
It is not hard:But where I get MySQL 5.6? I found the MySQL download site, but I am not sure wich file has to be installed.
I can't tell you if the full installer is equivalent. I would recommend the first option. It is not as hard as you seem to think it is.Full installer (for MP 1.5). This is to be applied on MP 1.5 and then upgrade to MP 1.6.
Are both procedures equivalent and will make MP 1.6 working in the same way? If this is the case, I will use second one.
It is not hard:
http://dev.mysql.com/downloads/mysql/
Scroll to the bottom of the page.
Select platform "Microsoft Windows".
Click the link for x86/32 bit if you're using a 32 bit version of Windows. Otherwise click the x86/64 bit link.
Yep, I would also bet they will be in MyISAM format because he didn't update to MP 1.6 first as instructed. Also, the "server only" option is possibly not the best choice for MySQL on an HTPC. From memory I think "server-only" means that MySQL will behave as if it is the primary application. That means it will consume all the memory, optimise for lots of connections etc. etc. etc.I'm curious. Are your database tables now in InnoDB format? I would bet they are still all MyISAM.
Following the steps at http://wiki.team-mediaportal.com/1_..._Tool)/Update_to_MySQL_5.6#Useful_information, I do have InnoDB.I'm curious. Are your database tables now in InnoDB format? I would bet they are still all MyISAM.
Also, the "server only" option is possibly not the best choice for MySQL on an HTPC. From memory I think "server-only" means that MySQL will behave as if it is the primary application. That means it will consume all the memory, optimise for lots of connections etc. etc. etc.
Default will be set as InnoDB for MySQL 5.6. AFAIK the same was true for MySQL 5.1. However, that doesn't mean that the tables themselves will be in InnoDB format. Before MP 1.6, we explicitly set the table format to MyISAM.Following the steps at http://wiki.team-mediaportal.com/1_..._Tool)/Update_to_MySQL_5.6#Useful_information, I do have InnoDB.I'm curious. Are your database tables now in InnoDB format? I would bet they are still all MyISAM.
CREATE TABLE "Card" (
"idCard" int(11) NOT NULL auto_increment,
"devicePath" varchar(2000) NOT NULL,
"name" varchar(200) NOT NULL,
"priority" int(11) NOT NULL,
"grabEPG" bit(1) NOT NULL,
"lastEpgGrab" datetime NOT NULL,
"recordingFolder" varchar(256) NOT NULL,
"idServer" int(11) NOT NULL,
"enabled" bit(1) NOT NULL,
"camType" int(11) NOT NULL,
"timeshiftingFolder" varchar(256) NOT NULL,
"recordingFormat" int(11) NOT NULL,
"decryptLimit" int(11) NOT NULL,
PRIMARY KEY ("idCard"),
KEY "FK_Card_Server" ("idServer")
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE "Card" (
"idCard" int(11) NOT NULL auto_increment,
"devicePath" varchar(2000) NOT NULL,
"name" varchar(200) NOT NULL,
"priority" int(11) NOT NULL,
"grabEPG" bit(1) NOT NULL,
"lastEpgGrab" datetime NOT NULL,
"recordingFolder" varchar(255) NOT NULL,
"idServer" int(11) NOT NULL,
"enabled" bit(1) NOT NULL,
"camType" int(11) NOT NULL,
"timeshiftingFolder" varchar(255) NOT NULL,
"recordingFormat" int(11) NOT NULL,
"decryptLimit" int(11) NOT NULL,
PRIMARY KEY ("idCard"),
KEY "FK_Card_Server" ("idServer")
) ENGINE=INNODB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
Okay. I was thinking of the config type you mentioned below. In any case: I suggest you read the MySQL documentation if you want to customise.Unfortunately, I could not find any information for the choice. First, I tried type 'Developer default', but I noticed that this installed: MySQL Server, Workbench, Visual Studio Plugin, Connectors, examples, tutorials and documentation. So in the second try, I decided to try just the 'Server' (it says that it should be used where you want a MySQL server but will not be developing applications)...
It is completely personal choice. There is no "best for MP"; it is "best for you". Therefore, again I recommend that if you want to customise, you should read the MySQL documentation.With regards to memory and so, after installation it asks for config type:
I do not know nothing about different options of MySQL, and maybe, the developers of MP 1.6 installation could explain which is the best option to be installed and configured.
- Development machine (default option, and the one used by me): A minimal amount of memory will be used by MySQL
- Server machine: medium memory usage
- Dedicated machine: MySQL will make use of all available memory.
The ideal MySQL Server configuration depends on your intended use, as explained in the next window. Choose the description that most closely applies to your machine.