I start the management node, then the ndbd node, followed by mysqld API
node. mysqld (api node) starts, and I can log into it (mysql -u root
-p), but it is not listed as a "connected" mysqld(API) using ndb_mgm
show.
Is there some thing I have to clear? It did connect once, but will not
reconnect
Just did a google search on my company email because I'm receiving a lot of
spam and discovered that a lot of sites are taking mysql list and publishing
our emails everywhere.
E.g
www.webservertalk.com
archives.neohapsis.com/archives/mysql/
Is there any way to hide our emails so they don't appear
Ferhat BINGOL wrote:
Hi Scoot,
I do my table structure like that
CREATE TABLE `test_table` (
`timestamp` date NOT NULL default '-00-00',
`data` varchar(5) NOT NULL default '',
PRIMARY KEY (`timestamp`),
KEY `timestamp` (`timestamp`)
) TYPE=MyISAM;
Correct me if I'm wrong, but I think t
mysql> system echo hi there;
mysql> system ls -ls;
mysql> system uname-a;
all work on the 2.4.22-10mdk kernel and
the semi-colon is optional.
mysql> system echo "hi there"
should be also working, the first parameters 'echo' is recognized as the
command to execute, and the folowings strings the
Filip,
- Original Message -
From: "Filip Rachunek" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, October 18, 2004 10:33 AM
Subject: Varchar and InnoDB
Hello,
I have a big table in my InnoDB database (more than 10 million rows)
and it contains a column of varchar(4
Chris,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, October 18, 2004 10:24 AM
Subject: Which Filesystem to choose?
Hi,
I'm trying to set up a new Opteron-Based MySQL-Server.
The only thing I'm unsure about is which filesystem to choose.
Hi!
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 13, 2004 6:43 PM
Subject: RE: Table creation Time stamp
--=_alternative 005527E185256F2C_=
Content-Type: text/plain; charset="US-ASCII"
By Jove! you are right! Sorry! I can't
Hi,
I need a person who worked on oracle and mysql for a PCMM Level
company in Bangalore, India on a contract basis for 4 months. If any one
is interested please forward the resume asap. Min 3 years exp is
required. It is a very urgent requirement.
Thanks,
Narasimha
Confidentiality Notic
Massimo,
- Original Message -
From: ""Massimo Petrini"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, October 11, 2004 7:57 PM
Subject: CORRECT WAY TO SQUEEZE INNODB 4.0.17
I my network I have 1 master and 4 slaves. I need to squeeze the innodb on
my master; which
Hassan,
- Original Message -
From: "Hassan Shaikh" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Sunday, October 10, 2004 6:55 PM
Subject: Chinese
Hi,
How do I handle Chinese text (along with regular English) in my
database? I am using INNODB tables.
you can use MySQL-4.1
Richard,
you have to use a fairly recent 4.0 or 4.1 version of MySQL.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL t
Hi..
I have 30 text file that contains of sort of data about
wheather...Each text file contains the information about weather
in one day. So, i have 30 text file, which contains all the info
about weather in 30 days(1 month). All the attributes in all the
text files are same (date, date, rain scal
Baba,
- Original Message -
From: "Baba Buehler" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, October 07, 2004 12:34 AM
Subject: corruption after database restore
I'm having a corruption problem after doing a backup and then a restore
with ibbackup (v1.40).
Afte
Tom Kirkman wrote:
What are the options available for inserting\updating a MySQL table
VARCHAR with a string containing backslash characters so that the
backslash characters are preserved as is? For example, the UNC string
'\\MyServer\MyDir ' would be changed on the
way in to the VARCHAR to becom
Heikki,
> you have to use a fairly recent 4.0 or 4.1 version of MySQL.
Does a newer version allow you to change/set the names yourself?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
>
Hi,
I am new to mysql. I want to create sequences in mysql 4.0 which
should be equivalent to oracle sequences. I gone through the mysql
manual, Auto_Increment(), C API mysql_insert_id() and LAST_INSERT_ID()
are there for sequences. Last_insert_id() gives the last value.
I want actual migration
Hello,
> I am new to mysql. I want to create sequences in mysql 4.0 which
> should be equivalent to oracle sequences. I gone through the mysql
> manual, Auto_Increment(), C API mysql_insert_id() and LAST_INSERT_ID()
> are there for sequences. Last_insert_id() gives the last value.
> I want act
Hi,
I am new to mysql. I want to create sequences in mysql 4.0 which
should be equivalent to oracle sequences. I gone through the mysql
manual, Auto_Increment(), C API mysql_insert_id() and LAST_INSERT_ID()
are there for sequences. Last_insert_id() gives the last value.
I want actual migratio
Jerry Swanson <[EMAIL PROTECTED]> wrote:
> I have field date type of "datetime". I need to modify to "timestamp".
> If I alter the table and mofiy the field will this crash the data in
> the field.
MySQL server will crash? Please show us the error message.
--
For technical support contract
Teng Wang <[EMAIL PROTECTED]> wrote:
It's really clear what you want. Please specify.
If what you basicaly want is just a tree structure, then it's done like that:
CREATE TABLE something (
id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
parent INT NOT NULL,
data1 CHAR(255
"Lynette Tillner" <[EMAIL PROTECTED]> wrote:
> I'm setting up a development box with FreeBSD 4.10 and installed MySQL =
> 4.0.12 on it. Everything in the install appeared to work smoothly.=20
>
> However, when I go to start MySQL I get an error that says:=20
>
> database list could not be retrie
It's rather a different behaviour. We suggest to upgrade to 4.0.21 in this
case.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/
James Green <[EMAIL PROTECTED]> wrote:
> Trying to run mysqlhotcopy on multiple Debian stable systems, am getting
> segfaults on some of them. We're using mysql-4.0.20 from the binary
> release off mysql.com. strace says:
>
[]
> I'm no expert - can anyone identify the fault? Running as root use
Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I have a slight dilemma. I am using transactions to
> insert data into multiple tables. All but one table
> is Innodb. That one is Myisam and it's left as such
> because its one text column, so I want the benefits of
> full text search.
>
> Still
Check tables in mysql database with myisamchk. This might me some kind of table
corruptions.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Eg
Egor, others,
> It's really clear what you want. Please specify.
>
> If what you basicaly want is just a tree structure, then it's done like
that:
>
>
> CREATE TABLE something (
> id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
> parent INT NOT NULL,
> data1 CHAR(255),
> data2 CHAR(255),
> ...
>
> );
See http://dev.mysql.com/doc/mysql/en/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMA
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> I'm trying to set up a new Opteron-Based MySQL-Server.
> The only thing I'm unsure about is which filesystem to choose..
>
> ext3? ReiserFS? XFS?
> What's your experience?
ext3 is the safest. For both others I'd suggest you to have UPS for your se
Steve Grosz <[EMAIL PROTECTED]> wrote:
> I'm just getting into the whole MySql (was using access). Is it better
> to create a Blob type and insert a image into it, or to create a char
> file type and have a directory structure to the specific file?
It's FAQ. One of the most FA Q.
Store image
tibyke <[EMAIL PROTECTED]> wrote:
> pls delete it
Done, deleted from my computer. :-))
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor E
You can be sure that MySQL won't loose any data in this case.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_
John <[EMAIL PROTECTED]> wrote:
Not a MySQL error. it's a bug in the application.
>
> I am using php/mysql for a program and everything
> installed fine but when I try to open it up I get this
> error:
>
> Fatal Error : Couldn't find local config file.
> File Name : /program/admin/index.php
>
Egor,
Thank you , I wasn't sure anyone would ever respond to
this post :)
What I wound up doing is , from the application level,
running an if / else. The if checks to see if each
$query has succeeded. If any of them failed, I do a
rollback. If they all have succeeded, I then do a
committ.
No
"roime puniran" <[EMAIL PROTECTED]> wrote:
> My question is, how can I dump all the data from text file into
> mySQL without specifies the names of the text file..It's mean
> that, we only specifies the extention of text file (*.txt) then
> by that way i can dump all into mysql?...
You can write
Yves Arsenault <[EMAIL PROTECTED]> wrote:
> Does a very large number of tables in a database affect MySQL's performance?
Strictly saying, yes. But the difference won't really matter. So read - no, it
won't affect performance.
--
For technical support contracts, goto https://order.mysql.com
Hello,
> The only difference is that you have moved parent outside main table.
> No benefits at all. You have to create two records I two tables instead of
> one. You have to make joins to see what is the parent of particular child.
> I am strongly against this.
Why?
1) relational theory clearly
David,
next-key locks are purely inhibitive. Even though transaction (2) has an
X-lock on the 'supremum' of the index, it cannot insert because also
transaction (1) has an X-lock on the 'supremum'.
Why is it allowed that two transactions can both have an X-lock on a 'gap'
in the index (the suprem
Martijn,
List: mysql
Subject:Re: Innodb foreign keys names
From: "Martijn Tonies"
Date: 2004-10-19 9:53:28
Message-ID: <01ad01c4b5c1$7c1e69a0$0a02a8c0 () martijn>
[Download message RAW]
>Heikki,
>
>> you have to use a fairly recent 4.0 or 4.1 version of MySQL.
>
>Does a new
Sanjeev Sagar wrote:
Hello All,
I am trying to create a perl DBI/DBD script for creating a database initial build. My input is a extract file, which is a mysqldump result file with --opt and -B option.
I am using DBIx::DWIW. I am able to open a successful database handler. I am having
code like
Adolfo,
the following patch in the 4.0 tree may fix the misleading error message:
D 1.222 04/10/12 18:11:50+03:00 [EMAIL PROTECTED] 357 356 1/1/5101
P sql/ha_innodb.cc
C Change error code to HA_ERR_ROW_IS_REFERENCED if we cannot DROP a parent
table
Boyd,
sorry, only the output of innodb_monitor can be accessed through an SQL
statement. The other monitors contain information mostly for special error
situations.
But it is in the TODO to implement
SHOW LOCKS ...
That would be useful for application developers.
Best regards,
Heikki
Innobase
You have already gone a long way to describing your table structure by
describing your data elements and their relationships to each other. Let
me try to summarize you descriptions and see if I can show you how to
translate your text descriptions into table descriptions.
1. There are things ca
David,
I am sorry for a late reply.
The corruption clearly is in the ibdata file of the production database.
InnoDB Hot Backup checks the page checksums when it copies the ibdata files.
Since CHECK TABLE fails, the corruption probably is in that table. You can
try to repair the corruption by dum
Hi!
Guilhem has now fixed this bug to 4.0.22.
Best regards,
Heikki
Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL support from http://
You can use DATE_FORMAT to recreate the first of the
month:
mysql> select d, DATE_FORMAT(d, '%Y-%m-01') FROM date_val;
+++
| d | DATE_FORMAT(d, '%Y-%m-01') |
+++
| 1864-02-28 | 1864-02-01 |
| 19
On Oct 19, 2004, at 10:17 AM, [EMAIL PROTECTED] wrote:
You have already gone a long way to describing your table structure by
describing your data elements and their relationships to each other.
Let me try to summarize you descriptions and see if I can show you
how to translate your text descri
Ian,
FILE I/O
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio w
In article <[EMAIL PROTECTED]>,
"Martijn Tonies" <[EMAIL PROTECTED]> writes:
> That is ONE way to store a tree structure :-)
> Another would be:
> ITEMS
> (ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
> other stuff)
> ITEM_PARENT
> (ItemID int,
> ParentID int
> primary key (ItemID, ParentID
> > That is ONE way to store a tree structure :-)
>
> > Another would be:
>
> > ITEMS
> > (ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
> > other stuff)
>
> > ITEM_PARENT
> > (ItemID int,
> > ParentID int
> > primary key (ItemID, ParentID)
> > )
>
>
> > I prefer the latter.
>
> The latter is n
Timothy Luoma <[EMAIL PROTECTED]> wrote on 10/19/2004 11:11:12 AM:
>
> On Oct 19, 2004, at 10:17 AM, [EMAIL PROTECTED] wrote:
>
> > You have already gone a long way to describing your table structure by
> > describing your data elements and their relationships to each other.
> > Let me try t
if (select count(*) from z_mail_systems > 0) then [insert statement]
endif;
How do I do this kind of conditional insert? Thanks.
First, assume you want to insert records, then only insert the records you
want to add to the destination table.
INSERT destinationtablename ()
SELECT
FROM sourcetablename
WHERE
Basically if you can build a query to return the records you want to
INSERT, you can stick an INSERT clause to
> you can use MySQL-4.1.6 and the UTF-8 character >set for both Chinese and
European languages.
What's the default character set for MySQL 5.0.1?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Elim,
- Alkuperäinen viesti -
Lähettäjä: "Elim Qiu" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Lähetetty: Tuesday, October 19, 2004 8:07 PM
Aihe: Re: Chinese
> > you can use MySQL-4.1.6 and the UTF-8 character >set for both Chinese
and
> E
I need help on the best way to handle a field that could have many
different ways of naming something.
For instance, school name
Let's take Saint Joseph's University
This could be Saint Joseph's Univeristy, U. of St. Joe, SJU, Univ. St.
Joe, etc...
In this case, I don't think I can always get w
Don't think "file" think "table"! ;-)
CREATE TABLE universitysynonyms (
ID int auto_increment primary key,
synonym varchar(40) not null,
university_id int not null,
UNIQUE(Synonym, university_id)
)
Each time you run into something you don't have in your "universit
Hi,
For this only RDBMS came into being.
You keep your master data in a table with relevent descriptions,
codify the item. Use the code in other location. In qa web page always
search against/show the full desc of what others require. Add a
category like school/university/pre-matric etc. this coul
Hey,
>From http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html:
If any column in a table has a variable length, the entire row becomes
variable-length as a result. Therefore, if a table contains any
variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns
longer than three cha
No worries about the late reply.
We took down the master, took a hot backup from the slave (I still need
to convert that 30-day license into a permanent one), moved it to the
master, started the master, and then took a hot backup and
re-initialized the slave. Took all of a few hours, and things
One of our developers came to me yesterday with strange results from a
query. I've created a simple version of the example. I've pasted the
table definitions at the bottom if someone really needs to see them.
This is on mysql 4.0.18.
insert into master (col1) values (1), (2);
insert into sub (c
The following are the real tests but not the real logic i'll apply:-)
i have 4 very simple script files below and like to show you the performance differece
tst0.sql:
select t1.participation_id id, t1.owner_id from participation t1 where
(t1.participation_id in (24,469)) and
(t1.property_dic
Description:
The linker does not seem to be correctly set !!! I am not sure what these
error messages are really saying
ld: fatal: library -ldir: not found
ld: fatal: File processing errors. No output written to conftest
collect2: ld returned 1 exit status
configure: failed program was:
#l
No, but you can. Modify your scripts so that the word EXPLAIN is the first
thing in each one then re-execute them. This will product the optimizer's
execution plan for each query. The results of all of those EXPLAIN
SELECT statements will give us the most information to work from.
Thanks.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| Hi..
| I have 30 text file that contains of sort of data about
| wheather...Each text file contains the information about weather
| in one day. So, i have 30 text file, which contains all the info
| about weather in 30 days(1 month). All the attribute
Cool! Thanks a lot Shawn.
> No, but you can. Modify your scripts so that the word EXPLAIN is the first
> thing in each one then re-execute them. This will product the optimizer's
> execution plan for each query. The results of all of those EXPLAIN
> SELECT statements will give us the most inf
Before I think about this, which is it?
insert into master (col1) values (1), (2);
or
insert into master (col1) values (1), (2), (3);
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sorry - removed some data to make it clearer.
insert into master (col1) values (1), (2);
is correct.
David
Michael Stassen wrote:
Before I think about this, which is it?
insert into master (col1) values (1), (2);
or
insert into master (col1) values (1), (2), (3);
Michael
--
MySQL General Mailing
Hello,
We want to be able to insert records into a table containing a billion records in a
timely fashion.
The table has one primary key, which I understand is implemented using B-trees,
causing insertion to slow by log N.
The key field is an auto_increment field.
The table is never joined to ot
I have a user who is using the following query to try and delete rows
from one table based on the lack of a user id in another table:
SELECT s.questionid, s.userid, s.questionanswer
FROM Users u, SurveyAnswers s
WHERE u.id != s.userid
The corresponding user rows have already be deleted from the t
select s.userid from surveyanswers s where s.userid not in (select
distinct u.id from users u)
On Tue, 19 Oct 2004 16:30:29 -0600, Jonathan Duncan <[EMAIL PROTECTED]> wrote:
> I have a user who is using the following query to try and delete rows
> from one table based on the lack of a user id in
Thanks for the reply.
Yves
On Tue, 19 Oct 2004 14:22:01 +0300, Egor Egorov <[EMAIL PROTECTED]> wrote:
> Yves Arsenault <[EMAIL PROTECTED]> wrote:
>
> > Does a very large number of tables in a database affect MySQL's performance?
>
> Strictly saying, yes. But the difference won't really matter.
I would like to count all of the resulting rows of my query.
But my query contains a "group by", so
select count(*) from table group by field
will select an individual group count for each group. Instead, I would
like to count the number of groups.
Thanks,
Marco
--
MySQL General Mailing List
For
At 04:15 PM 10/23/2004, you wrote:
Hello,
We want to be able to insert records into a table containing a billion
records in a timely fashion.
The table has one primary key, which I understand is implemented using
B-trees, causing insertion to slow by log N.
The key field is an auto_increment fiel
i didnt fully catch you...
is this the kind of query statement you want?
INSERT INTO some_other_table
SELECT
some_field_list
FROM z_mail_systems
HAVING COUNT(any_field)>0
On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe <[EMAIL PROTECTED]> wrote:
> if (select count(*) from z_mail_systems > 0) then
When you get the results of the query use mysql_num_rows(res) to get
the number of groups. Or if you only want to return the number of
groups in a query use something like. select count(distinct field)
from table;
-Eric
On Wed, 20 Oct 2004 03:03:47 +0200, Marco <[EMAIL PROTECTED]> wrote:
> I wou
I have Mysql Cluster (version 4.1.16-gama) running, and now I need to
convert database tables from engine MyISAM to NDBCLUSTER, but ALTER
TABLE fails on some tables.
Does anyone know what the error means or how to get around it?
mysql> use database1;
mysql> alter table attr engine=NDB;
ERROR 1005
On Tue, 2004-10-19 at 21:42, John Stile wrote:
> I have Mysql Cluster (version 4.1.16-gama) running, and now I need to
Sorry, I meant version mysql-max-4.1.6-gamma-pc-linux-i686.
signature.asc
Description: This is a digitally signed message part
Philippe Poelvoorde wrote:
mysql> system echo hi there;
mysql> system ls -ls;
mysql> system uname-a;
all work on the 2.4.22-10mdk kernel and
the semi-colon is optional.
mysql> system echo "hi there"
should be also working, the first parameters 'echo' is recognized as the
command to execute, and
78 matches
Mail list logo
