t always uses InnoDB.
My company used MyISAM for many data...
had problems with competing access.
With innodb we did not have plus no claim.
For great volume of data, InnoDB.
InnoDB,Query,MySQL
---
/mysql-development/mysql-4.1-win'
make: *** [all] Error 2
scribthree:/temp/mysql-development/mysql-4.1-win#
What is the error ?
InnoDB,MySQL,QUery,Help !
---------
++ Dyego Souza d
,SQL,query,HELLLP !!!
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
,SQL,HELLLP !!!
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
with mySql 4.0.14, the record that is updated is simple deleted.
My System is a Debian Linux box , with kernel 2.4.20 with 768 of RAM
using InnoDB tables ;)
InnoDB,MyISAM,SQL
-----
++ Dyego Souza do Carmo ++
pub/mysql/secret
Tnks in advance !
innodb,mysql,help !
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
eeelp...
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T
mysql,innodb,query
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
-
The on
...
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
EADER'
-----
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M
ning in Linux box kernel 2.4.21
with 768MB of ram
-------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
e FileName is l5.zip
---[cortar]--
-----
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B
end file to the list...
exists a FTP to put the file ?
sql,query,innodb,hep please
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvime
,help
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T
rchar(50) NOT NULL default '',
`Cidade` varchar(60) NOT NULL default '',
`Bairro` varchar(40) NOT NULL default '',
`Estado` char(2) NOT NULL default '',
`Mensalista` tinyint(4) NOT NULL default '0',
`Cep`
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
] Error 127
make[2]: Leaving directory `/temp/mysql-development/mysql-4.0/libmysql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/temp/mysql-development/mysql-4.0'
make: *** [all] Error 2
on make command.
My system is Linux 2.4.21-pre5-ac3
The last bk pul
after this start mysqlserver and InnoDB start normally.
ps: To use MySQL/InnoDB on raw device you need the permission of
device to user mysql:
chown mysql /dev/rdsk/c2t1d0s0
---
plement views in MySQL Server around version 5.0
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
-
his may be related to the configuration as well as the start / stop
P> parameters, along with mandatory & optional ones.
---------
++ Dyego Souza do Carmo +
the rules of key constraints.
-------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
AM need to "MASQ" the ENCODE and DECODE
funcions do not print the PASSWORD on log-update file... if this work , the
security of DATA on MySQL is very good.
is possible ?
My System is MySQL 4.0.11-PRO/InnoDB on Linux/Windows :)
-----------
query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
-
The
ftware house... the MySQL is not prepared for this
?
exists the method to secure a table with "password" ? or the secure is
only the filesystem permissions ?
----------
o simple ?
JT> only rename and the database is "opened for world" ?
JT> please help in advance ;)
JT> Tanks
JT> Tanks very much
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
g is very strange !
Heiiki , is a InnoDB bug ?
sql,query
-------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
nks
Tanks very much
sql,query,innodb,mysql
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
-
read 14 did to cause the crash. In some cases of really
bad corruption, the values shown above may be invalid.
The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
information that should help you find out what is causing the crash.
sql,query
---------
e in my decision :)
The suggestion bout ID in database and store an a file system, it is very
interesting , but if i loose the id´s ? atomically i loose the
images correct ?
Tanks in advance !
sql,query,tnks
---------
++ Dyeg
: InnoDB
Operation System : Windows ( 98/ME/NT ) and Linux ( 2.4 )
Disk Types : IDE and SCSI ( depend of volume )
sql,query,urgent,hehe
-----
++ Dyego Souza do Carmo ++ Dep. Desen
ed is more fast in the last case or no ?
Tanks,
sql,query
-----
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S
,query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T
The location specified
in the site is old.
sql,query
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
-
Tanks !!!
SQL,query,h0h0
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T
port is deprecated and is not present in next version of
mysql ( 4.x )
sql,query
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
---
round: --without-docs on ./configure line
sql,query
-------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
ld help you find out what is causing the crash.
- cut
Is a bug or a problem ?
My System is MySQL 4.0.8 and Linux 2.4.18 with reiserfs.
ps: The development tree is down ?
sql,query
-
++ Dyego Sou
I'm confused , what is the difference and raw device and a disk
partition ?
ex: on innodb I'm using /dev/sda1 for raw device, is it correct ?
tnks.
sql,query
-----
++ Dyego Souza do Carmo ++
oohhh, sorry the corrent page is :
http://www.mysql.com/doc/en/Installing_source_tree.html
sql,query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
nsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
you can download from CVS
http://www.mysql.com/doc/en/Installing_source.html
bye,
sql,query
-------------
++ Dyego Souza
is good :)
ps: i'm using MySQL 4.0.5
sql,query
-------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
---
query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T
..
shell> ./configure # Add your favorite options here
shell> make
if you not type "aclocal; autoheader; autoconf; automake;" in
innobase directory , the compilation print a error.
i´m true ?
Tnks,
sql,query
------------
. This is wonderful
to websites.
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
--
Starting from 4.0.6 mysql is declared as gamma ?
sql,query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C
Cannot add a child row: a foreign key constraint fails
Is there a way to create constraints that implements the rules I
need?
Bye,
sql,query
-------------
++ Dyego Souza do Carmo ++
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
page i could read that if my software only depends on
mysql to run , i have to order a licence , if not ( in multi-database
case ) , i haven´t to order a commercial licence.
How this licences works ?
according the page i had understood i don't need to buy a licence. am
i right ?
Tnks,
must i use ?
I am confused :(
Tnks,
sql,query
-----
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I
bles.
no warnings
bye,
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A
nformation about mysqldump :
4.8.5 mysqldump, Dumping Table Structure and Data
http://www.mysql.com/doc/en/mysqldump.html
bye.
-------------
++ Dyego Souza
sql; ( inside mysql client )
bye,
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I
tables"
before start copy of .MYD , .MYI and .frm files.
bye,
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
-
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=2
set-variable = innodb_lock_wait_timeout=50
bye,
---------
++
-start the service ( with mysqld-max-nt.exe ) and
try show variables like '%have%innodb%';
bye,
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
S
Tnks for attenction...
sql,query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
-
The only stupid
ut here.
tnks.
sql,query
---------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I
attenction...
sql,query
-----
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M
ot; what will
happen ?
what is the diference ?
-------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
---
ffected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from teste;
+---+
| valor |
+---+
| 1 |
| 2 |
+---+
2 rows in set (0.00 sec)
mysql> ROLLBACK;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from teste;
Empty set (0.00 sec)
OK ?
---
ime. I wouldn't want the record
CB> number to eventually reach the ceiling for the datatype of
CB> the field.
CB> Any insight would be greatly appreciated.
CB> Chris
try exec this query:
alter table auto_increment = 0;
-----------
er version?
S> I want to use Innodb with autoextend.
Yes, in <= .52 is normal... use the 3.23.53 version.
http://www.mysql.com
-------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
---
Exists plans to release 4.0x series a "stable" ?
When ?
And 4.1 series... exists plans to release a "alpha" ?
when ?
tnsk ;)
sql,query
-----
++ Dyego Souza do Carmo ++
sql,query
-----
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
-
The only stupid quest
sql,query
-----
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M
( with ReiserFS ) :D
sql,query,mysql !
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
to "global operation" ?
1 client = 1 thead
ps: my system is mysql 3.23.52 , running on Windows 2k with 1G of RAM
... using tables with myisam and innodb table handler !
Tnks for attenction ! :)
-----
++
uffer = 8M
set-variable = write_buffer = 8M
-------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B
.
tnks.
-----
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M
with MYISAM table handler !
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
72 matches
Mail list logo