MySQL Forums
Forum List  »  MyISAM

Re: Memory Problem with 1 DB. Other DB ok
Posted by: Gabriel Dunn
Date: January 25, 2015 11:26AM

A Linked Server uses ODBC to connect from Microsoft SQL Server to a variety of other platforms, in my case a Linux based MySQL database.

This process was working for a week, and still works for small datasets. And sometimes for the full set if queried from a different MySQL database... but not always.

The table has about 450,000 rows.

The query I am running only selects the ID column, not all the columns. I want to load it into a temporary MSSQL table, stored in MSSQL memory. Then I compare the temp table in MSSQL against the primary member table in MSSQL. Any records in MSSQL, but not in the temp table from MySQL, are then inserted into MySQL via the linked server again.


The table structure is:

CREATE TABLE `wp_users` (
`ID` bigint(20) unsigned NOT NULL,
`user_login` varchar(60) NOT NULL default '',
`user_pass` varchar(64) NOT NULL default '',
`user_nicename` varchar(50) NOT NULL default '',
`user_email` varchar(100) NOT NULL default '',
`user_url` varchar(100) NOT NULL default '',
`user_registered` datetime NOT NULL default '0000-00-00 00:00:00',
`user_activation_key` varchar(60) NOT NULL default '',
`user_status` int(11) NOT NULL default '0',
`display_name` varchar(250) NOT NULL default '',
PRIMARY KEY (`ID`),
KEY `user_login_key` (`user_login`),
KEY `user_nicename` (`user_nicename`),
KEY `ID_Desc` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Options: ReplyQuote


Subject
Views
Written By
Posted
2991
January 22, 2015 11:15PM
Re: Memory Problem with 1 DB. Other DB ok
1531
January 25, 2015 11:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.