In the last episode (Dec 31), Harta Teo said:
Just wondor how InnoDB handle Multi Level Transaction, For example,
BEGIN
DELETE FORM table1 WHERE id = 123
BEGIN New Transaction Level 2
DELETE FROM table1 WHERE id = 234
COMMIT --- Level2
ROLLBACK ---Level1
The manual (
To drop all tables, yes do a drop database.
To drop all with something like a exclude, no.
What you can do is an export of the tables you don't want to drop, then do a drop
database + create database + import
Marc.
-Message d'origine-
De : Nitin Mehta [mailto:[EMAIL PROTECTED]
Envoyé :
Hi John,
- Original Message -
From: [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 2:28 AM
Subject: Re: How does key buffer work ?
Matt,
One last question and then I promise to drop the topic ... what would
be
the best way to force a complete load of an index into the key buffer
thanx for reply but not a good idea. Though i did it through PHP script
Nitin
- Original Message -
From: Mechain Marc [EMAIL PROTECTED]
To: Nitin Mehta [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 16, 2004 1:38 PM
Subject: RE: is this possible?
To drop all tables, yes
Hi all,
i want to store an unfixed number of object-characteristics
of an unfixed datatype for 1-8000 objects. Data is mostly
read, rarely written. Is there an quite optimal table-structure
for that?
If i use one table for all characteristics i need as many
columns as there are datatypes used.
Hi all,
Will MySql 5.0 (and higher) allow to reference the result set of a stored procedure in
the FROM clause of a query (... so as using Microsoft SqlServer, Sybase ASA, Oracle,
etc) ?
For example:
SELECT * FROM sp_test (arg1, arg2, )
We are planning to migrate to MySql . but this
Hi.
I would like test mysql 4.1.1 with php but, i cann't connect to it. I have
error when use password :(
From mysql CC beta 0.9.4 i could connect to my 4.1.1 server to.
I can connect to mysql 4.1.1 - only if i have no password set.
What's going on ?
Regards.
Irens.
--
MySQL General
Hi,
Sergei Golubchik wrote:
Hi!
On Jan 13, Kurt Haegeman wrote:
Hi,
When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (HY000): 121 when fixing table
Sorry, I still cannot repeat this :(
Could you try to create a smaller test case ?
I
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
Hmm
Will you have an object hierarchy of any type to speak of? If so, you
should be able to factor quite a few things out, but then you're going
to have the problem that objects further down the tree will take longer
-Message d'origine-
De : I.P. [mailto:[EMAIL PROTECTED]
Envoy : Friday, January 16, 2004 6:41 AM
A : [EMAIL PROTECTED]
Objet : Mysql 4.1.1 and PHP
Hi.
I would like test mysql 4.1.1 with php but, i cann't connect
to it. I have
error when use password :(
From mysql CC
Depending on your language, you might be able to fudge this up to work
for yourself. In C/C++ I have a function that automagically decides
whether I am beginning a new transaction when I am calling it or whether
I want Oracle-style nested transaction functionality. My rollback
function is aware of
-Message d'origine-
De : Mikael Fridh [mailto:[EMAIL PROTECTED]
Envoyé : Friday, January 16, 2004 4:19 AM
À : Ugo Bellavance
Objet : Re: setting a variable
On Thursday 15 January 2004 19.51, Ugo Bellavance wrote:
No problem, I thought I could change any variable at
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
You'll find that the problem is probably related to the new password
format that the 4.1.x stream of MySQL uses. You can start the server
with some switch (listed in the manual) that allows use of old
passwords.
Regards,
I have created a sql statement that enables me to select all entries in
to MySQL that are dated today, I am trying to do the same for all items
that are now one day old and also two days old etc
I am doing this:
SELECT *
FROM table
WHERE category = 3 AND show = 1 AND date = NOW()-1
I
Thanks Chris,
Will you have an object hierarchy of any type to speak of?
no hierarchy, they're all roots.
Which language are you looking at building this funky thing
in? If it's
Java or C++, you might want to look at persistant object
stores that are
specifically for this purpose (for
On Fri, 16 Jan 2004, tait sanders wrote:
yep I've already done this.
everything I do comes back with the same error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
I even deleted the mysql.sock and used 'mysql_config --socket' to
recreate it.
this
Hello
I've installed MySQL 5 and I seem to have a couple of problems with it (or it does
with me).
After installing into a clean environment I created a new server (rm_development) in
the Control Center, and then created a new database.
The first problem/query is after having created a table
Hi,
Any ideas why it's looking for the table .1?
Could you post your query?
Take care,
Aleksandar
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, 15 Jan 2004, Jamie Murray wrote:
Hi Guys,
after waiting about a minute I get
ERROR 2013 (HY000): Lost connection to MySQL server during query
See if changing any of the
SHOW VARIABLES LIKE 'net%timeout';
helps.
Not sure why the crash popup comes up, however.
cheers,
Tobias
--
Hi !
mysql 5.0 is _really_ cool.
this bug should be reproducable:
( cat table.sql ; ./populate.pl ; ./perfect_game.pl 32 ) | mysql test
after that executing the same procedure with same parameter again,
the connection is lost:
Hi there:
I was wondering if it's possible to perform an elseif in SQL Using MySQL
3.23.49-log running on Debian Linux?
My System:
--
* MySQL 3.23.49-log
* Debian Linux
* PHP 4.2.1
The Logic:
--
IF condition1 - THEN query column1.
ELSEIF condition2 - THEN query column2.
ELSE
Michael,
the crashes below happen in independent areas of code. The 2 first are
inside InnoDB, and the third inside MySQL. This looks like random thread
crashes, or random memory corruption.
I assume that you have my.cnf set so that the memory usage cannot approach 2
GB.
You are running a
* Russell Michell
I was wondering if it's possible to perform an elseif in SQL Using MySQL
3.23.49-log running on Debian Linux?
It sure is. See below.
My System:
--
* MySQL 3.23.49-log
* Debian Linux
* PHP 4.2.1
The Logic:
--
IF condition1 - THEN query column1.
I'm trying to use the week() or weekofyear() functions in a php script.
Here's a clipping of the code:
$sql = SELECT WEEK('2004/06/01');
echo $sql; //used for checking purposes
$week = mysql_query($sql, $link);//where $link is in an inc file
linking that file
How can change the syntax of the query below to a
LIKE criteria query?
SELECT ORGANIZATION_ID, ORGANIZATION_NAME,
MATCH (ORGANIZATION_NAME) AGAINST (houston) AS score
FROM ORGANIZATION
WHERE MATCH (ORGANIZATION_NAME) AGAINST (houston)
ORDER BY score DESC, ORGANIZATION_NAME ASC
Ben Whitesell wrote:
I'm trying to use the week() or weekofyear() functions in a php script.
Here's a clipping of the code:
$sql = SELECT WEEK('2004/06/01');
echo $sql; //used for checking purposes
$week = mysql_query($sql, $link);//where $link is in an inc file
toni baker wrote:
How can change the syntax of the query below to a
LIKE criteria query?
SELECT ORGANIZATION_ID, ORGANIZATION_NAME,
MATCH (ORGANIZATION_NAME) AGAINST (houston) AS score FROM ORGANIZATION
WHERE MATCH (ORGANIZATION_NAME) AGAINST (houston)
ORDER BY score DESC, ORGANIZATION_NAME
Mysqlians,
Very Simple, Slave A is all MyISAM tables and replicates
~15writes/sec for ~200k/s with a top load of 0.00. I change 1 table(100mb
data 1.5writes/sec) to innodb and the top load changes to .3 . I have set
innodb_trx_commit=0 and set noatime on the filesystem ( ext3
Hello,
Hopefully you sql guru's can help me out a bit. :)
Here is the short example of what I want to accomplish. I wish to
have the difference between two different select queries.
So if one query pulls records 1,2,3 and 4 and the second pulls records
1 and 4 I wish to have only the records 2
I've just downloaded the J/Connector 3.0 but there is no MysqlXaDataSource
in it (actually there is not com.mysql.jdbc.jdbc2.optional.xa package), even
do in the connector documentation it's written about it.
I would like to try using mysql 4 with j/connector 3.0 because something I
got a lot of
* sulewski
[...]
What I need is all records in table 1 that will
not link to table 2 such that relid=rid and vid=46
Sounds like a job for LEFT JOIN...?
Join to the rows you do NOT want with a left join, and put as a condition in
the WHERE clause that a joined column IS NULL. Something like
Roger,
Thank you for the feedback. But unfortunately this doesn't work. The
problem is that rid will never be null. I'm trying to find the item in
tab1 where a link cannot be created in tab2 where tab2.rid=tab1.id and
tab2.vid=46 because there is no record in tab2. Not that the record may
Roger,
In regards to my last e-mail what would be great is if I can get all
the records in tab1 then subtract from there all the records that match
the query tab1.id=tab2.rid and tab2.vid=46. The result would give me
what I need but alas mysql doesn't support minus.
Joe
On Friday, January
the crashes below happen in independent areas of code. The 2 first are
inside InnoDB, and the third inside MySQL. This looks like random thread
crashes, or random memory corruption.
My colleague tells me that the third stack trace (the one inside MySQL)
is from a RESET MASTER. This server
That is the whole point of a left join.
It joins to a null record when the appropriate right record does not exist.
sulewski wrote:
Roger,
Thank you for the feedback. But unfortunately this doesn't work. The
problem is that rid will never be null. I'm trying to find the item in
tab1 where a
Gerald,
Your right. You and Roger hit it on the head. Stupid me miss read
Roger's original post.
Last night I was banging my head on the left and right joins but I
didn't understand it until I read Gerald's last note. Plus I didn't
realize you can put two conditions in the ON clause which is
Hello all.
Any help on the following matter is greatly
appreciated. I tried to import a text file
containing numerous special characters (À, Æ, Ç ,
etc.) but they convert to incorrect characters.
I can paste them and write them correctly using a
form submission created with LP6. However,
How do I figure out the physical disk storage size of a table and of the
containing database? I'm using InnoDB. When I look at the directory
through the OS, I see the Ibdata1 file is about 1GB and a
MyServer-bin.06 file that is about 900MB. There are also other -bin
and various log files
I was wondering how many records A mysql table can comfortably handle.. and
which table type supports the greatest amount of record capacity. Can I
have a few million records in 1 table? Over 10 million? Thanks !
I have a new install completed. I can connect locally and have created a database from
within my Terminal program on a Mac. When attempting to create a remote database
connection from my HTML design program, I get:
1130 Host '66.51.193.2' is not allowed to connect to this MySQL server
The
I'm using mysql 3.23.55 and Linux Mandrake 9.1. I have about 60 users
connecting to mysql using our accounting system. The users get some times a
Too many connections error. I have set max_connections at 200, and the
system opens only one connection per user at start up. Can somebody indicate
Hi Brad,
create table entity (
ent_id number primary key,
ent_namevarchar(50)
);
create table nameval (
nv_id number primary key,
nv_ent_id number,
nv_name varchar(50),
nv_val varchar(50)
);
That is
On Fri, Jan 16, 2004 at 10:14:08AM -0800, Andrew Kwiczola wrote:
I was wondering how many records A mysql table can comfortably handle.. and
which table type supports the greatest amount of record capacity. Can I
have a few million records in 1 table? Over 10 million? Thanks !
Hi, Andrew.
Victoria Reznichenko wrote:
Andrew DeFaria [EMAIL PROTECTED] wrote:
Victoria Reznichenko wrote:
Andrew DeFaria [EMAIL PROTECTED] wrote:
As you can see I when I delete from user (the parent table) the
useropts (child table) entry remains. Shouldn't it be deleted?
Heikki Tuuri asked me to look
Hi,
I wanted to take advantage of the InnoDB 'gap' locking to lock 'non-existence' of a
row, the way the
manual recommends. I tried to do this by using 'select ... for update', using the
'mysql' client
from two separate sessions as shown below:
Session 1:
set AUTOCOMMIT=0;
begin;
select *
I have the following code:
//try the mysql connection
mysql_init(mysql_connection);
if(!mysql_real_connect(mysql_connection, db_host, db_user, db_pass,
db_db, 0, NULL, 0)) {
flockfile(stderr);
fprintf(stderr, %s: Failed to connect to
Hi!
On Jan 16, angela wrote:
I've just downloaded the J/Connector 3.0 but there is no MysqlXaDataSource
in it (actually there is not com.mysql.jdbc.jdbc2.optional.xa package), even
do in the connector documentation it's written about it.
I would like to try using mysql 4 with j/connector 3.0
To those who want to try out a live MySQL on the Net can use the
following from NAVICAT. You can choose client tool of your choice! Get
more information about it on NAVICAT website: www.navicat.com
IP/Server: server1.navicat.com
User: navicat
Password:navicatdemo
Port:
Hi!
After some tries i finally managed to compile mysql 4.0.17 with
ssl-support (openssl 0.9.7c, compiled with minGW 3.1.0.1)
under windows2000.
SHOW VARIABLES LIKE 'have_openssl' returns YES.
when starting the server the following happens:
$mysqld.exe --port=3306 --ssl-ca=cacert.pem
From: Matthew Stuart [mailto:[EMAIL PROTECTED]
I have created a sql statement that enables me to select all
entries in to MySQL that are dated today, I am trying to do
the same for all items that are now one day old and also two
days old etc
I am doing this:
SELECT *
FROM table
Hi,
When I enter this query select * from books, it gives me this error message: Error
1146: Table test.1 doesn't exist. What does that mean? This is MySQL 5.0 and I just
installed today. How can I solve this problem?
Thanks in advance.
Jacklty
Hi
I have a web app that use's PHP/Mysql/MYISAM. I am starting to think I need
INNODB table type.
Scenario 1:
I have noticed that if two users open a record to edit it
in two different browsers
and they edit the same field and then click update,
the last user/browser gets written to the db,
Greetings all, I'm trying to grant a user the file privelege and am
getting error messages. Here's my SQL statement
mysql GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY
'password123';
It gets the following error:
ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual
On Fri, 16 Jan 2004, Jough P wrote:
Greetings all, I'm trying to grant a user the file privilege and am
getting error messages. Here's my SQL statement
mysql GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY
'password123';
It gets the following error:
ERROR 1144: Illegal
Hello,
I have a Perl CGI script which uses DBI to access MySQL.
I noticed that each query through the Perl CGI script using DBI has a
connect, query and then quit.
I was wondering if there is a way of keeping the connection persistent
to Mysql through the Perl CGI script.
In my Apache httpd.conf
Hello,
I run an ISP where our web customers have access to the MySQL server. When
they want a database, they request it through me and I add it. I was just
curious if this is the common way it is done, or if there is a safe way
they can add their own?
Thanks,
Bryan
--
MySQL General
Hi !
Anyone find a solution for this problem ?
We have 2 mysql server with same problem. Happen like every 1-2 months.
Regards,
--
Arnaud Pignard ([EMAIL PROTECTED])
Frontier Online - Opérateur Internet
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I wanted to thank everyone for their responses and information regarding
this. I apologize, I thought I had already replied.
Anyhow, I proved my point to our software guy, enough that he is willing
to look into it further. Although I have a feeling he isn't going to want
to do it (but at least he
Hi Alex!
On Sat, 2004-01-17 at 05:50, Zeltser, Alex wrote:
Hi,
I wanted to take advantage of the InnoDB 'gap' locking to lock 'non-existence' of a
row, the way the
manual recommends. I tried to do this by using 'select ... for update', using the
'mysql' client
from two separate
Hmm...have you looked at Rekall?
www.total-rekall.co.uk
Also, you might want to check out OpenOffice.org's database interface
features
Regards,
Chris
On Sat, 2004-01-17 at 11:12, Bryan Koschmann - GKT wrote:
I wanted to thank everyone for their responses and information regarding
this. I
Hello,
we are in the process of upgrading our machine and currently running the
following RPM's
MySQL-server-4.0.15-0
MySQL-bench-4.0.15-0
MySQL-embedded-4.0.15-0
MySQL-devel-4.0.15-0
MySQL-client-4.0.15-0
MySQL-shared-compat-4.0.15-0
MySQL-shared-4.0.15-0
this is on a RH/Linux 7.3(i686)
do we
Hello all,
I'm trying to query a database of speed test results for display on a php
page. The results are fully-qualified machine names, often very long. What
I'd like to do is trim it down so only the main domain name is left for
display: for example, '68-65-69-187.vnnyca.adelphia.com'
* dan
I'm trying to query a database of speed test results for display on a php
page. The results are fully-qualified machine names, often very
long. What I'd like to do is trim it down so only the main domain name
is left for display: for example, '68-65-69-187.vnnyca.adelphia.com'
On Fri, 2004-01-16 at 17:05, Bryan Koschmann - GKT wrote:
Hello,
I run an ISP where our web customers have access to the MySQL server. When
they want a database, they request it through me and I add it. I was just
curious if this is the common way it is done, or if there is a safe way
they
64 matches
Mail list logo