MySQL Connector/ODBC 5.2.2 has been released

Dear MySQL users, MySQL Connector/ODBC 5.2.2, a new version of the ODBC driver for the MySQL database management system, has been released. This is the first GA release for the Connector/ODBC 5.2.x series. Now the available downloads include both a Unicode driver and an ANSI driver based on the

RE: Risks involved in MyISAM to Innodb

(Apologies to the rare bottom-poster.) This contains lots of tips on converting from MyISAM to InnoDB: http://mysql.rjweb.org/doc.php/myisam2innodb Generally, the conversion should go smoothly. > -Original Message- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Friday, Se

RE: Default Values for Max User and Max Connections.

After installing, do SHOW VARIABLES LIKE 'max%'; If you don't like the values, then ad a line to my.cnf (my.ini) and restart. For max_user_connections, I think "0" means "unlimited". > -Original Message- > From: Wayne Leutwyler [mailto:wleut...@columbus.rr.com] > Sent: Friday, Septemb

RE: Partitioning on a Substring of Varchar Column in Mysql

Some statements are incorrect... If you PARTITION on (`x`), then `x` must be included in every UNIQUE key. That includes the PRIMARY KEY. You do not need to PARTITION on the PK. An AUTO_INCREMENT value, say `id` must be the _first_ field in _some_ key. `id` does not have to be UNIQUE, nor do

Re: Risks involved in MyISAM to Innodb

do NOT top-post which makes threads unreadable Am 21.09.2012 15:55, schrieb Girish Talluru: > On Fri, Sep 21, 2012 at 6:44 AM, Reindl Harald > wrote: > Am 21.09.2012 15:26, schrieb Girish Talluru: > > I have requirement to change my production database table

Default Values for Max User and Max Connections.

Hello All, Question. In mysql 5.5 what are the defaults for these values: max_connections = ? (is this set to 151 in 5,5) max_user_connections = ?(is this set to unlimited unless you provide the exact number)? Thank you so much. Wayne Leutwyler, RHCT Open Source + Open M

Re: Risks involved in MyISAM to Innodb

Hi Reindl, I'm sorry if I ask wrong question here? I'm new to this and people before me did the terrible mistake of using myISAM even though they decided to move to Innodb many times. Data grows like hell and now requirements came in where we have to use transactions. At this stage we have to mig

Re: Risks involved in MyISAM to Innodb

On 21/09/2012 9:26 AM, Girish Talluru wrote: Hi Guys, I have requirement to change my production database tables which are using myISAM and now bcoz of some changes we have to move to Innodb. Can anyone suggest how the plan should be and risks involve? Thanks, Girish Talluru Whatafford?

Re: Risks involved in MyISAM to Innodb

Am 21.09.2012 15:26, schrieb Girish Talluru: > I have requirement to change my production database tables which are using > myISAM and now bcoz of some changes we have to move to Innodb. > > Can anyone suggest how the plan should be and risks involve? no because this depends hardly on your data

Risks involved in MyISAM to Innodb

Hi Guys, I have requirement to change my production database tables which are using myISAM and now bcoz of some changes we have to move to Innodb. Can anyone suggest how the plan should be and risks involve? Thanks, Girish Talluru

Re: Partitioning on a Substring of Varchar Column in Mysql

Just update the string needed function substring(id,9,6). On Fri, Sep 21, 2012 at 5:18 PM, Adarsh Sharma wrote: > Hi all, > > I created a partition on a timstamp column ( dt_dtamp ) in mysql-5.1.58 > testing table.But as all of us know that partitioned column need to be > primary key. > I have al

Partitioning on a Substring of Varchar Column in Mysql

Hi all, I created a partition on a timstamp column ( dt_dtamp ) in mysql-5.1.58 testing table.But as all of us know that partitioned column need to be primary key. I have already id column as primary key but my application cann't afford primary key ('id','dt_stamp') in a table. I thought & tried