ompile it as i did, when is my problem?
>Fix:
no idea yet
>Submitter-Id:
>Originator:JanK
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity: critical
>Priority:
>Category:
data/log/bin-log
> > binlog-ignore-db = db_1,db_2,db_3
> >
> You should have 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 PROTECT
----- Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* ht
.
>
select name,key from table group by name,key;
> 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
query".
>
> But, I can connect from 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] -
_/ _/ _/ _/ _/
zal_r` char(1) default NULL,
PRIMARY KEY (`id_r`),
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' (er
> 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,
> >
s, but with the temporary form table MySQL creates when
> you do an ALTER TABLE. Anyway, the problem seems to be fixed, so you
> should update to >= 4.0.7.
>
Well, I'm using 4.0.8
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/
NULL,
> -> `zaplac_r` char(1) default NULL,
> -> `wplaczal_r` char(1) default NULL,
> -> PRIMARY KEY (`id_r`),
> -> KEY `nip_h_index` (`nip_h`,`nrpok_p`)
> -> ) TYPE=InnoDB;
> Query OK, 0 rows affected (0.01 sec)
>
> mysql&g
bout this.
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> ---
> InnoDB - transactions, hot backup, and foreign key support for MySQL
> See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
>
> sql q
13: Lost
> connection 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] -
_/ _/ _/ _/ _/ Wirtualn
o 150)
>
> how can i create the database without creating
> explicitly an index on each foreign keys of my
> database?
>
You can't
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
TECTED]Ph : (03) 8344 1273
>
>
>
> -----
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
&g
t;>>>>Query OK, 0 rows affected (0.00 sec)
> >>>>>
> >>
> >>[skip]
> >>
> >>
> >>
> >
> >--
> >
> >
> >warm regards
> >Vinita Vigine Murugiah
> >Email : [E
ently doesn't support stored 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] -
_/ _/ _/ _/ _/ Wirtua
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
--
_/_/ _/_/_/ -----
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
> Now law_words has 228207 records and that request takes
> about 2 seconds on a pc with 1GB of RAM and dual Pentium III XEON
> 550Mhz, which is TOO MUCH! Explain shows thart mysql is
> using ' range' and primary index, and about 500 records for each
> table.
Try add index on
l2-6f0-15.MYI' (Errcode: 13)
>
There is something wrong with your file privileges.
error 13 means permission denied
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Tr
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
---
> 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 <[EMAIL PROTECTED]>
uery. The primary key is an
> auto_increment field 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] -
_/ _/ _/ _/ _/
her table without
> the foreign key constraint, drop original one and rename.
>
sql, query
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, te
.query > did.out
Notice there is no space between -p and your_password.
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==*
gt; log files to the safe place? I suppose I should flush tables 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.
--
_/_/
w Table and, if you want to transfer data do insert
into NewTable as select * from OldTable;
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gd
plicated. What will happen if for
> example one master host adds a record to the child table, and the other
> deletes its master record? Rafal
> --
> _/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
> _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.
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
---
are not replication safe in 3.23 :(
MySQL
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-
nd__FP3THD + 2276
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. (
+ 303
>
> RJ> Any ideas?
>
> Can you create a repeatable testcase for it ?
Not really :(. I tried the same operations and this time it didn't crash
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http:/
of InnoDB
type.
query,sql,table
--
_/ _/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/
MUL(), but is there anything comparable ?
>
Nope, you have to write your own UDF.
sql, table
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta
B.ID_country =7)
>
Subqueries are not supported in mysql 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
_/_/_/_/ _/_/_/
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
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
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
to create indexes manually, though.
--
_/_/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* h
> installing so I would be very greatfull to anyone who could help me...
Put
default-character-set=greek
in your my.cnf file (you may have to create it if it doesn't exist)
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualn
+0xae): undefined reference to `__pthread_sizeof_handle'
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ł J
+0xae): undefined reference to `__pthread_sizeof_handle'
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
P.S. database, sql,
ed to come up in 4.0, which will be released
> this Autumn.
So in release 4.0 there will be multitable updates, not only deletes?
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/
Alok Kaushik wrote:
>
> I am installing mysql on red het linux from .rpm distribution.Would you
> please tell me that what is the default port number of mysql sql server on
> it.
3306
--
_/_/ _/_/_/ - Rafał Jank [EMA
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 [
user: '[EMAIL PROTECTED]' (Using password: YES)(0), retry in 60 sec
>
> I re-input my GRANT several times (checking/retyping the password each
> time), then connected remotely with the mysql -h option (not a problem)
>
> Has anyone else encountered this problem, and/or does a
row, but prefers to use
> 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
--
_/_/ _/_/_/ -
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 ta
obber (reg:QI 18 fpsr))
> > > (clobber (reg:QI 17 flags))
> > > ] ) -1 (insn_list 4 (nil))
> > > (nil))
> > > sync0sync.c:1259: confused by earlier errors, bailing out
> > > make[4]: *** [sync0sync.o] Error 1
> &
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 PROT
as crashed. Repair 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
_/ _/ _/
select a.ename,a.deptno from emp a,emp b where a.deptno=b.deptno and
b.ename='SCOTT';
MySQL doesn't support subselects;
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://w
Järkeborn 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 P
ble has crashed. Repair it with command:
repair table dbname;
--
_/ _/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/
set-variable= thread_cache=8
What about increasing the key_buffer size?
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, t
dzie_tak values
('Wojciech')
Why is mysql locking table during insert operastion? The version is 3.23.22, so
it shouldn't behave like this...
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://
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'
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:
http://www.mysql.com/manual.
>
> 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
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
ning query 'drop table MY_SHOP.t'
> 011031 3:09:04 Error 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] -
_/ _/ _/ _/ _/
d over-write you initial files, or does 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) 52
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 -I./.
e of replication possible?
Only if you install two instances of MySQL on slave.
--
_/ _/ _/_/_/ - Rafa? Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 11
Hi,
I have set max_user_connections to 80 on my database. But that doesn't seem to work -
I have more than 130 connections from one user. What can be the reason?
I'm using version 3.23.47
Rafal
-
Before posting, please check:
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
You have an error in your SQL syntax
> near '(*) from test' at line 1.
>
You shouldn't have this space between COUNT and (*).
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/
t 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]
gt; > WHERE Report LIKE 'TOL%'
> > "
> >
> You have to use version 4.x for unions to work. In 3.23.x you have to use
> temporary tables.
>
> --
> _/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
> _
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, q
Ryan wrote:
>
> Is it possible to store raw data (like image data) in mysql? If so, how can i
>accomplish it? (Should i need to make user-defined type?) Otherewise, what other
>databases support storing raw data?
You can use blob type.
--
_/_/ _/_/_/ - Rafał
-lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath
> -Wl,/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 S
ix it?
>
> SELECT l.load_no l.date FROM loads l, 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
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscrib
04 9:09:22 Found old style password for user 'helpdesk'. Restart using
> --o
> ld-protocol
>
> mysqld ended on Mon Jun 4 09:09:22 EDT 2001
>
> mysqld started on Mon Jun 4 09:44:39 EDT 2001
>
> 010604 9:44:41 Found old style pa
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
able2.field=table1.field)
where table1.field is null;
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/
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
n to something bigger than tinyint
--
_/ _/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/
78 matches
Mail list logo
