it as i did, when is my problem?
Fix:
no idea yet
Submitter-Id: submitter ID
Originator:JanK
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity: critical
Priority:
Category: mysql
Class: support
first.
You can mysqldump InnoDB tables too. Copying InnoDB files (data or redologs)
without shuting down mysql is a bad idea.
You can also use mysql replication if you have spare server and do a cold
backup from it.
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED
always asked password even if I've already specified it in the previous
command line (mysql)
Enter password:
mysql -h localhost -u root -pyour_password mysql did.query did.out
Notice there is no space between -p and your_password.
--
_/_/ _/_/_/ - Rafa Jank [EMAIL
and rename.
sql, query
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* http://szukaj.wp.pl
and are not specified in the insert.
Looks like you have reached maximum number allowed for int. Try to change type
of this column to bigint.
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
[EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
Is this a way to do it? I've just upgraded mysql to vesion 4.0.10 and found
out that there are these new files on the slave. How can I rotate them?
sql and so on...
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http
with your file privileges.
error 13 means permission denied
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
! Explain shows thart mysql is
using ' range' and primary index, and about 500 records for each
table.
Try add index on (l_id,w_id) and see if it helps. And see if it runs faster
without distinct.
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED
On Mon, 20 Jan 2003 13:01:55 -0700
Zak Greant [EMAIL PROTECTED] wrote:
On Mon, Jan 20, 2003 at 01:14:53PM +0100, Rafal Jank wrote:
Hi,
I've just downloaded version 4.1 from bk and have problem with building
it. What version of automake is needed? Because after
aclocal
I get
procedures and triggers... but I
guess, there must be some way around. If anyone has ever faced this problem,
please let me know.
Use cron or at.
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
Hi,
I've just downloaded version 4.1 from bk and have problem with building it.
What version of automake is needed? Because after
aclocal
I get:
aclocal: configure.in: 459: macro `AM_PROG_AS' not found in library
P.S. MySQL, query,database
--
_/_/ _/_/_/ - Rafa Jank [EMAIL
Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* http://szukaj.wp.pl
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* http://szukaj.wp.pl
on each foreign keys of my
database?
You can't
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
seems to be fixed, so you
should update to = 4.0.7.
Well, I'm using 4.0.8
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 11:04 PM
Subject: Re: Bug in foreign keys
Rafal,
- Original Message -
From: Rafal Jank [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday
for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
sql query
.
Subject: Re: Bug in foreign keys
From: Rafal Jank
Date: Fri, 10 Jan 2003 11:10:35 +0100
to MySQL server during query.
Have even tryed replacing IP with a host name and get the same error.
Which version of MySQL? What OS?
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul
`),
KEY `nip_h_index` (`nip_h`,`nrpok_p`)
) TYPE=InnoDB;
Now, when I try:
alter table rezerwacje add foreign key (nip_h,nrpok_p) references
pokoje(nip_h,nrpok_p);
I get:
ERROR 1005: Can't create table './test/#sql-932_4.frm' (errno: 150)
Why?
--
_/_/ _/_/_/ - Rafa Jank
At 16:11 +0100 1/9/03, Rafal Jank wrote:
Hi!
I have two tables:
CREATE TABLE `pokoje` (
`nrpok_p` char(10) NOT NULL default '',
`nip_h` int(10) NOT NULL default '0',
`lozka_p` char(2) default NULL,
`tv_p` char(1) default NULL,
`lazienka_p` char(1) default NULL,
`cena_p
linux to windowsXP mysql server(4.0.5 max).
Who knows the problem
Download and install version 4.0.5a
mysql, query
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul
;
Second, how do I translate my logic above into SQL? Or should I do it
in PHP?
You should do it inPHP
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237
Is there a way to create constraints that implements the rules I
need?
Not really. You would have to use deferrable constraints (checked at commit,
not after statement) like in Oracle. For now Innodb doesn't support it.
P.S. query,sql
--
_/_/ _/_/_/ - Rafa Jank
separate entry for every database:
binlog-ignore-db = db_1
binlog-ignore-db = db_2
binlog-ignore-db = db_1
P.S. sql,query
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul
Is table_cache parameter still important when using innodb table types?
I thought it's not, because there is no separate files for each table in
InnoDB
But now I see a lot of queries in opening tables and closing tables state.
Does increasing table_cache parameter may help?
Rafal
P.S. sql,
.
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax.
(58)5215625
_/ _/ _/ ==* http://szukaj.wp.pl
://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED
my.cnf file (you may have to create it if it doesn't exist)
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
, though.
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* http://szukaj.wp.pl
On Mon, 15 Jul 2002 11:58:33 +0200
Jarek Jarzebowski [EMAIL PROTECTED] wrote:
Jan Kudrman wrote:
Dear Michal,
I am not sure, but I think you can create an user will all the rights in
mysql - user (database - table) - this will solve your problem with full
access to all databases.
mysql version 3.23.50
Field kwData_wydania is of type date. As you can see, dates are different that
expected. Is this a bug?
Select ksiazka_wyd.kwId,kwData_wydania
- from ksiazka_wyd
Hi,
what is the maximum size of .MYI file MySQL can handle, assuming that
operating system can handle files bigger that 4G? In the manual there is a
section saying about size of the table, but what about indexes?
TIA
Rafal
yet.
Try this:
select A.* from A,B where A.id_person=B.id_person and ID_country=7
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58
have to write your own UDF.
sql, table
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* http
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* http://szukaj.wp.pl
0x8073637 handle_bootstrap__FPv + 303
Any ideas?
query,sql
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* http://szukaj.wp.pl
UPDATE satzungen SET titel='title', inhalt = 'context',
content_type='text/plain', data='data',kuerzel='kuerzel',
kennung='kennung', last_change = NOW() WHERE rowid = @rowid;
User variables are not replication safe in 3.23 :(
MySQL
--
_/_/ _/_/_/ - Rafa Jank
Hi,
I was wondering if I could achieve a speed increase if I did chattr +A to
mysql data files. I'm not interested in knowing when the table was last opened
for reading. But I'm affraid mysql uses it internally for something. Can I do
it? TIA
Rafal
table, database
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* http://szukaj.wp.pl
* from OldTable;
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* http://szukaj.wp.pl
On Mon, 28 Jan 2002 14:49:18 +0100
Harald Fuchs [EMAIL PROTECTED] wrote:
In article [EMAIL PROTECTED],
Tobias Kremer :: IT [EMAIL PROTECTED] writes:
Hi,
Thanx dn. I know how to build joined selects but the problem is that those
two tables are not joinable. I don't have an entry in
instances of MySQL on slave.
--
_/_/ _/_/_/ - Rafa? Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* http
I'm trying to compile version 4.0.1 from the source tree on RedHat 6.1.
Configure runs fine, but make gives me the following error:
gcc -DDEFAULT_CHARSET_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\
-DSHAREDIR=\/usr/local/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID
-DMYSQL_CLIENT
it
continue on?
It will become .1000
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/ ==* http
running query, slave aborted. Fix the problem,
and
This bug was fixed in version 3.23.37
magic words: database,table
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80
Hi!
Is there a possibility to rotate mysql error log without stoping the server?
TIA
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58
select count(distinct(email)) from subscribes;
select count(distinct email) from subscribes;
should work just fine
Magic word: sql
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
Hi!
Is it possible to change default table type from MyISAM to InnoDB, for example
by putting
set-variable = table_type=InnoDB
line into my.cnf file?
Thanks
Rafa
-
Before posting, please check:
insert operastion? The version is 3.23.22, so
it shouldn't behave like this...
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
Fred van Engen wrote:
Rafal,
On Mon, Sep 24, 2001 at 10:14:59AM +0200, Rafal Jank wrote:
Why is mysql locking table during insert operastion? The version is 3.23.22, so
it shouldn't behave like this...
If you mean it shouldn't behave like this because it does concurrent
inserts
dbname;
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/ ==* http://szukaj.wp.pl
Jrkeborn Joacim wrote:
Hi,
We have Oracle SQL statements that uses UNION is there an equivalent for this in
mySQL?
Not yet. It should be in version 4.0
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http
Hi,
I've noticed, that bin logs names are followed by three digits: 001,002 and so
on. What will happen when I reach 999? Will it start to overwrite my first logs?
magic words: MySQL, table, sql
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED
it with command
repair table accounting;
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/ ==* http://szukaj.wp.pl
='SCOTT';
MySQL doesn't support subselects;
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/ ==* http
insn_list 4 (nil))
(nil))
sync0sync.c:1259: confused by earlier errors, bailing out
make[4]: *** [sync0sync.o] Error 1
make[4]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase/sync'
So any suggestions to solve this problem ??? Thanx
--
_/_/ _/_/_/ -
filesort which would take quite a long time in this case:
mysql explain select * from dominf.domip order by ip desc;
Try using limit clause
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED
Rafal Jank wrote:
Peter Zaitsev wrote:
Hello mysql,
I was trying to load very huge (5GB 45mil rows) to the text dump in
sorted order (according to primary key).
The problem is mysql somehow does not wants to scan the table by
primary key to produce sorted output row
with the mysql -h option (not a problem)
Has anyone else encountered this problem, and/or does anyone have a
solution..
Have you given file privilege to user rep1 on your master server?
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna
hi,
since analyze table doesn't work for Innodb tables, where does optimizer get
statistics needed for making proper query plan from?
For example, how does it know which index is more selective or in which order
tables should be joined?
--
_/_/ _/_/_/ - Rafa Jank [EMAIL
'
linuxthreads.o(.text+0xba): undefined reference to `__pthread_handles_num'
linuxthreads.o(.text+0x119): undefined reference to `__pthread_handles_num'
collect2: ld returned 1 exit status
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna
4.0 there will be multitable updates, not only deletes?
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/ ==* http://szukaj.wp.pl
Hi,
is there a way I can assign quota to database users, so they want be able to use
all of my disk size? Ideally I would like to assign quota to each user
individually.
Is it possible at all?
Rafal
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED
Hi,
Is it possible to make MySQL create another bin log when current one grows to
the specified size?
Rafal
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237
;
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/ ==* http://szukaj.wp.pl
ail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/
Looks like you'll have to start mysql with --old-protocol.
Edit safe_mysqld - find the line where mysqld is started and add this option.
Then run safe_mysqld
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http:/
,/usr/local/lib/mysql
/usr/bin/ld: cannot find -ltermcap
That means that the linker couldn't find libtermcap.a file
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237
, invoiced i
WHERE l.dlvr_date 0
AND l.load_no != i.load_no
Maybe something like this (I havent't tried this) :
select l.load_no l.date FROM loads l left join invoiced i on
(l.load_no=i.load_no) where i.load_no is null and l.dlvr_date 0
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED
72 matches
Mail list logo