<div>
Thank you for the information...<br />
<br />
The problem that I am faced with now is that I can't login to SSH because of the server load. It just hangs when I try to connect. How to solve that?
</div>


Thank you for the information...

The problem that I am faced with now is that I can't login to SSH because of the server load. It just hangs when I try to connect. How to solve that?

<div>
I guess you'll need to ask support from your hosting company to do stuff via console.
</div>


I guess you'll need to ask support from your hosting company to do stuff via console.

<div>
<div class="content wysiwyg-content">
I'm creating an index on a MySQL table with 25,000,000 rows.<br />
<br />
The index is on 4 columns which are all VARCHAR(45), average being around 5 characters.<br />
<br />
I started this 12 hours ago and it's still running, it's using 14/16 of the server load, around 10% of the RAM. The server is dual quad core 3Ghz, 12GB RAM.<br />
<br />
I can't login to SSH to check on progress of anything because of the high load. Basically I'm locked out of the server while it's doing its processing and I have no idea how long it's going to last.<br />
<br />
Is it supposed to take this long? Anything I can do to check on progress and/or speed it up?<br />
<br />
Thanks!<br />
<br />
EDIT: I managed to check running processes through WHM and it's currently on &quot;Repair with keycache&quot;. Is that near the beginning or the end?
</div>
</div>


I'm creating an index on a MySQL table with 25,000,000 rows.

The index is on 4 columns which are all VARCHAR(45), average being around 5 characters.

I started this 12 hours ago and it's still running, it's using 14/16 of the server load, around 10% of the RAM. The server is dual quad core 3Ghz, 12GB RAM.

I can't login to SSH to check on progress of anything because of the high load. Basically I'm locked out of the server while it's doing its processing and I have no idea how long it's going to last.

Is it supposed to take this long? Anything I can do to check on progress and/or speed it up?

Thanks!

EDIT: I managed to check running processes through WHM and it's currently on "Repair with keycache". Is that near the beginning or the end?

MySQL Index Ongoing, More Than 12 Hours!

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.