# Row Size greater than 64kb in MySQL

#### **Issue Description:** <a href="#rowsizegreaterthan64kbinmysql-issuedescription" id="rowsizegreaterthan64kbinmysql-issuedescription"></a>

Row size limit for mysql table is 64kb. While replicating Salesforce into MySQL table, if the row size is more than 64 kb, replication process is impacted. In such cases, it is required to replicate those objects into multiple tables by splitting the object fields into different tables. This section describes the process of replicating such objects into multiple tables with an example.&#x20;

#### **Solution:** <a href="#rowsizegreaterthan64kbinmysql-solution" id="rowsizegreaterthan64kbinmysql-solution"></a>

* While replicating Salesforce into mysql database using DBSync Replication, if the row size exceeds 64 kb, replication process stops and the logs will display an error as shown below.

*Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs.*

* Identify the Salesforce object which has row size greater than 64kb. These objects wouldn't have replicated into database when the row of size is greater than 64kb.
* If accounts object has row size greater than 64kb, we need to replicate this accounts object into two different tables for example sf1\_accounts & sf2\_accounts. This can be done by creating a new profile in DBSync replication and running replication on both the profiles.

> table.prefix=sf1\
> column.prefix=sf1 &#x20;

* Follow the below path in DBSync Cloud Replication installation folder to find profile folder mysql\_new.
  * DBSync Cloud Replication Installation Folder (DBSyncCReplSF3) > dbsync-repl > WEB-INF > db > mysql\_new
* Go to config properties file in the profile folder for mysql and include the following codes in the file.

> table.prefix=sf2\
> column.prefix=sf2&#x20;

* In DBSync Replication Console go to profile mysql & go to tab Salesforce Sync Object Details. Click on Account, retain the standard fields in Available Fields section and push all the custom fields in Exclude Fields and save the changes.
  * The process of excluding the fields is detailed in the below wiki link
  * [http://help.mydbsync.com/docs/display/CloudReplication/Salesforce+Field+Selection](/cloud-replication-main/source-setup/salesforce/salesforce-field-selection.md)
* Go to profile mysql\_new of DBSync Cloud Replication Console and go to tab Salesforce Sync Object Details. Ensure that Salesforce and Database details are saved in the respective tabs. Click on Account, retain the custom field in Available Fields section and push all the standard fields in Exclude Fields and save the changes.

<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mydbsync.com/cloud-replication-main/troubleshooting/row-size-greater-than-64kb-in-mysql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.