What kind of SSD to speed up querying a lot of data?High Cardinality, Time Series Data.. what DB should I...
Is Screenshot Time-tracking Common?
Is it appropriate to give a culturally-traditional gift to a female coworker?
"Cheaper by the dozen" phrase origin?
Why Third 'Reich'? Why is 'reich' not translated when 'third' is? What is the English synonym of reich?
Why is it a problem for Freddie if the guys from Munich did what he wanted?
Why didn't Lorentz conclude that no object can go faster than light?
Why isn't there any EEPROM in STM32F4 MCUs?
Is candidate anonymity at all practical?
boss asked me to sign a resignation paper without a date on it along with my new contract
Is it possible to detect 100% of SQLi with a simple regex?
How can I get results over the whole domain of my non-linear differential equations?
How to create a custom script to force the download of a .csv file that is generated in real time?
Are there any rules or guidelines about the order of saving throws?
Why did Tywin never remarry?
What is the Guild Die for?
Does a star need to be inside a galaxy?
Why does calling Python's 'magic method' not do type conversion like it would for the corresponding operator?
How can I portray body horror and still be sensitive to people with disabilities?
Ethernet cable only works in certain positions
Is there any physical or computational justification for non-constructive axioms such as AC or excluded middle?
Was Opportunity's last message to Earth "My battery is low and it's getting dark"?
How to draw these kind of adjacent ovals with arrows in latex?
Can I legally make a website about boycotting a certain company?
Workplace intimidation due to child's chronic health condition
What kind of SSD to speed up querying a lot of data?
High Cardinality, Time Series Data.. what DB should I use?Retrieving data speed tweaks SQL Server 2005MySQL on SSD - what are the disadvantages?SSD vs HDD for databasesUpgrading to new cPanel Server with mySQL on SSD — What should I change in my.cnf?MySQL indexes maintenanceintel p3600 SSD no increase in read speed - postgres rdbms vs hddWhat kind of MySQL replication?Will NVME SSD speed up heavy queries, e.g. selects at large offsets / table scans etc?What does “Sending data” mean in the mysql process list?
For research purposes I am using a big MariaDB database (~500 GB) with 20 Tables (engine: myISAM) and around 9 Billion rows. Due to missing free storage on my Laptop (16 GB RAM), I put the data on an external hard drive. This was sufficient for simple queries. But for more complex tasks the queries take several days.
This is why I want to invest into a new internal hard drive (1-2 TB), which will be used in a server setup (128 GB RAM). Due to performance reason, I think a SSD would be the right choice. The mainboard has both free PCIe x8 and SATA 6.0GB/s slots.
Is there a difference between PCIe SSDs and M.2 SSDs?
What kind of SSD would be the best value for money according to my requirements? I do not want to spend more than 300 $?
mysql query-performance mariadb performance-tuning ssd
asked 4 mins ago
jstuhhjstuhh
1
New contributor
jstuhh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
For research purposes I am using a big MariaDB database (~500 GB) with 20 Tables (engine: myISAM) and around 9 Billion rows. Due to missing free storage on my Laptop (16 GB RAM), I put the data on an external hard drive. This was sufficient for simple queries. But for more complex tasks the queries take several days.
This is why I want to invest into a new internal hard drive (1-2 TB), which will be used in a server setup (128 GB RAM). Due to performance reason, I think a SSD would be the right choice. The mainboard has both free PCIe x8 and SATA 6.0GB/s slots.
Is there a difference between PCIe SSDs and M.2 SSDs?
What kind of SSD would be the best value for money according to my requirements? I do not want to spend more than 300 $?
mysql query-performance mariadb performance-tuning ssd
asked 4 mins ago
jstuhhjstuhh
1
New contributor
jstuhh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
For research purposes I am using a big MariaDB database (~500 GB) with 20 Tables (engine: myISAM) and around 9 Billion rows. Due to missing free storage on my Laptop (16 GB RAM), I put the data on an external hard drive. This was sufficient for simple queries. But for more complex tasks the queries take several days.
This is why I want to invest into a new internal hard drive (1-2 TB), which will be used in a server setup (128 GB RAM). Due to performance reason, I think a SSD would be the right choice. The mainboard has both free PCIe x8 and SATA 6.0GB/s slots.
Is there a difference between PCIe SSDs and M.2 SSDs?
What kind of SSD would be the best value for money according to my requirements? I do not want to spend more than 300 $?
mysql query-performance mariadb performance-tuning ssd
asked 4 mins ago
jstuhhjstuhh
1
New contributor
jstuhh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
For research purposes I am using a big MariaDB database (~500 GB) with 20 Tables (engine: myISAM) and around 9 Billion rows. Due to missing free storage on my Laptop (16 GB RAM), I put the data on an external hard drive. This was sufficient for simple queries. But for more complex tasks the queries take several days.
This is why I want to invest into a new internal hard drive (1-2 TB), which will be used in a server setup (128 GB RAM). Due to performance reason, I think a SSD would be the right choice. The mainboard has both free PCIe x8 and SATA 6.0GB/s slots.
Is there a difference between PCIe SSDs and M.2 SSDs?
What kind of SSD would be the best value for money according to my requirements? I do not want to spend more than 300 $?
mysql query-performance mariadb performance-tuning ssd
mysql query-performance mariadb performance-tuning ssd
asked 4 mins ago
jstuhhjstuhh
1
New contributor
jstuhh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 mins ago
jstuhhjstuhh
1
New contributor
jstuhh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 mins ago
jstuhhjstuhh
1
New contributor
jstuhh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 mins ago
jstuhhjstuhh
1
asked 4 mins ago
jstuhhjstuhh
1
1
New contributor
jstuhh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
jstuhh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
jstuhh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
jstuhh is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230262%2fwhat-kind-of-ssd-to-speed-up-querying-a-lot-of-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
jstuhh is a new contributor. Be nice, and check out our Code of Conduct.
jstuhh is a new contributor. Be nice, and check out our Code of Conduct.
jstuhh is a new contributor. Be nice, and check out our Code of Conduct.
jstuhh is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230262%2fwhat-kind-of-ssd-to-speed-up-querying-a-lot-of-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
