mysqlcheck performance - MySQL Database

Marco

I launch the command line:
"mysqlcheck --repair dbname" over a database with only one myisam
table of more than 10.000.000 rows and 5 GB. The elapsed time to
repair is about 1 hour!
Is possible to increase speed?
Thanks.
Marco

Jul 19 '05 #1

Subscribe Post Reply

3389

Reply-Via-Newsgroup

"Marco" <ma*********@tin.it> wrote in message
news:af**************************@posting.google.c om...

I launch the command line:
"mysqlcheck --repair dbname" over a database with only one myisam
table of more than 10.000.000 rows and 5 GB. The elapsed time to
repair is about 1 hour!
Is possible to increase speed?
Thanks.
Marco

Besides your servers performance (is anything else other than MySQL running
on the box keeping it busy?) I am also wondering if you have too many (or
too few) indexes/keys... I'm a newbie so I could be sending you on a false
path, but it is something I would look in to if I were in the same boat...

laters
randelld

Jul 19 '05 #2

Reply-Via-Newsgroup

"Marco" <ma*********@tin.it> wrote in message
news:af**************************@posting.google.c om...

I launch the command line:
"mysqlcheck --repair dbname" over a database with only one myisam
table of more than 10.000.000 rows and 5 GB. The elapsed time to
repair is about 1 hour!
Is possible to increase speed?
Thanks.
Marco

Jul 19 '05 #3

Reply-Via-Newsgroup

"Marco" <ma*********@tin.it> wrote in message
news:af**************************@posting.google.c om...

I launch the command line:
"mysqlcheck --repair dbname" over a database with only one myisam
table of more than 10.000.000 rows and 5 GB. The elapsed time to
repair is about 1 hour!
Is possible to increase speed?
Thanks.
Marco

Jul 19 '05 #4

Similar topics

Trivial performance questions

by: Brian Patterson | last post by:

I have noticed in the book of words that hasattr works by calling getattr and raising an exception if no such attribute exists. If I need the value in any case, am I better off using getattr...

Python

mysqlcheck performance

by: Marco | last post by:

I launch the command line: "mysqlcheck --repair dbname" over a database with only one myisam table of more than 10.000.000 rows and 5 GB. The elapsed time to repair is about 1 hour! Is possible...

MySQL Database

Performance tuning for a stored procedure

by: serge | last post by:

I have an SP that is big, huge, 700-800 lines. I am not an expert but I need to figure out every possible way that I can improve the performance speed of this SP. In the next couple of weeks I...

Microsoft SQL Server

mysqlcheck vs. myisamchk

by: AJ | last post by:

I'm about to compress a number of tables using myisampack utility. The admin guide recommends running the following command after doing so: myisamchk -rq --sort-index --analyze tbl_name.MYI I...

MySQL Database

mysqlcheck: clients are using or haven't closed the table properly

by: Matt | last post by:

Hi everyone, I'm using the command mysqlcheck --all-databases --auto-repair --silent and I see these warnings (listed below) on a daily occurrence. Is mysqlcheck causing these warnings? I...

MySQL Database

mysqlcheck: Table is marked as crashed and last repair failed

by: Matt | last post by:

Hi everyone, I'm using the command "mysqlcheck --all-databases --auto-repair --silent" and I see these warnings and errors (listed below) on a daily occurrence. What could cause these indexes to...

MySQL Database

Database performance degrading (again)

by: teedilo | last post by:

We have an application with a SQL Server 2000 back end that is fairly database intensive -- lots of fairly frequent queries, inserts, updates -- the gamut. The application does not make use of...

Microsoft SQL Server

performance

by: bjarne | last post by:

Willy Denoyette wrote; > ... it > was not the intention of StrousTrup to the achieve the level of efficiency > of C when he invented C++, ... Ahmmm. It was my aim to match the performance...

C# / C Sharp

Performance Counter Update problem in ASP.Net application

by: jvn | last post by:

I am experiencing a particular problem with performance counters. I have created a set of classes, that uses System.Diagnostics.PerformanceCounter to increment custom performance counters (using...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA