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 threads
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
Informatiefabriek
(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 General Mailing List
For list archives: http://lists.mysql.com/mysql
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
2kljh
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 14' or 'where property_field 1025'
if you look for more than one property.
Just your average SET
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 are
On Thu, Feb 13, 2003 at 03:04:08PM +0300, Artem Koutchine wrote:
homemade fulltext searchsystem
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
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
need
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 poor
threads id` it does get registered as 'killed' (According to `mytop`). But
the thread refuses to die. They do die eventually but it can take a
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), owner
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 I:
- make _all_ innodb tables myisam
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,
-
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 you can solve this issue using the USE INDEX syntax
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
for the individual columns
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 syntax
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 create a separate index on just
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
for the individual columns
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.
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.com/ (the list
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
Informatiefabriek
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
Informatiefabriek
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 how come
/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 thread, e-mail
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
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 are all
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 the end,
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 record
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.
Well,
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
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
38 matches
Mail list logo