Issue with Slow Synchronization and Cron Job Execution
-
Dear BigBuy Support Team,
I hope this message finds you well. I am reaching out to report an issue we are experiencing with the slow synchronization between our WooCommerce store and BigBuy.Issue Description:
The synchronization process is extremely slow. Although no errors are displayed, it appears that the execution of the cron jobs is either blocked or only happens every few hours instead of every minute as expected. I have noticed that the records in the
wp_mipconnector_file_log
table in the database are only added every few hours. Thedate_processing_start
field shows that the cron job starts a process to add product data, but it seems to take hours to complete, as if there is a process blocking the requests.Background Information:After some investigation, I found a few potential issues that might be related to this problem:
- The plugin uses a custom cron job instead of the WP-Cron, which might be causing conflicts, especially if both crons are running simultaneously.
- The plugin requires a
max_execution_time
setting of 1 hour, which could be causing delays, particularly if multiple cron processes are being queued. - The use of
shell_exec
andgetmyuid
functions in the plugin might be causing compatibility issues, especially on servers where these functions are disabled for security reasons.
Questions:
To help diagnose and resolve the issue, could you please provide guidance on the following:
- Cron Configuration: Should the cron job be run exclusively outside of WP-Cron? Are there any recommendations for optimizing the cron job to avoid server overload?
- Max Execution Time: Is there a recommended way to configure the
max_execution_time
to improve synchronization speed without compromising server stability? - Logs: How can I enable more detailed logging to monitor the execution of each cron job? Are there any best practices for managing these logs securely and efficiently?
- shell_exec and getmyuid: Do you have any plans to remove the dependency on these functions? If not, are there any workarounds for servers where these functions are disabled?
- Server Requirements: Are there specific hardware or server configuration requirements to ensure optimal performance of the synchronization process?
Conclusion:
I would appreciate any assistance or recommendations you can provide to help resolve this issue. If there are any adjustments or configurations that I can make on my end, please let me know.
Thank you for your attention to this matter, and I look forward to your guidance.
Best regards,
The page I need help with: [log in to see the link]
- You must be logged in to reply to this topic.