Add a new value in an ENUM by manipulate .frm

Hi, I need to add another value in an enum so ALTER TABLE table1 MODIFY Status ENUM('a','b','c') where 'c' is the new value. My problem is that the tables are VERY big and it would take days to alter them all. So, i figure the values in enum:s are in the .frm file so why not change it and

Re: Add a new value in an ENUM by manipulate .frm

Barry wrote: Jörgen Winqvist schrieb: Hi, I need to add another value in an enum so ALTER TABLE table1 MODIFY Status ENUM('a','b','c') where 'c' is the new value. My problem is that the tables are VERY big and it would take days to alter them all. Tried it? I also use big tables

50 000 tables - table_cache

I'm working with an application that uses a lot of tables. Apx 50k tables are accessed every 5 minuts and they are openened/closed constantly. There is a performance problem and i've changed the filesystem to reiserfs for better handling many files. I also increased the open-file limit in both

Re: 50 000 tables - table_cache

this many tables. Is there any chance you could use MERGE tables to chuck a few of them together (admittedly I'm guessing here). Regards, Chris Jörgen Winqvist wrote: I'm working with an application that uses a lot of tables. Apx 50k tables are accessed every 5 minuts and they are openened/closed

Re: Large Tables

Hi, I run something similar, apx 11 Gb MyIsam + 9 Gb index per month and I use a merge table on top of sevral 9-11 Gb tables. I dont think you need to have a merge table if doesnt bring you any other advantages, eg. cycling of tables. RH 7.2 + 2.4.18 kernel, ReiserFs Compaq 4 way XENON,

Re: Stability problems on 4-way server

Sinisa Milivojevic wrote: Jörgen Winqvist writes: I run RH supported kernel 2.4.7-10enterprise on such a server with similar problems. All four CPU's runs off with a lot off system. I can provoke this behaviour by generating disk i/o. A 'cp' might be it. I often get it when the full backup

Re: Two daemons, 1 data dir.

Hi, I'm not sure if I understand you but you can't have the datadir/database filesystem monted read-write on the two servers at the same time. At least not with consistensy. Perhaps with innodb on raw devices? /Jörgen CyberSushi wrote: Hi, I've got 2 mysql server that I want to configure

Re: Stability problems on 4-way server

Trond Eivind Glomsrød wrote: Dennis Jacobfeuerborn [EMAIL PROTECTED] writes: We are running MySQL version 3.23.43 on one of our servers and have some stability Where did you get that? The MySQL site? Some info about the system: Dell PowerEdge 8450 4 x Xeon 700 4GB of RAM

Re: Command Line Editing Mode

Hi, This $HOME/.inputrc gets you vi-mode in mysql and other programs that uses readline. set editing-mode vi set show-all-if-ambiguous On # after TAB is pressed Regards Jörgen Quentin Bennett wrote: Hi, Using the mysql CLI, I have discovered that ESC-Return Return will put the CLI