Does having many databases affect MySQL performance?
Let’s find an answer to "Does having many databases affect MySQL performance?". The most accurate or helpful solution is served by Database Administrators.
There are ten answers to this question.
Best solution
I have huge unused databases in MySQL. Do they affect my MySQL engine performance even if they are unused? Do they consume memory on their own? Thanks
Answer:
The only performance hit I can see is on the INFORMATION_SCHEMA database (See my post How is INFORMATION...
perpetual_dream at Database Administrators Mark as irrelevant Undo
Other solutions
If I have two tables, let's say products and orders. And if orders is mission critical let's say, but products is not and sometimes products runs large queries, if I separate the tables into two different databases, would that make the performance more...
Answer:
No. Putting the two tables in different databases on the same server will gain you absolutely no performance...
Ben Osheroff at Quora Mark as irrelevant Undo
I feel stupid for asking this, but I'm wondering how having LOTS of small tables (with complex relationships) would affect performance and memory constraints vs a large, less neatly organized table.
Answer:
This is a great question (not stupid at all!) -- and (un)fortunately one with which I have first-hand...
Lorin Ricker at Quora Mark as irrelevant Undo
I have a pc which has Intel(R) Pentium(R) 4CPU 2.80GHz ~ 2.8GHz(1 Core,1 Logical Processor) . and 2GB RAM,40GB hard disk.Ealier XP sp2 ran as OS and, newly Win 7 64bit version was installed. I want to know whether this 64bit version overloads, reduces...
Answer:
To adress those people who think you have a 32 bit CPU- http://ark.intel.com/products/27461/Inte&hellip...
Aash at Yahoo! Answers Mark as irrelevant Undo
This is compared to a scenario of a table which has the same number of rows (O(10MM)) but has AUTO_INCREMENT that started at 0 (vs. something O(100MM)).
Answer:
I really doubt it: integers are fixed-sized, so either way the computer has to deal with the same number...
Ted Suzman at Quora Mark as irrelevant Undo
me and my team are doing it for the queens chamber of commerce. we have to design a website which will cater to high school and college students who want internships and employment, specifically in new york city and around the triboro area. we have already...
Answer:
Most of PHP application performance issues are caused by server settings. Rasmus Lerdorf, the creator...
NC at Yahoo! Answers Mark as irrelevant Undo
For example Amazon DynamoDB gets its read performance from using SSD drives. How will this affect Redis, VoltDB and others when you can store more data cheaper with similar performance?
Answer:
Most main memory databases have a log which contains data modifications, as well as a copy of the data...
Justin Swanhart at Quora Mark as irrelevant Undo
I am in the planning stage of a median web application, this app is a social network for organizations such as a corporate social network, used by the staff internally, but with not much features, only the basics like as chat, real time posts, comments...
Answer:
While there is nothing wrong in the individual components you have chosen, they are just too many stacks...
Pratik Mandrekar at Quora Mark as irrelevant Undo
How would the new Mac Mini server compare to a cheap shared hosting account? At present, my website is hosted on GoDaddy.com's 'economy' shared Linux hosting plan. I noticed that Apple has now released a version of the Mac Mini designed to act as a server...
Answer:
A site hosted on a 800k DSL line is pretty much doomed to feeling sluggish even if only one person is...
sindark at Ask.Metafilter.Com Mark as irrelevant Undo
I passed out from college (B-Tech ECE) in 2011 but started of programming and website development since beginning of my college days . I worked with few startups , did freelancing .. Launched my own website which is quite popular in india . I worked...
Answer:
There are only two ways you can attain the position you seek. 1. Start your own company where you are...
Mayur Kirtani at Quora Mark as irrelevant Undo
Related Q & A:
- How to completely backup all mysql databases?Best solution by Server Fault
- Why Can't I find my databases from Mysql on linux?Best solution by Database Administrators
- How can information systems affect a company’s bottom line (such as financial performance?Best solution by Yahoo! Answers
- How can an I.S. department affect a company's bottom line,like their performance?Best solution by Yahoo! Answers
- How many different career fields do human relations and interpersonal skills affect?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.