upgrade from 5.1 to 8.0 one program won't start

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

troubleshooting

Post Body

So, many years ago I wrote a suite of mfc applications that used ODBC to connect to a mysql database. We're currently trying to upgrade to a new server and a new version of mysql. The upgrade has gone fine apart from one of the applications won't start and a couple just explode with no warning.

Apart from the database change I was forced to change the ODBC driver from 5.1 to 8.0 as well.

The DB itself is pretty massive with one table with 100M records.

My gut feeling is that there probably a setting in the DB that I can tweek to stop this happening but I don't have enough knowledge to know where to start.

I've upped the innodb_buffer_pool_size to 5G to no avail.

Any ideas would be greatly appreciated.

Author

Account Strength

70%

Account Age

3 years

Verified Email

Yes

Verified Flair

Total Karma

1,209

Link Karma

Comment Karma

1,135

Profile updated: 1 week ago

Posts updated: 1 year ago

tom_p_legend

Subreddit

r/mysql

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 3 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/mysql/comme...