ANN: Database Designer for MySQL 2.1.0 Beta available!

2013-07-22 Thread Aleksander Andreev
This release does not introduce any new functionality. A huge amount of internal and architecture tasks were done instead. New compiler version used as well as new exception tracer implemented. Some little changes, not worthy of mention, are also present. There are two new major features in

uncertain future of Oracle MySQL exams [1Z0-871, 1Z0-872, 1Z0-873, 1Z0-874]

2013-07-22 Thread Lukas Lehner
Hi I am now responsible for LAMP applications. I worked previously with Oracle 11g. It seems that those exams are an easy win for me. I guess my preparation effort is about 60 hours. 1Z0-871 MySQL 5 Developer Certified Professional Exam, Part I 1Z0-872 MySQL 5 Developer Certified Professional

InnoDB problem.

2013-07-22 Thread Luis H. Forchesatto
Greetings. I've restored an MySQL backup from our MySQL server into another server. The backup includes InnoDB tables. After the import, MySQL recognized the innodb tables fine but when I try to do a check table ir returns that the table doesn't exists. Permission and owner of the table files

Re: InnoDB problem.

2013-07-22 Thread Johan De Meersman
- Original Message - From: Luis H. Forchesatto luisforchesa...@gmail.com Subject: InnoDB problem. Permission and owner of the table files (.frm files) are ok, since it recognizes MyISAM tables (they have the same permission). Oops. You should always read the fine manual. You took

Re: uncertain future of Oracle MySQL exams [1Z0-871, 1Z0-872, 1Z0-873, 1Z0-874]

2013-07-22 Thread shawn green
Hello Lukas, On 7/22/2013 8:16 AM, Lukas Lehner wrote: Hi I am now responsible for LAMP applications. I worked previously with Oracle 11g. It seems that those exams are an easy win for me. I guess my preparation effort is about 60 hours. 1Z0-871 MySQL 5 Developer Certified Professional Exam,

RE: Mysql cache issues???

2013-07-22 Thread Rick James
For most, not all, production servers, these two are the 'right' settings: query_cache_type = OFF query_cache_size = 0 Both are needed to avoid some code paths from being unnecessarily followed. (Maybe someday, that will be fixed, too.) I recommend only 50M as the max for _size. Here are

RE: Mysql cache issues???

2013-07-22 Thread Johan De Meersman
And for most, not all, of /my/ production servers since pretty much ever, the right setting has been on. Again, please don't generalize based off your own usecase. I have no idea what the whole world is doing with their servers. Rick James rja...@yahoo-inc.com wrote: For most, not all,