Tagged Questions
1
vote
3answers
90 views
do MYSQL views occupy physical space?
do MYSQL views occupy physical space? Or in other words, is a MYSQL database limited to a certain number of views?
4
votes
1answer
104 views
Performance for fast filling table
I am currently creating a web application using the twitter streaming API and would need some advice concerning my database scheme.
I basically have a list of hashtags that I track in real-time. All ...
0
votes
1answer
215 views
Too many records on database and how to handle it? MySQL is it good to clone?
I am doing a social network and came up with the following concern regarding database storage. Let's put facebook as an example, imagine 2,000 photos per user, just 1,000 users, it would equal to ...
1
vote
1answer
154 views
Setting up DRBD on an active MySQL server
When it comes to setting up DRBD and MySQL, is the following possible?
Set up DRBD on an active MySQL server
Set up DRBD with no downtime allowed
3
votes
1answer
80 views
What are some key configuration settings for using an InnoDb table for session storage?
I want to start clustering my PHP app servers but don't want to go for a sticky-sessions load balancing setup at this point. However, I want sessions that are persisted to disk and implement proper ...
4
votes
1answer
525 views
How to best store the Google Web Ngram data?
This is a continuation of How to best store Google ngrams in a database?, which covers how to store the Google Ngram Book data.
I'm looking to store the Google NGram Web data, which is slightly ...
1
vote
1answer
118 views
String Pooling for MySQL
So I'm having this table that logs all errors happened in our production code. It looks like this:
id | date | type | message | file | line
...
3
votes
1answer
132 views
Extreme storage beasts
Intro
I have derived this question from my previous question Single Drive vs Multiple Drives
After getting a very detailed answer from a very helpful member RolandoMySQLDBA and learning the fact that ...
5
votes
1answer
294 views
MySQL and Solid State Disks on EMC
Since all writes and sequential reads are cached by the EMC storage system, the best use for solid state disk is to store data that has a random READ pattern. On Oracle, that is the temp tablespace ...
