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:
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.
--
_/_/
.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
_/ _/ _/ ==*
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
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] -
_/ _/ _/ _/ _/
---
> 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]>
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
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
> 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
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
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
--
_/_/ _/_/_/ -----
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
t;>>>>Query OK, 0 rows affected (0.00 sec)
> >>>>>
> >>
> >>[skip]
> >>
> >>
> >>
> >
> >--
> >
> >
> >warm regards
> >Vinita Vigine Murugiah
> >Email : [E
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
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
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
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
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
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] -
_/ _/ _/ _/ _/
> 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,
> >
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
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] -
_/ _/ _/ _/ _/
.
>
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
----- Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ ==* ht
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
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
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] -
> _
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]
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
_/_/_/_/
> 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
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
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
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
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
_/_/_/_/ _/_/_/
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
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
_/ _/ _/
+ 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:/
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. (
are not replication safe in 3.23 :(
MySQL
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Traugutta 115c, 80-
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
---
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.
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
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
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:
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
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./.
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
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] -
_/ _/ _/ _/ _/
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
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.
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'
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://
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
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
_/ _/ _/
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
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
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
_/ _/ _/
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
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
> &
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
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
--
_/_/ _/_/_/ -
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
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 [
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
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
_/_/_/_/ _/_/_/
+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,
+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
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
_/ _/ _/
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
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 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
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
> 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
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
-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
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ł
78 matches
Mail list logo
