Re: Failed to setup SSL

2012-11-24 Thread Jackie Zhang
Thanks, Michael. I used the absolute paths but it still does not work. I think the problem is not because of the relative path because the example showed in the manual also uses relative path (see below): shell> *mysqld --ssl-ca=ca-cert.pem \* *--ssl-cert=server-cert.pem \* *--s

Re: Failed to setup SSL

2012-11-24 Thread Michael Dykman
I had noticed that the paths to your certificates were expressed as relative paths. I think at least part of Reindl's recommendation was to express fully qualified paths to your certs and to examined the permissions on those files carefully. SSL is very particular about rejecting security files w

Re: Failed to setup SSL

2012-11-24 Thread Jackie Zhang
Dear Reindl, Thanks a lot for the reply! I tried your scripts (the only difference is the openssl.cnf because I don't have it) Unfortunately, I still failed to start the server with the same message: 121124 17:00:06 [Warning] Failed to setup SSL 121124 17:00:06 [Warning] SSL error: Failed to se

Re: Failed to setup SSL

2012-11-24 Thread Reindl Harald
Am 25.11.2012 00:30, schrieb Jackie Zhang: > Hello everyone, > > I want to setup SSL for mysql server. I followed the manual on > http://dev.mysql.com/doc/refman/5.5/en/ssl-connections.html > > I first generated the certificates and key files by strictly following the > following link, > http:/

Re: Covering Index without the data file (myisam)

2012-11-24 Thread Karen Abgarian
Hello, Well, you have just invented what is known as index organized tables. The MyISAM engine does not implement those. If it did, it would have to deal with quite a few circumstances unique to IOTs. One such circumstance is degradation of efficiency with the increase of record length,

Re: Covering Index without the data file (myisam)

2012-11-24 Thread Eric Bergen
MyISAM can't do this but innodb can. If you change to an innodb table and define your index as the primary key then row data is clustered with the primary key. This means there is no additional storage overhead for the primary key because it is just the row data. This will break down if you define

Re: Covering Index without the data file (myisam)

2012-11-24 Thread Reindl Harald
Am 24.11.2012 22:02, schrieb Hank: > Hello everyone, > > I know this is a longshot, but is there any way to eliminate the MYD > file for a table that has a full covering index? The index is larger > than the datafile, since it contains all the records in the datafile, > plus a second reverse in

Re: Why configuration directives are all case sensitive?

2012-11-24 Thread Tianyin Xu
Hi, Eric, Thanks a lot for the GREAT explanation! This perfectly answers my question. We can close the threads now :-) Best, T On Sat, Nov 24, 2012 at 8:53 AM, Eric Bergen wrote: > Yes, the missing piece of the puzzle is that configuration files are > turned into command line arguments intern

Re: Why configuration directives are all case sensitive?

2012-11-24 Thread Eric Bergen
Yes, the missing piece of the puzzle is that configuration files are turned into command line arguments internally. Programs will parse configuration files and place them at the beginning of the array for command line arguments. They are made case sensitive because they are turned into command line

Which test suites are valid for --extern option in mysql-test-run?

2012-11-24 Thread Tianyin Xu
Hi, all, I wanna test my running MySQL server. According to the README in the "mysql-test" directory, "If you want to use an already running MySQL server for specific tests, use the --extern option to mysql-test-run". For example, mysql-test-run --extern alias But the README also pointed out tha