Hello,
I want to convert a table from innodb to myisam on the _master only_, not
on the slaves. Is there a secret 'do this alter table only on the
master' command, or do I really have to do some
voodoo-replication-queries-skipping
on the slaves?
Thanks,
Harmen
--
Hello,
if you do an alter table, altering some indexes _and_ converting it to
innodb, will mysql do the altering and converting in one pass, or will it
first change the indexes and than start the innodb conversion?
For example, with an myisam table:
alter table my_table, drop index an_index, add
On Mon, Jan 12, 2004 at 12:54:55PM -0500, Syed Ali wrote:
> Hello,
>
> I would like to move data between tables in mysql within the same
> database, I am not sure what the best way to go about it is.
> I do not need to move all the data in the tables, just the output of
> some select statements.
On Mon, Dec 15, 2003 at 01:42:30PM -0600, Paul Fine wrote:
> Thanks (to all who replied)
>
> If I lock the table however, if another user is trying to insert (via php
> page) another record they will get an error right and I will need to make a
> wait+retry script?
_if_ you lock the other thread
Hi all,
Up until now we always created database backups using the mysqldump tool.
But I'm wondering, if it is possible to just create a tar archive of the
complete mysql data directory.
We are running on Linux (2.4.18) and we use mysql 4.014.
Thanks,
Harm de Laat
Informatiefabrie
--+
| 33 |
++
1 row in set (0.00 sec)
This is result is correct...
I use mysql 4.0.14. I also did the same test on mysql 4.1 alpha, which has
the same results.
Can somebody help?
Thanks,
Harm de Laat
Informatiefabriek
The Netherlands
--
MySQL Genera
On Sat, Jul 12, 2003 at 01:11:41AM +1000, Phil Evans wrote:
> Hi there. I am a rank amateur at this trying to make sense out of a heap (and
> growing) of data.
>
> I have a resultset with this structure:
>
> nodatadate
> 1uytd1
> 1klhd2
> 1oiud3
> 2kjhd1
>
On Thu, Mar 20, 2003 at 05:06:09PM +0100, Benjamin Pflugmann wrote:
> Hi.
>
> On Thu 2003-03-20 at 15:52:25 +0100, [EMAIL PROTECTED] wrote:
> >
> > I use a lot of SET-alike fields in my tables. The fields are used to store
> > properties and such; every bit stands for a specific value. The fields
Hello,
I use a lot of SET-alike fields in my tables. The fields are used to store
properties and such; every bit stands for a specific value. The fields are
queries like 'where property_field & 1<<4' or 'where property_field & 1025'
if you look for more than one property.
Just your average SET be
On Thu, Feb 13, 2003 at 05:57:54PM +0300, Artem Koutchine wrote:
>
> > The effect is you limit the possible rows to a small amount really
> quick
> > with a simple join. The details of the search are handled bij a like
> which
> > can get as complicated as you like using OR`s, NOT`s etc; it won`t
On Thu, Feb 13, 2003 at 03:04:08PM +0300, Artem Koutchine wrote:
> The query is:
>
> SELECT DISTINCT w0.l_id FROM law_words as w0
> inner join law_words as w1 on w0.l_id=w1.l_id
> inner join law_words as w2 on w0.l_id=w2.l_id
> inner join law_words as w3 on w0.l_id=w3.l_id
> WHERE
> w0.w_id
Moi,
every now and then my otherwise happely running mysqld has a thread or two
stuck in the state 'statistics'. If I kill it with `mysqladmin kill ` it does get registered as 'killed' (According to `mytop`). But
the thread refuses to die. They do die eventually but it can take a few
thousend sec
On Wed, Jan 15, 2003 at 11:55:44PM +, [EMAIL PROTECTED] wrote:
>
> please look at page 194 of the reference manual...
>
> >(and if so how do you ask MySQL to create a temp table from the
> > results of aquery?)
>
> here's an example:
>
> mysql> create temporary table tmp (name varchar(20),
On Tue, Jan 14, 2003 at 01:22:32PM +0100, harm wrote:
> Hello,
>
> Because I switched some large tables back to myisam from innodb (sorry
> Heikki) my innodb datafile has a few gig 'empty'. I would like to reclaim
> that space.
>
> Can I expect a problem if
Hello,
Because I switched some large tables back to myisam from innodb (sorry
Heikki) my innodb datafile has a few gig 'empty'. I would like to reclaim
that space.
Can I expect a problem if I:
- make _all_ innodb tables myisam (And be very sure I changed them all),
- shutdown the dbase,
- trun
On Tue, Jan 07, 2003 at 12:31:36PM +0100, harm wrote:
> > > Anybody else who has any idea why the index are not used as they should?
> >
> > I've got same things with 3.23.xx and select query through a TCP/IP
> > connection.
> > I don't know why, but y
On Tue, Jan 07, 2003 at 11:49:05AM +0100, David Bordas wrote:
> > Anybody else who has any idea why the index are not used as they should?
>
> I've got same things with 3.23.xx and select query through a TCP/IP
> connection.
> I don't know why, but you can solve this issue using the USE INDEX synt
On Sat, Jan 04, 2003 at 03:25:00PM +0200, Victoria Reznichenko wrote:
> On Saturday 04 January 2003 14:53, harm wrote:
>
> > > Your order by will not use your weg_2 index because, as you stated,
> > > weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used
On Sat, Jan 04, 2003 at 03:25:00PM +0200, Victoria Reznichenko wrote:
> On Saturday 04 January 2003 14:53, harm wrote:
>
> > > Your order by will not use your weg_2 index because, as you stated,
> > > weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used
On Fri, Jan 03, 2003 at 08:24:17PM -0500, Brian Lindner wrote:
> harm,
>
> Your order by will not use your weg_2 index because, as you stated,
> weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used
> for the individual columns as you need
>
> try to creat
Hello,
I am trying to get a sort to use an index. The query is very simple:
select nr from mytable where col1='const' and col2='another const' and col3='YA
const' order by nr;
The explain gives me:
+-+--+--+---+-+---+--+
On Sun, Dec 29, 2002 at 11:43:35AM -0500, Michael She wrote:
>
>
> BTW, does MySQL have a RowNumber function?
You can use variables:
select @a := 0; select id, more, fields, @a:= @a + 1 as rownumber from whatever;
But you cannot use that number in the where part.
Good luck.
(sql, etc)
--
On Sat, Dec 07, 2002 at 02:08:28PM -0500, Amittai Aviram wrote:
> I have been learning a bit about the Perl DBI MySQL API. This API offers
> several ways of fetching the results of a query. Among these,
> fetchrow_array returns a numbered array, while fetchrow_arrayref returns a
> reference to an
On Tue, Oct 15, 2002 at 05:13:24PM +0300, Antonios Christofides wrote:
> I tried 3.23.52 rather than 3.23.53. This solved both the remote
> connection problem I had in 3.23.37, which was caused by the glibc
> upgrade, and the "Can't change to run as user 'mysql'" problem, which
> I had on 3.23.53.
he join?
Any help would be greatly appreciated.
Many Thanks,
Harm de Laat
Informatiefabriek
The Netherlands
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
ql-4.0/index.html
Cheers,
Harm de Laat
Informatiefabriek
The Netherlands
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thr
First of all, let me apologize for repeaditly sending my e-mail message
to the list.
Roger Baklund wrote:
>
>I don't know. Not in the nearest future, they have just begun the coding.
>
Oka
>I don't get it... does it "work perfectly with mysql", or do you "realy need
>stored procedures"? And ho
witch to some other database management system like
postgresql (which does support stored procedures)?
We realy would like to use mysql. Because the Lotus Domino bridge work
perfectly with mysql, but it does not realy work with PostgreSQL.
Any ideas here?
Many Thanks,
Harm de Laat
Informatiefa
witch to some other database management system like
postgresql (which does support stored procedures)?
We realy would like to use mysql. Because the Lotus Domino bridge work
perfectly with mysql, but it does not realy work with PostgreSQL.
Any ideas here?
Many Thanks,
Harm de Laat
Informatiefa
witch to some other database management system like
postgresql (which does support stored procedures)?
We realy would like to use mysql. Because the Lotus Domino bridge work
perfectly with mysql, but it does not realy work with PostgreSQL.
Any ideas here?
Many Thanks,
Harm de Laat
Informatiefa
On Mon, Feb 04, 2002 at 08:01:39PM -0700, Matthew Walker wrote:
> I need to find a text editor for Linux that doesn?t load the whole file
> into memory. I need to edit a 1.5 gig text flatfile to add two lines.
> But I don?t have enough ram to open it in most programs. Can anyone
> recommend someth
On Fri, Nov 09, 2001 at 01:24:57AM +0100, Carsten H. Pedersen wrote:
> > > > But, it is all explaind in the manual :)
> > >
> > > Exactly where in the manual did you find that piece of information?
> >
> > 5.4.2 Get Your Data as Small as Possible
> ...
> >
> > But i read the advise literally so
On Fri, Nov 09, 2001 at 12:46:33AM +0100, Carsten H. Pedersen wrote:
> >
> > + your datafile will be smaller which saves disk IO. In the end, the extra
> > cost of the less efficient index as less than the gain from the faster
> > access. So in the end you win speed.
>
> huh?
>
> With a variable
On Fri, Nov 09, 2001 at 12:46:33AM +0100, Carsten H. Pedersen wrote:
> > > So then is the real purpose of using varchars, to save disk space? ( I
> > > realize this is probably a general database question, just
> > trying to learn).
> >
> > + your datafile will be smaller which saves disk IO. In
On Thu, Nov 08, 2001 at 05:46:35PM -0500, Tony wrote:
> On Thursday 08 November 2001 10:55 am, Paul DuBois wrote:
> > At 10:00 AM -0500 11/8/01, Tony wrote:
> > >Does anyone know if putting (or grouping) varchar columns at the end of a
> > >table provides any performance improvements? My indices
On Thu, Aug 16, 2001 at 10:38:46PM -0400, Xavier Leoncini wrote:
> I have the following problem:
> When displaying a select * query from a table
> I get the following: (just showing the end).
>
> | | | 2928 | 1611100 |
> | | | 2929 | 1251300 |
> +--++--
On Fri, Jun 15, 2001 at 09:54:32AM +0200, Wouter de Jong wrote:
> On Thu, Jun 14, 2001 at 05:05:56PM -0700, Justin Bauer wrote:
> > You can do load balancing, you just need to have the same information on
> > each server. With mysql you would use "Replication" to keep the servers
> > sync'ed.
>
On Mon, May 21, 2001 at 05:13:44PM -0400, Peter L. Berghold wrote:
> On Mon, May 21, 2001 at 03:21:10PM -0500, Tim Thorburn spake thusly:
> *] Can someone here recommend a good Telnet program (with SSH) that I can use
> *] to connect to my servers MySQL database?
> *]
Seeing your mailclient (X-
taxt/plain
On Wed, Mar 14, 2001 at 03:48:28PM -0900, Josh Burroughs wrote:
> We recently moved our hardware inventory database off of access (yay!)
> over to mysql. During it's days as an access database it aquired a
> numbered of duplicate entries. In every case (or at least the ones I'm
> working on) the s
40 matches
Mail list logo