what best config for my.cnf file i have big size sql
Total processors: 4
Processor #1
Vendor
GenuineIntel
Name
Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz
Speed
3200.058 MHz
Cache
12288 KB
Memory Information
Memory: 14243308k/15728640k available
best mysql config for my vps
410 Views Asked by Mohammad Shahpari At
2
There are 2 best solutions below
Related Questions in MYSQL
- MySQL Select Rank
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Push mysql database script to server using git
- Why does mysql stop using indexes when date ranges are added to the query?
- Google Maps API Re-size
- store numpy array in mysql
- Whats wrong with this query? Using ands
- MySQL-Auto increment
- show duplicate values subquery mysql
- Java Web Application Query Is Not Working
- microsoft odbc driver manager data source name not found and no default driver specified
- Setting foreign key in phpMyAdmin
- No responses from google places text search api
- Adding to MAMP database in SQL/PHP
- I want to remove certain parent- and child-divs in all my wordpress posts with php or some other script
Related Questions in CPANEL
- How to install node js and setup a "hello world" website on a shared linux hosting?
- I get 530 access denied in ftp connection after some upgrade in my internet connection
- Cpanel shows blank page on my site.
- Grant Google Access to SMTP on cPanel/WHM Centos Server without advertising SMTP Auth?
- RAM allocation in WHM/Cpanel using SSH
- 403 Error when trying to remove products from Cart
- cPanel API authentication methods
- Curl set returns resource id 34
- current MySql Connection Limit Expansion
- showbw() ---Fatal error: Uncaught exception 'Exception' with message 'curl_exec threw error "
- I have uploaded the files of my website in cpanel in public_html but after that website is not visible on web
- Disable mod_security for QUERY_STRING (table_name) in specific file
- How to load a webpage to refresh data using Cron Job in Cpanel
- SSL certificate verifaction error cPanel
- WHM 11.50.0 (build 10) & X-PHP-Script = Security Bug
Related Questions in VPS
- SPF and DKIM records for Mandrill on DigitalOcean
- RAM allocation in WHM/Cpanel using SSH
- How to know how much Ram and how many CPU are available for a Linux/Plesk Vps?
- Setup VPS with a Symfony2 project from git repository
- laravel5: chdir(): No such file or directory (errno 2)
- plesk when upgrading php, will this break everything?
- Multi-domains I/O n CPU restrictions via nginx vps
- Heroku. Two or more applications in one dyno
- best mysql config for my vps
- Permittion Denied whilst executing '.sh'
- My VPS restarting every hour
- Remote access from my PC to MySQL 5.6 installed on VPS with Ubuntu Server 14.04
- Heroku makes you pay to use specific features, why? how does this work with hosting solutions?
- Hosting webapp on an AWS EC2 server. Do I need to use the AWS "application services" for search and email?
- Setup a MYSQL database on a Windows VPS for connecting outside network
Related Questions in WHM
- Grant Google Access to SMTP on cPanel/WHM Centos Server without advertising SMTP Auth?
- I would like to change the domain name an account I'm hosting using whm
- RAM allocation in WHM/Cpanel using SSH
- WHM 11.50.0 (build 10) & X-PHP-Script = Security Bug
- account “ ” has user id 0 (root privileges
- best mysql config for my vps
- mysql_connect not working after EasyApache update
- Time to first byte over 40 seconds on only one page
- FAILED to Install PDO through WHM
- Setting Up new domain for WHM, ERR_NAME_NOT_RESOLVED
- cPanel MySQL upgrade fail CentOS
- phpmyadmin gets autoupdated, sql mod
- WHM/Cpanel New Account issue - Edit DNS Zone error
- Cannot connect to to site - FTP timeout
- PHP Post - Speical Characters not making it to the server
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
There is no straight forward answer of this question as one configuration can be suitable for one but not for other..
If you are using innodb engine then You can start with below configuration initially and can optimize as per your requirement/problems-