How to prevent MySQL from using system disk? [closed]MySQL - allow connection from remote machine as root userMySQL: How do I get my “Maximum possible memory usage” down?Selinux/MySQL permissions issue in a new iSCSI disk: not allowed default_t contextMysql performance, understanding topWhy is MySQL is using so many temporary tables?MySQL Tuning — High Memory UsageMysql high memory usage and using swapMySQL limiting user disk space by tablespaceHow to decrese MySQL Innodb crash recovery time (force MySQL to do it faster)MySQL memory usage is too high

Can there be a single technologically advanced nation, in a continent full of non-technologically advanced nations?

Did the manned NASA capsules rotate during descent?

Has the Hulk always been able to talk?

Do I add my skill check modifier to the roll of 15 granted by Glibness?

IP addresses from public IP block in my LAN

ZSPL language, anyone heard of it?

Is there an official reason for not adding a post-credits scene?

Why wasn't the Night King naked in S08E03?

29er Road Tire?

Building a list of products from the elements in another list

Why is "breaking the mould" positively connoted?

Why do people keep telling me that I am a bad photographer?

Is the set of non invertible matrices simply connected? What are their homotopy and homology groups?

Shutter speed -vs- effective image stabilisation

Why aren't nationalizations in Russia described as socialist?

How do LIGO and VIRGO know that a gravitational wave has its origin in a neutron star or a black hole?

A factorization game

What does 'made on' mean here?

What is a smasher?

PWM 1Hz on solid state relay

What to use instead of cling film to wrap pastry

Why does sound not move through a wall?

Does it make sense for a function to return a rvalue reference

Can you Ready a Bard spell to release it after using Battle Magic?



How to prevent MySQL from using system disk? [closed]


MySQL - allow connection from remote machine as root userMySQL: How do I get my “Maximum possible memory usage” down?Selinux/MySQL permissions issue in a new iSCSI disk: not allowed default_t contextMysql performance, understanding topWhy is MySQL is using so many temporary tables?MySQL Tuning — High Memory UsageMysql high memory usage and using swapMySQL limiting user disk space by tablespaceHow to decrese MySQL Innodb crash recovery time (force MySQL to do it faster)MySQL memory usage is too high






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








-1















I'm using MySQL 5.7 on Windows machine. My datadir is set as D: but for example when altering tables, MySQL uses disk C too.



I guess it's related to swap but also it doesn't reach it's memory limit (innodb_buffer_pool_size) and system memory usage is 50%.



How can I prevent MySQL from using system disk and allow it to use D: only?






mysql database







share|improve this question













closed as off-topic by Michael Hampton♦ Apr 25 at 1:05


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions should demonstrate reasonable business information technology management practices. Questions that relate to unsupported hardware or software platforms or unmaintained environments may not be suitable for Server Fault - see the help center." – Michael Hampton
If this question can be reworded to fit the rules in the help center, please edit the question.
















  • What is the setting of tmpdir?

    – Rick James
    2 days ago

















-1















I'm using MySQL 5.7 on Windows machine. My datadir is set as D: but for example when altering tables, MySQL uses disk C too.



I guess it's related to swap but also it doesn't reach it's memory limit (innodb_buffer_pool_size) and system memory usage is 50%.



How can I prevent MySQL from using system disk and allow it to use D: only?






mysql database







share|improve this question













closed as off-topic by Michael Hampton♦ Apr 25 at 1:05


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions should demonstrate reasonable business information technology management practices. Questions that relate to unsupported hardware or software platforms or unmaintained environments may not be suitable for Server Fault - see the help center." – Michael Hampton
If this question can be reworded to fit the rules in the help center, please edit the question.
















  • What is the setting of tmpdir?

    – Rick James
    2 days ago













-1












-1








-1








I'm using MySQL 5.7 on Windows machine. My datadir is set as D: but for example when altering tables, MySQL uses disk C too.



I guess it's related to swap but also it doesn't reach it's memory limit (innodb_buffer_pool_size) and system memory usage is 50%.



How can I prevent MySQL from using system disk and allow it to use D: only?






mysql database







share|improve this question














I'm using MySQL 5.7 on Windows machine. My datadir is set as D: but for example when altering tables, MySQL uses disk C too.



I guess it's related to swap but also it doesn't reach it's memory limit (innodb_buffer_pool_size) and system memory usage is 50%.



How can I prevent MySQL from using system disk and allow it to use D: only?






mysql database




mysql database






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Apr 25 at 0:06









she hates meshe hates me

1233




1233




closed as off-topic by Michael Hampton♦ Apr 25 at 1:05


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions should demonstrate reasonable business information technology management practices. Questions that relate to unsupported hardware or software platforms or unmaintained environments may not be suitable for Server Fault - see the help center." – Michael Hampton
If this question can be reworded to fit the rules in the help center, please edit the question.







closed as off-topic by Michael Hampton♦ Apr 25 at 1:05


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions should demonstrate reasonable business information technology management practices. Questions that relate to unsupported hardware or software platforms or unmaintained environments may not be suitable for Server Fault - see the help center." – Michael Hampton
If this question can be reworded to fit the rules in the help center, please edit the question.












  • What is the setting of tmpdir?

    – Rick James
    2 days ago

















  • What is the setting of tmpdir?

    – Rick James
    2 days ago
















What is the setting of tmpdir?

– Rick James
2 days ago





What is the setting of tmpdir?

– Rick James
2 days ago










0






active

oldest

votes

















0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes

-