Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I am trying to save big data to database I extend the max_allow_packet and post_size but nothing happened.

the code and database released to production server and to stage server on production server is ok but on stage server not ok.

I think the problem not in code or database because they are the same on prod. and stage

so the problem will be in php conf, mysql conf or apache.

share|improve this question
What do you mean by "Not OK"? Can you see an error message? Can you see anything in the PHP, or Apache, or MySQL logs? – YaK Nov 5 '12 at 15:27
The issue is no errors no warnings just the page is submitted without any actions and no success msg. :( – Ayman Hussein Nov 5 '12 at 15:29
1  
Ayman, you must provide with some diagnostics from the MySQL server; just saying your PHP page is submitted gives no insight into what happens on the DB. Can you see, for example, the query being run on MySQL (SHOW PROCESSLIST)? Is it in the slow log? – Shlomi Noach Nov 6 '12 at 9:27
Turn on your sql general log. Run the insert by hand. Etc. – Alain Collins Nov 6 '12 at 21:09

migrated from stackoverflow.com Nov 6 '12 at 8:00

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.