Find Jobs
Hire Freelancers

MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB error

$10-30 USD

Closed
Posted over 5 years ago

$10-30 USD

Paid on delivery
MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB error on innodb table witk mysql 5,6 version.. error. they say there is a bug in this version.. i have 230 rows in table, and wont let me add any new varchar row.. its vps server. mysql can be configured.. i cant add new rows, i have to add may be 200 more.. current mysql conf is ------ -innodb_file_per_table=1 innodb_file_format = Barracuda innodb_strict_mode=0 innodb_log_file_size = 500M innodb_log_buffer_size = 800M default-storage-engine=MyISAM interactive_timeout=300 key_cache_block_size=4096 max_heap_table_size=32M max_join_size=1000000000 max_allowed_packet=268435456 open_files_limit=10000 query_cache_size=32M thread_cache_size=100 tmp_table_size=32M wait_timeout=7800 max_user_connections=50 myisam_recover_options=FORCE innodb_flush_log_at_trx_commit=0
Project ID: 17761912

About the project

16 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $22 USD for this job
User Avatar
This will require reconfiguring your MySQL configuration, I can help with that. Let me if you're interested, will need SSH root access to work on it.
$25 USD in 0 day
5.0 (442 reviews)
7.0
7.0
User Avatar
Hi, The solution is easy. i have done it for another client last week. Identify the tables that are large and split them separately and then upload. Please message me back right away to discuss the details and get started.. thank you...
$25 USD in 1 day
5.0 (490 reviews)
7.0
7.0
User Avatar
Hello, I'm Abu Gosia. I'm interesting your project very well. I'm good in Website Design, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart, C#, .Net, MVC, Angular.js, ASP.NET. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
$25 USD in 1 day
4.9 (157 reviews)
6.8
6.8
User Avatar
Hi I am a Sr. Linux Admin, Unix Admin, System Admin, Storage Admin, Server Admin, Virtualization Admin as well as Database Admin having hands-on proven experience over the past 11 years on different Linux flavors. I have strong experience in installing, configuring, maintaining and troubleshooting anything on Linux/Unix based operating systems including Centos, Debian, RedHat, Ubuntu, Debian, Raspberry Pi etc. I'm presently available for this task. Please message me if you would like to get this work done from me. Thanks & Regards Kamaldeep Singh Kahlon Sr. Linux/Unix/Database/Storage/Server/System Admin
$13 USD in 1 day
4.9 (88 reviews)
5.5
5.5
User Avatar
Hello. Lots of sysadmin experience here. I can solve this issue in 2 different ways. Just let me know in the chat when you need me. Thank you.
$15 USD in 0 day
4.9 (53 reviews)
5.0
5.0
User Avatar
hi. this task is easy for me and deliver you asap. this task is easy for me and deliver you asap. this task is easy for me and deliver you asap.
$25 USD in 1 day
5.0 (11 reviews)
3.9
3.9
User Avatar
Hi. Did you restart the server after change to innodb_strict_mode = 0 in the ini file? Please check this. Greetings
$15 USD in 1 day
5.0 (2 reviews)
2.0
2.0
User Avatar
hi, try to change varchar to text in your table to say if you have the same error.
$15 USD in 1 day
5.0 (3 reviews)
1.7
1.7
User Avatar
I am sumit sonaskar here is my straightforward introduction. 1. For 8th am a java developer 2. a great logical code maker 3. in 10th made an AI Game based on some sort of algorithms and certain application based on core java. 4. while doing polytechnic: In the first year did business in college studied a skill and freelance for student and earn, hired more student to grow business. 5. in the second year of polytechnic learn network security and various encryptions. 6. third-year polytechnic made a most difficult project and became an expert in image processing and various algorithms. challenged my HODs and teacher at my college on my project as I knew more theory than them. the project was based on Virtual to physical communication. as the project was done in 2015 and the same technology was used in Microsoft hololen. 7. After poly got the highest percentage in computer science branch and was able to get an NIT college but rather planned to start a business with 4 friends and failed. 8. then I developed many technological projects which I can explain in email and that too in time constrained for various client. based on web, Android, electronics. image process, management, and that too alone single handed that it from 2015 to 2018 I develop up to 70 of unique projects 9. between 2016-2018 did entrepreneurship and learned much-influencing skill and communication skill for growing business.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey there..! I have a experienece to work php,mysql database,javascrip,html css. And am also expert in Database Administration i have work experience as database administration in some Pakistan's most reputable IT industry.. Contact me , so we can move forward.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
MySql DBA
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a MYSQL developer and have had a similar issue but i was able to fix it. Depending on a number of factors the solutions differ. Am ready to explore these alternatives that may include setting the row format to be compressed and /or increasing the log/buffer size to be larger than the current Am an expert and ready to start immediately. You will only pay when the issue is fixed. Looking forward.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of TURKEY
istanbul, Turkey
5.0
23
Payment method verified
Member since Apr 24, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.