ERROR 1030: Got error 127 from table handler?
Hi everyone! I recently bought Mr. DuBois' MySQL book and got through the tutorials just fine. Since I wanted to venture into the wild without the help of the tutorials, I decided to make a project of my own. I have a guitar magazine collection with song transcriptions and all; I own around 60 so everytime I want to look up a song I have to go through most of the mags to find the song I'm looking for. Enter MySQL! I created a DB called 'tabs' and three tables: 'artist', 'song' and 'mag'. On the 'artist' table I have two columns: artist_name and artist_id, the latter is not null by default and auto incremented. On 'mag', I have five columns: mag_name, month, year, song_id and artist_id. And on 'song', song_name and song_id. As you can see, 'mag' is the link between 'artist' and 'song'. I started going through every magazine adding rows to every table succesfully. I ran test queries using the 'source' command and a text file. Everything was working just fine at that point. On day 3, I was almost done adding all the records to the tables when I ran a test query and all off a sudden I get a ERROR 1030: Got error 127 from table handler error message. I hadn't experienced ANY errors up to this point. The weird thing is I only got this type of message on the 'mag' and 'song' tables; 'artist' works just fine. I get this error message even with ordinary 'SELECT * FROM mag;' queries. As far as I know, all the tables are of the same kind: MySQL standard table type. So, MySQL gurus out there... what can I do to solve this problem? Is there a way I can recover all the info I added on the 'mag' and 'song' tables? Thanx in advance! - Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!
where to find a code of libmySQL
Hello, where can I get a source code of libmySQL library? I have installed MySQL but there are no source-code files. I would like to compile and link libmySQL on ma computer because I can't link a program using compiled libmySQL delivered with MySQL thanks for help Arkadiusz Balcerek
database table is read only
dear all, i has a problem to installing phpbb using mysql database. An error has occured during installation (An error occured trying to update the database Table 'phpbb_config' is read only). what is the problem ? please help me... -- This mail sent through PSP: http://www.polinpdg.ac.id/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: database table is read only
this is a phpbb specific question notice its a custom error message -Original Message- From: HA. Mooduto [mailto:[EMAIL PROTECTED] Sent: Saturday, July 05, 2003 8:13 PM To: [EMAIL PROTECTED] Subject: database table is read only dear all, i has a problem to installing phpbb using mysql database. An error has occured during installation (An error occured trying to update the database Table 'phpbb_config' is read only). what is the problem ? please help me... -- This mail sent through PSP: http://www.polinpdg.ac.id/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can add a record, but not update...
Running 3.23.56, from phpmyadmin all works fine. I'm building an admin
page, I can add a record, but when I try and update, I get this error:
ERROR Number=8 Description=Error: quot;Undefined index: ad_numquot;
on line 26 of /web/home/hovey/public_html/update.php./
Anyone have any ideas?
Here's the code for update.php:
?php require_once(config/include/utils.runtime6.php) ?
?php require_once(config/include/mysql.runtime6.php) ?
!DOCTYPE html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
meta http-equiv=content-type content=text/html;charset=iso-8859-1
meta name=keywords
content=San Antonio, used cars, new cars, San Antonio new car dealers, San
Antonio used cars, San Antonio new cars, cars, truck, trucks, sale, San
Antonio mercedes, mercedes,San Antonio BMW, car dealer, bmw, BMW, ferrari,
GMC,San Antonio porsche, porsche, classified, classifieds
meta name=content
content=San Antonio Pre-Owned Luxury and Classic Cars - Mercedes - Jaguar -
Porsche - Ferrari - BMW - and more!
meta name=generator content=Adobe GoLive 5
meta name=description
content=San Antonio Pre-Owned Luxury and Classic Cars - Mercedes - Jaguar -
Porsche - Ferrari - BMW - all in San Antonio, South Texas
meta name=Copyright content=Hovey Motorcars of San Antonio Texas
TITLEHovey Database Update Page/TITLE
style type=text/css media=screen!--
a:link { color: white;}
a:visited { color: white;}
a:hover { color: blue;}
#layer1 { position: absolute; top: 16px; left: 16px; width: 727px; height:
709px; visibility: visible; display: block }
--/style
?php // GoLive Content Source
$NewContentSource = WrapMySQLDatabaseResults(hovey, select * from
table1 where ad_num = ' . $GLOBALS[ad_num] . ',
block=1,NewContentSource);
?
/head
body bgcolor=white
div id=layer1
form action='config/actions/mysql.actions6.php??php echo
URLArgs(array())?' method=post name=FormName
table width=767 border=0 cellspacing=0 cellpadding=0 cool
gridx=16 gridy=16 height=655 showgridx showgridy usegridx usegridy
tr height=48
td width=16 height=654 rowspan=15/td
td width=192 height=48/td
td content csheight=37 width=496 height=48 colspan=3
valign=top xpos=208font
face=Arial,Helvetica,Geneva,Swiss,SunSans-RegularEdit the record and then
click the Update button/font/td
td width=62 height=240 rowspan=7/td
td width=1 height=48spacer type=block width=1
height=48/td
/tr
tr height=32
td content csheight=19 width=224 height=32 colspan=2
valign=top xpos=16
div align=right
font color=blackfont
face=Arial,Helvetica,Geneva,Swiss,SunSans-RegularAd
Number/font/font/div
/td
td width=32 height=606 rowspan=14/td
td width=432 height=32 valign=top align=left
xpos=272input type=text name='ad_num(?php echo
$NewContentSource-AbsolutePosition()?)' value='?php echo
fixHTMLquotes($NewContentSource-Value(ad_num)) ?' size=15
maxlength=15/td
td width=1 height=32spacer type=block width=1
height=32/td
/tr
tr height=32
td content csheight=19 width=224 height=32 colspan=2
valign=top xpos=16
div align=right
font color=blackfont
face=Arial,Helvetica,Geneva,Swiss,SunSans-RegularCar
Type/font/font/div
/td
td width=432 height=32 valign=top align=left
xpos=272select name='car_type(?php echo
$NewContentSource-AbsolutePosition()?)' size=1
option value=SUV ?php echo
selected($NewContentSource-Value(car_type) == SUV) ?SUV/option
option value=Sports ?php echo
selected($NewContentSource-Value(car_type) == Sports)
?Sports/option
option value=Trucks ?php echo
selected($NewContentSource-Value(car_type) == Trucks)
?Trucks/option
option value=Luxury ?php echo
selected($NewContentSource-Value(car_type) == Luxury)
?Luxury/option
option value=Classic ?php echo
selected($NewContentSource-Value(car_type) == Classic)
?Classic/option
/select/td
td width=1 height=32spacer type=block width=1
height=32/td
/tr
tr height=32
td content csheight=19 width=224 height=32 colspan=2
valign=top xpos=16
div align=right
font color=blackfont
face=Arial,Helvetica,Geneva,Swiss,SunSans-RegularCar
Year/font/font/div
/td
td width=432 height=32 valign=top align=left
xpos=272input type=text name='car_year(?php echo
$NewContentSource-AbsolutePosition()?)' value='?php echo
fixHTMLquotes($NewContentSource-Value(car_year)) ?' size=15
maxlength=4/td
td width=1 height=32spacer type=block width=1
height=32/td
/tr
tr height=32
td content csheight=19 width=224 height=32 colspan=2
valign=top xpos=16
div align=right
font color=blackfont
face=Arial,Helvetica,Geneva,Swiss,SunSans-RegularMake/font/font/div
/td
td width=432 height=32 valign=top align=left
xpos=272input type=text name='make(?php echo
$NewContentSource-AbsolutePosition()?)' value='?php echo
fixHTMLquotes($NewContentSource-Value(make)) ?' size=25
maxlength=25/td
td width=1 height=32spacer
The difference between 1.9G and 2.2G table when create Index
Hello MySQL, I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I create indexs for it, I couldn't finish after 4 hours. But when I reduce the records to 16,000,000, about 1.9G, the same index can be finished within 35 minutes. Can anyone explain it? Thanks in advance. I am using PIII 550, RedHat 8.0, with 1G Memory and IDE Hard Disk.The database is stored at ext3 file system. When I use show processlist for the 2.2G indexs, it tell me Copying to tmp table. James [EMAIL PROTECTED] _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The difference between 1.9G and 2.2G table when create Index
On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote: I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I create indexs for it, I couldn't finish after 4 hours. You mean it was still running? Was there still disk or CPU activity after 4 hours? But when I reduce the records to 16,000,000, about 1.9G, the same index can be finished within 35 minutes. Can anyone explain it? Thanks in advance. That's much shorter than 4 hours! Maybe your disk was full when creating the 2.2G table's index? MySQL waits until disk space becomes available again. You wouldn't see much disk activity while it is waiting. Keep in mind that MySQL makes a copy of your table while it is adding the index. You'll need twice the space of your initial table, plus space for the additional index. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The difference between 1.9G and 2.2G table when create Index
On Sat, Jul 05, 2003 at 03:16:11PM +0200, Fred van Engen wrote: On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote: I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I create indexs for it, I couldn't finish after 4 hours. You mean it was still running? Was there still disk or CPU activity after 4 hours? But when I reduce the records to 16,000,000, about 1.9G, the same index can be finished within 35 minutes. Can anyone explain it? Thanks in advance. That's much shorter than 4 hours! Maybe your disk was full when creating the 2.2G table's index? MySQL waits until disk space becomes available again. You wouldn't see much disk activity while it is waiting. Keep in mind that MySQL makes a copy of your table while it is adding the index. You'll need twice the space of your initial table, plus space for the additional index. Check this URL for details: http://www.mysql.com/doc/en/Full_disk.html There seems to be an exception to this rule when an index is added, so I may be wrong on this. The adding of an index happens in two phases and the docs are not clear to me about the first (copying) phase however. Your earlier comment indicates it is in the first phase still. I am using PIII 550, RedHat 8.0, with 1G Memory and IDE Hard Disk.The database is stored at ext3 file system. When I use show processlist for the 2.2G indexs, it tell me Copying to tmp table. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
efficient table
I tried to look everywhere @ mysql.com but i couldn't my question is how many records can a table handle so it stays fairly fast? What is the maximum records it can handle?? Thanx for any answers Anthony
New DBManager 2.1.1
The release 2.1.1 is a major bug fix and a few new features. If you are using an older Professional version, please consider updating it. Bellow, you can see the list of changes: NEW FEATURES -Added support to load/export binary data into/from a table (for blob fields). From now on BLOB fields will be marked as 'Blob' and TEXT fields will be marked as 'Memo'. -Added option to Preferences=Security to use active connection to the server -Added option to Preferences=Query to choose the default font face to be used in the Datasheet View Grid -Added support to drag and drop a entire database from one server to another -Enabled Copy to Clippboard (CTRL+C) for selected rows in the Datasheet View -Added option to the Import Data Wizard: you can select to log error messages and/or SQL statements -Added option to the Import Data Wizard: you can choose not to create integer fields as AUTO INCREMENT -The Import Data Wizard can now import Binary Data from MSAccess -The Import Data Wizard imports the Relationships directly to the database if using MySQL/InnoDB Tables or PostgreSQL -Added support for Foreign Keys in the Query Designer. Now it uses the default tables relationships (Foreign Keys) instead of the internal DBManager relationships -Servers can be marked as auto connect at startup -In MySQL newer versions you can drop Foreign Keys FIXES -Fixed Table quoting for MySQL versions older than 3.23.6 -Added full support for MySQL 3.22 versions -Fixed Datasheet View Grid refreshing -Fixed Active Transaction bug for PostgreSQL -Fixed bug when Importing tables from MSAccess. Data failed to be imported if the original field name was renamed due to reserved words in the CREATE TABLE -Fixed problem with Query Designer and AutoMap fields in Import Text Wizard: the dialogs didn't come up when using the DBLang.DLL -Fixed Index selection in the Table Preferences: the fields didn't match the selected index -Fixed minor bugs in the Table Editor -When editing table data the size of the edit doesn't change overriding the next cell -Fixed blank error message box when creating an user. -Database API for PostgreSQL was improved to add better support to the use of Namespaces (for PostgreSQL 7.3 or newer) In a few days we will release the source code of the DBLang.DLL and the HTML documentation. Anyone willing to translate the application to other native languages will need to use the Visual Studio 6.0 to compile and link the DLL and the Microsoft HTML Help Workshop (can be downloaded for free at www.microsoft.com) to compile the HTML Help manual. For those who doesn't have any of these softwares you may download the package for translation and send it back to me to create the DLL and CHM required. I would like to thank you all who sent me bug reports, documentation and website revisions. It wouldn't be possible without your help. PS: Before downloading the new version remember that the mirrors is being updated at the moment, but we expect to have everything working in a few hours. Also have in mind that not all mirrors are automatically updated, please use those marked with (*). If you have problems with a mirror, please send me a note telling the problem you are having and which mirror you have downloaded the setup from. This will help me to fix eventual problems. What is the DBManager? The DBManager is a FREE database manager for MySQL and PostgreSQL and runs only on Windows platforms. Supports managing all objects in a database server. It also includes wizards to help you with moving data from MSAccess, ODBC, MSExcel, Text Files, DBF, Paradox, create PHP scripts, etc. The complete list of features and additional information can be found at http://www.dbtools.com.br Best Regards, DBTools Software -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
behavior of SELECT NOW ()
Hi ! In a server with Conectiva Linux 6.0 (A Brazilian version) and Mysql 3.23.36 the comand SELECT NOW() returns 2003-07-05 10:00:00 both in the server and in the clients (Windows 98 with mysql-front and many programs writen in Delphi and MYODBC 2.50 or Zeos). In a new server with Conectiva 8 and Mysql 4.0.13 the comand SELECT NOW() returns 2003-07-05 10:00:00 only on the server, but in the clients returns 05/07/2003 10:05:00 !! This format of date / time is the way we use here in Brazil, BUT the programs expect the other way (-MM-DD HH:MM) and then they crash ! :( What can I do / configure to get the same response on server and the clients ? Thanks Rubens Jr. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.496 / Virus Database: 295 - Release Date: 03/07/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Getting started (again)
Hi. I'm a relative MySQL newbie. A few weeks ago, I installed MySQL 4.0.13 on my WinXP Home box. After some use, the system began to run very slowly, e.g, the login box, start menu, and other apps were taking a few seconds to respond to my mouse. Rebooting did not solve the problem. By trial and error, I pinpointed the problem to the MySQL daemon, so I shut down the daemon and uninstalled MySQL so that my system would respond after reboot, and this worked. I would like to work through these issues, so I have reinstalled MySQL 4.0.13. But I am back at square one, trying to set up the server. I see the mysqld-nt.exe daemon running, but I cannot connect. When I try mysql -u root or mysql -u root -p with my previous password, I get ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I guess I need some hand-holding again, I can't seem to get past this. Thanks for your help.
RE: Possible OT: ADONewConnection Error
I take it no one is familiar with particular error? Didn't get anything on google. -Original Message- From: marvc [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 9:00 PM To: [EMAIL PROTECTED] Subject: Possible OT: ADONewConnection Error Anyone here familiar with the following error: ADONewConnection: Unable to load database driver '' Fatal error: Call to a member function on a non-object in /wwwroot/htdocs/webdev/nubiint/includes/pnAPI.php on line 486 I get this error when trying to configure multisites in my postnuke site. I thought it was an ODBC issue but I've installed both MyODBC iODBC and still get the error. Anyone have any ideas on what else could be causing this? Any responses are appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Optimal Disk Configuration
What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Compiling 4.2.3 with MySQL ... what does it look for?
X-posted to PHP General, PHP DB, and MySQL Hi gang Attempting to get my Linux test-server working, but ran into a problem when making PHP... System is RedHat 8, Apache 1.3.27 (compiled myself, tested OK), MySQL 4.0.13. The Apache 2.0.40 and PHP 4.2.2 that came w. RH8 didn't work correctly, thus I've ventured into my own creation. Trying to build PHP 4.2.3 (because that's what my webhost runs, so need that version to test correctly) w. support for MySQL. Running ./configure --with-mysql=/[path to mysql] --with-apxs=/[path to apxs] Found the path to the apxs to be /usr/local/apache/bin/apxs, but for the life of me I cannot figure out what path to give it for MySQL. I installed MySQL from the the RPM files: MySQL-client-4.0.13-0.i386.rpm MySQL-devel-4.0.13-0.i386.rpm MySQL-embedded-4.0.13-0.i386.rpm MySQL-server-4.0.13-0.i386.rpm MySQL-shared-4.0.13-0.i386.rpm client and server first, the rest second ... used --force to get them in, because it complained about version issues with the one already there (even though the package manager was told not to put the Mysql in, it still put MySQL 3.something in...) When doing the configure above, I get this error: configure: error: Cannot find header files under /usr/include or whatever path I give it ... I'm having a hard time figuring out where the RPM puts everything, and an even harder time figuring out what path to stick to PHP ... Some detective work gave me these paths: MySQL (bins): /usr/bin /usr/share/mysql MySQL daemon (mysqld): /usr/libexec /usr/sbin MySQL headers (.h): /usr/include/mysql I've tried them all, but they all result in the above error. Anyone care to guess which path I should give to the configure? Or is it something else that causes this? I haven't ever used MySQL before, or any other SQL for that matter, so got 0 experience in getting the system up and running with it... TIA Rene -- Rene Brehmer aka Metalbunny http://metalbunny.net/ References, tools, and other useful stuff... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP-DB] Compiling 4.2.3 with MySQL ... what does it look for?
try --with-mysql=/usr
--- -{ Rene Brehmer }- [EMAIL PROTECTED]
wrote:
X-posted to PHP General, PHP DB, and MySQL
Hi gang
Attempting to get my Linux test-server working, but
ran into a problem when
making PHP...
System is RedHat 8, Apache 1.3.27 (compiled myself,
tested OK), MySQL 4.0.13.
The Apache 2.0.40 and PHP 4.2.2 that came w. RH8
didn't work correctly,
thus I've ventured into my own creation.
Trying to build PHP 4.2.3 (because that's what my
webhost runs, so need
that version to test correctly) w. support for
MySQL. Running
./configure --with-mysql=/[path to mysql]
--with-apxs=/[path to apxs]
Found the path to the apxs to be
/usr/local/apache/bin/apxs, but for the
life of me I cannot figure out what path to give it
for MySQL. I installed
MySQL from the the RPM files:
MySQL-client-4.0.13-0.i386.rpm
MySQL-devel-4.0.13-0.i386.rpm
MySQL-embedded-4.0.13-0.i386.rpm
MySQL-server-4.0.13-0.i386.rpm
MySQL-shared-4.0.13-0.i386.rpm
client and server first, the rest second ... used
--force to get them in,
because it complained about version issues with the
one already there (even
though the package manager was told not to put the
Mysql in, it still put
MySQL 3.something in...)
When doing the configure above, I get this error:
configure: error: Cannot find header files under
/usr/include
or whatever path I give it ... I'm having a hard
time figuring out where
the RPM puts everything, and an even harder time
figuring out what path to
stick to PHP ...
Some detective work gave me these paths:
MySQL (bins):
/usr/bin
/usr/share/mysql
MySQL daemon (mysqld):
/usr/libexec
/usr/sbin
MySQL headers (.h):
/usr/include/mysql
I've tried them all, but they all result in the
above error. Anyone care to
guess which path I should give to the configure?
Or is it something else that causes this?
I haven't ever used MySQL before, or any other SQL
for that matter, so got
0 experience in getting the system up and running
with it...
TIA
Rene
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimal Disk Configuration
It depends on what your goal is and how many disks your system will contain. Personally I like a disk configuration with multiple spindels for performance. I also require redundancy, RAID-5 sounds good and is but I want the most out of writes, so I go with RAID-1+0. Hope this helps. On Sat, 5 Jul 2003, Jim McAtee wrote: What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The difference between 1.9G and 2.2G table when create Index
Thanks guys, Actaully my Hard disk is 10G, just for one table. There is enough table space. I noticed when I created index for 1.9G table, at the first phase, mysql copy table, but mysql doesn't write to the tmp index file, I means the filesize of the tmp index didn't increase. When I create index for 2.2G table, the tmp index file is increased at the first phase. Any reason? James [EMAIL PROTECTED] I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I create indexs for it, I couldn't finish after 4 hours. You mean it was still running? Was there still disk or CPU activity after 4 hours? But when I reduce the records to 16,000,000, about 1.9G, the same index can be finished within 35 minutes. Can anyone explain it? Thanks in advance. That's much shorter than 4 hours! Maybe your disk was full when creating the 2.2G table's index? MySQL waits until disk space becomes available again. You wouldn't see much disk activity while it is waiting. Keep in mind that MySQL makes a copy of your table while it is adding the index. You'll need twice the space of your initial table, plus space for the additional index. Check this URL for details: http://www.mysql.com/doc/en/Full_disk.html There seems to be an exception to this rule when an index is added, so I may be wrong on this. The adding of an index happens in two phases and the docs are not clear to me about the first (copying) phase however. Your earlier comment indicates it is in the first phase still. I am using PIII 550, RedHat 8.0, with 1G Memory and IDE Hard Disk.The database is stored at ext3 file system. When I use show processlist for the 2.2G indexs, it tell me Copying to tmp table. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimal Disk Configuration
My favourite for dedicated db servers (good amount of data, but a ton of access, queries/sec) is raid 0+1 ... fast access, but requires a good number of disks.. Be sure to use a good raid controller, multiple channels for the disks if possible.. On Sat, 5 Jul 2003, Jim McAtee wrote: What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimal Disk Configuration
That's it? The entire system - OS, swap space and data in a single array? Nothing more involved? [EMAIL PROTECTED] wrote: My favourite for dedicated db servers (good amount of data, but a ton of access, queries/sec) is raid 0+1 ... fast access, but requires a good number of disks.. Be sure to use a good raid controller, multiple channels for the disks if possible.. On Sat, 5 Jul 2003, Jim McAtee wrote: What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
