原文:http://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large
异常信息:
Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
解决方法:
The method that worked for the OP there was:
1,Add the following to the my.cnf file under [mysqld] section.
innodb_file_per_table innodb_file_format = Barracuda
2,ALTER the table to use ROW_FORMAT=COMPRESSED.
ALTER TABLE nombre_tabla ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
如果以上方法还不行,扩大my.ini的配置项innodb_log_file_size。之前设置的是512M,本以为足够大了,按照上述方法修改无效,然后将innodb_log_file_size扩大到1024M,就正常了。
相关推荐
BLOB和TEXT类型<br>11.4.4. ENUM类型<br>11.4.5. SET类型<br>11.5. 列类型存储需求<br>11.6. 选择正确的列类型<br>11.7. 使用来自其他数据库引擎的列类型<br>12. 函数和操作符<br>12.1. 操作符<br>12.1.1. 操作符...
目录<br><br>前言<br>1. 翻译说明<br>1. 在Tomcat中快速上手<br>1.1. 开始Hibernate之旅<br>1.2. 第一个可持久化类<br>1.3. 映射cat<br>1.4. 与猫同乐<br>1.5. 结语<br>2. 体系结构<br>2.1. 总览<br>2.2. JMX集成<br...
目录<br><br>前言<br>1. 翻译说明<br>1. 在Tomcat中快速上手<br>1.1. 开始Hibernate之旅<br>1.2. 第一个可持久化类<br>1.3. 映射cat<br>1.4. 与猫同乐<br>1.5. 结语<br>2. 体系结构<br>2.1. 总览<br>2.2. JMX集成<br...
<br> <br> //Do something to dataset then you can update it to Database.Here I just add a row<br> DataRow row = dataSet.Tables[0].NewRow();<br> row[0] = 10000;<br> row[1] = "new row";<br> dataSet....
namespace Magicbit.Framework<br>{<br> public<br>partial<br>class DBTools : Form<br> {<br><br> private<br>static DBTools _Instance =<br>null; <br> public<br>static DBTools Instance() <br> {<br> if (_...
<br>oDoc.Bookmarks.Item(ref oBookMark).Range.Text = "Some Text Here";<br> <br><br>object oStyleName = "MyStyle";<br>oDoc.Bookmarks.Item(ref oBookMark).Range.set_Style(ref oStyleName);<br> <br><br>...
* When the size of a Persistent field in TClientDataSet is set too large, it overwrites neighboring fields upon Post (Quality Central 3974). * TDataSetProvider generates incorrect SQL in response to ...
1.怎样定制VC#DataGrid列标题?... <br><br> dt.Columns.Add(dcChehao); <br><br> Oracle:<br><br> select col1||col2 from table<br><br> sql server:<br><br> select col1+col2 from table
<br> /// </summary><br> <br> [DllImport("User32.dll",EntryPoint="SendMessage")]<br> private static extern int <br> SendMessage(<br> int hWnd, // handle to destination window<br> int Msg, // ...
<Columns> ColumnLayout <Cells> TableLayout 37. Removed [XType] Attribute and replaced with XType readonly property. Example (Old) [Xtype("window")] Example (New) ...
我引入的是:Microsoft Excel 11.0 Object Library(EXCEL2003), <br> <br> 你申明的时候写出名字空间全路径就应该没有问题了: <br> <br> private Microsoft.Office.Interop.Excel.Application myExcel1; <br> ...
MYSQL高级特性 81<br>4.1 集合函数 82<br>4.1.1 行列计数 82<br>4.1.2统计字段值的数目 82<br>4.1.3 计算字段的平均值 83<br>4.1.4 计算字段值的和 84<br>4.1.5 计算字段值的极值 84<br>4.1.6 总结 86<br>4.2 操作...
MYSQL高级特性 81<br>4.1 集合函数 82<br>4.1.1 行列计数 82<br>4.1.2统计字段值的数目 82<br>4.1.3 计算字段的平均值 83<br>4.1.4 计算字段值的和 84<br>4.1.5 计算字段值的极值 84<br>4.1.6 总结 86<br>4.2 操作...
regardless of bus type<br> Fits on a diskette for easy transportability and quick downloads<br> Drag and drop captured data to other products in html format<br> Save captured data to a text file...
Report Machine 2.6<br>===================<br><br>这是一个报表控件包,For Borland Delphi Versions 3,4,5,6,7.100% 源码.<br><br>最后更新日期:2002.10.11<br><br>目录<br>-----<br> 说明<br> 特点<br> 最后...
Software Testing and Continuous Quality Improvement<br><br>SECTION I SOFTWARE QUALITY IN PERSPECTIVE . . . . . . . . . . . . . . . 1<br>1 Quality Assurance Framework. . . . . . . . . . . . . . . . . ....
if (dataList.Table.Columns.Contains("ROW_ID")) dataList.Table.Columns.Remove("ROW_ID"); if (dataList.Table.Columns.Contains("LAST_UPDATED_BY")) dataList.Table.Columns.Remove("LAST_UPDATED_BY"); ...
LastColumn = ActiveSheet.UsedRange.Columns.Count LastColumn = LastColumn + ActiveSheet.UsedRange.Column For c = LastColumn To 1 Step -1 If WorksheetFunction.CountA(Columns(c)) = 0 Then Columns(c)....
<br><br> int columns = dataGridView1.Columns.Count;<br> int rows = dataGridView1.Rows.Count;<br><br> for (int j = 0; j < columns;j++ )<br> {<br> sheet.Cells[0, j].Value = dataGridView1.Columns[j]....
You can use this sample to find or select an open window, and view information about the window, such as its hwnd, size, and parent window.<END><br>29,launcher.zip<br>This is an ActiveX DLL that ...