on 5/3/05 7:25 PM, Joseph Cochran at [EMAIL PROTECTED] wrote:
> So here's my situation: we have a database that has a table of about 5
> million rows. To put a new row into the table, I do an INSERT ...
> SELECT, pulling data from one row in the table to seed the data for
> the new row. When there
So here's my situation: we have a database that has a table of about 5
million rows. To put a new row into the table, I do an INSERT ...
SELECT, pulling data from one row in the table to seed the data for
the new row. When there are no active connections to the DB other than
the one making the INSE
I use mysql 4.0.23-nt on win XP.
In order to shift some of my databases I followed the following steps as per
a recent post:
1. I moved the folders containing the database files that I wanted to move
to a new folder (from data to data2) after stopping mysql of course.
2. In the data folder I cre
thanks Damian
but I don't understand this: My field according to which I want the
database to be sorted IS an unique number.
eg I have
1 ab 33
1 cd 21
1 ac 32
2 aa 22
2 cd 25
3 kw 03
3 ie 02
2 ei 05
2 wk 00
I need it in the form:
1 ab 33
1 cd 21
1 ac 32
2 aa 22
2 cd 25
2 ei 05
2 wk 00
3 kw 03
3 ie
Hi Christoph,
I would suggest you read up about indexes and how they would assist you
in your requirements. Without knowing the exact structure of your
tables, it is difficult to judge but it sounds like an index (or
indexes), correctly structured, would provide what you need. A good read
would be
Hi
I am really new to mysql. I need my database to be sorted according to
one field. But since the database with 1200 records is huge, I don't
want to do it using SELECT.
What I need is just the stored database being sorted on hard-disk. Is
there any way doing this like creating a new databa
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:martin.mpsoft.dk
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Re
Victor Pendleton wrote:
Try show index from t1;
Show index from t2;
Hi Victor,
Nope, this does not help. t1 has key disabled, t1 enabled, and the
result is the same:
mysql> show index from t1\G
*** 1. row ***
Table: t1
Non_unique: 0
Key
Try show index from t1;
Show index from t2;
-Original Message-
From: Jacek Becla [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 03, 2005 4:00 PM
To: Jay Blanchard
Cc: mysql@lists.mysql.com
Subject: Re: how to check if keys disabled?
Jay
Are you sure? DESCRIBE tells me the table has an ind
Jay
Are you sure? DESCRIBE tells me the table has an index, but not whether
the index is enabled or not:
mysql> create table t1 (x int primary key);
Query OK, 0 rows affected (0.01 sec)
mysql> create table t2 (x int primary key);
Query OK, 0 rows affected (0.01 sec)
mysql> alter table t1 disable
[snip]
How can I find out if keys are enabled/disabled for a given table?
Suppose I do:
create table t1 (x int primary key);
create table t2 (x int primary key);
alter table t1 disable keys;
How can I now find out that t1 has keys disabled, and t2 enabled?
[/snip]
DESCRIBE t1 or DESCRIBE t2
--
Hi,
How can I find out if keys are enabled/disabled for a given table?
Suppose I do:
create table t1 (x int primary key);
create table t2 (x int primary key);
alter table t1 disable keys;
How can I now find out that t1 has keys disabled, and t2 enabled?
thanks,
Jacek
--
MySQL General Mailing List
F
ummm
i made a mistake in what i posted... a typing error... it should have been
i did the following to configure the mysql database/table
--
$ mysql -uroot -p
mysql> CREATE DATABASE livejournal;
mysql> GRANT ALL PRIVILEGES ON livejournal.* TO
> lj@
My comments imbedded
Scott Hamm <[EMAIL PROTECTED]> wrote on 05/03/2005 03:16:31 PM:
>Since I'm learning about Left joins and am trying to figure out a way
> to quickly gather info from Database all at once, here is the SQL
> statement. Please give me feedback how I should improve it for
Since I'm learning about Left joins and am trying to figure out a way
to quickly gather info from Database all at once, here is the SQL
statement. Please give me feedback how I should improve it for better
performance. There are around 10 users that will hit database like
this along with
bruce wrote:
The problem is in your code, not your db.
hi...
i have the following issue.. i've researched it from google.. but i still
can't quite figure it out...
i'm using a test app with DBI->connect() and i'm getting the following
response... (print/debug statements...)
At 10:52 AM 5/3/05 -0700, [EMAIL PROTECTED] wrote:
>'DBD::mysql::db selectrow_hashref failed: Access denied for user:
>'[EMAIL PROTECTED]' (Using password: NO) at /var/www/html/cgi-bin/DBI/Role.pm
>$ mysql -uroot -p
>mysql> CREATE DATABASE livejournal;
>mysql> GRANT ALL PRIVILEGES ON livejournal.*
Anyone??
Original Message
The tables are now entirely in utf8, and that is also the instance's
default.
I'm using the .net dll to connect and the connection string has charset
= utf8.
I'm testing everything with the query browser, and i get the exact same
behaviour.
Again, if a
If you really really want it it's in the internals doc from the mysqldoc
bk tree.
-Eric
Reggie Burnett wrote:
Just to echo the thoughts from Jeremiah, we have several freely available
open source connectors that work *VERY HARD* tracking the protocol so it's
hard to understand a situation where y
PID USERNAME PRI NICE SIZERES STATETIME WCPUCPU COMMAND
55651 mysql 8 12 138M 33524K nanslp 0:21 0.00% 0.00% mysqld
55649 mysql 20 14 138M 33524K pause0:21 0.00% 0.00% mysqld
55866 mysql 4 14 138M 33524K sbwait 0:12 0.00% 0.00% mysqld
Ya, sin
In the last episode (May 03), Chris Knipe said:
> top...
> FreeBSD 5.4-STABLE, linuxthreads
>
> last pid: 56803; load averages: 0.29, 0.31, 0.14 up 5+11:10:10 20:09:05
> 174 processes: 1 running, 169 sleeping, 4 zombie
> CPU states: 0.0% user, 2.3% nice, 1.2% system, 0.0% interrupt, 96.5
top...
last pid: 56803; load averages: 0.29, 0.31, 0.14
up 5+11:10:10 20:09:05
174 processes: 1 running, 169 sleeping, 4 zombie
CPU states: 0.0% user, 2.3% nice, 1.2% system, 0.0% interrupt, 96.5%
idle
Mem: 422M Active, 237M Inact, 217M Wired, 43M Cache, 111M Buf, 73M Free
Swap: 512M Tot
That's exactly what a join does... join two or more tables as one, but
you usually define a common field to join the tables by...
If both tables have the same definition and you want to know how to
display the data of one of them after the other you need to do a:
select * from db1.table1 union s
hi...
i have the following issue.. i've researched it from google.. but i still
can't quite figure it out...
i'm using a test app with DBI->connect() and i'm getting the following
response... (print/debug statements...)
--
'bd ds
[snip]
I would like to run a query on two tables that reside in two distinct
databases:
select * from db1.table1 join db2.table2;
This lists both tables adjacent to one another rather than in a
sequential
fashion as one would get if both tables came from the same database.
Is there a way to acc
Mahmoud Badreddine <[EMAIL PROTECTED]> wrote on 05/03/2005 01:43:55
PM:
> Hi,
> I would like to run a query on two tables that reside in two distinct
> databases:
>
> select * from db1.table1 join db2.table2;
>
> This lists both tables adjacent to one another rather than in a
sequential
> fa
Hi,
I would like to run a query on two tables that reside in two distinct
databases:
select * from db1.table1 join db2.table2;
This lists both tables adjacent to one another rather than in a sequential
fashion as one would get if both tables came from the same database.
Is there a way to accomp
Dana Tue, 3 May 2005 11:34:39 -0500, Reggie Burnett rece:
> Just to echo the thoughts from Jeremiah, we have several freely available
> open source connectors that work *VERY HARD* tracking the protocol so it's
> hard to understand a situation where you would need to write your own
> implementation
In the last episode (May 03), Chris Knipe said:
> I have a P4 system with 1GB Ram and 512MB Swap (a little low I know).
>
> I'm running a multi threaded MySQL installation on it. With a bit of
> shock, I realised today that I ran completely out of swap space!!!
> Each MySQL thread is consuming a
Hi,
I have a P4 system with 1GB Ram and 512MB Swap (a little low I know).
I'm running a multi threaded MySQL installation on it. With a bit of shock,
I realised today that I ran completely out of swap space!!! Each MySQL
thread is consuming about 160MB of ram, and I had close to 40 threads
run
Just to echo the thoughts from Jeremiah, we have several freely available
open source connectors that work *VERY HARD* tracking the protocol so it's
hard to understand a situation where you would need to write your own
implementation.
-Reggie
-Original Message-
From: Nikola Skoric
The tables are now entirely in utf8, and that is also the instance's
default.
I'm using the .net dll to connect and the connection string has charset
= utf8.
I'm testing everything with the query browser, and i get the exact same
behaviour.
Again, if anyone wants a script to recreate the tables
Have you check that the collation for the text columns match the
collation for the table and that you've set UTF8 for the query (set
char set utf8).
Kevin Cowley
Product Development
Alchemetrics Ltd
SMARTER DATA , FASTER
Tel: 0118 902 9000 (swithcboard)
Tel: 0118 902 9099 (direct)
Web: www.alchem
Hi everyone! I'm havng the weirdest problem with mysql.
I had v1.1.07 and everything worked like a charm. But it turns out that
we had the need to move everything to UTF8 (until then, only the columns
in russian where set to utf8, and the rest was latin1).
Once we moved everything to utf8, this (
Hi
I updated mySQL 4.0.8 to 4.1.1 and I have now problems with foreign key
retrictions.
Is it right, that mySQL 4.1.x has something changed due to the foreign
key restriction?
Is there an option to turn off the foreign key restriction in mySQL
4.1.1?
Thanks.
--
Oliver Hirschi
http://www.Family
Schalk Neethling wrote:
Greetings!
This might be a stupid question but here goes:
I have a table that contains a column entitled current_pos. I want to
search this table and then order the results by current_pos. Now I am
running the following SQL query on the table:
SELECT * FROM ab_leader_boar
[snip]
This might be a stupid question but here goes:
I have a table that contains a column entitled current_pos. I want to
search this table and then order the results by current_pos. Now I am
running the following SQL query on the table:
SELECT * FROM ab_leader_board WHERE sex = 'F' and cup =
Greetings!
This might be a stupid question but here goes:
I have a table that contains a column entitled current_pos. I want to
search this table and then order the results by current_pos. Now I am
running the following SQL query on the table:
SELECT * FROM ab_leader_board WHERE sex = 'F' and cu
Hello,
Is the MySQL server that you are using MySQL4.1.x or MySQL5.0.x?
As for most binarys of PHP and MySQL, the default charset of
the MySQL connection client is set as 'latin1'. Therefore, if charset
with the server is not 'latin1', it is necessary to set the MySQL
connection client properly.
Hello.
As for me, SELECT ... FOR UPDATE could help in your situation. See:
http://dev.mysql.com/doc/mysql/en/innodb-locking-reads.html
Locking the whole InnoDB table is usually not a very good solution,
because it does row-level locking.
Marcin Lewandowski <[EMAIL PROTECTED]> wrote
Hello.
See:
http://dev.mysql.com/doc/mysql/en/myisam-storage-engine.html
http://dev.mysql.com/doc/mysql/en/using-innodb-tables.html
"V. Agarwal" <[EMAIL PROTECTED]> wrote:
> Hi,
> On PC, I see *.frm files for each table while I see
> 3 files on Unix/Linux (*.MYD,*,MYI,*.frm
Hello.
> | latin1_general_cs | latin1 | 49 | | | 0 |
You have this collation installed. The output from SHOW COLLATION includes all
available character sets.
Andre Matos <[EMAIL PROTECTED]> wrote:
> Hi List,
>
> I was checking the list of collations for a ch
Hello.
Are you using an official binary? Was there any error messages
before crashing? Resolve the stack trace. Follow recomendations from:
http://www.mysql.com/doc/en/Crashing.html
"Jack" <[EMAIL PROTECTED]> wrote:
> hi,all.
>
> i can't start mysqld anymore , it's log reports
Hello.
With 'set foreign_key_checks=0' creation of the table works on
my 4.1.11. Execute:
set foreign_key_checks=0;
Then create `shift` and all corresponding tables and
set foreign_key_checks=1;
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>
> Thank you for your help. I
Hello.
If the value of Read_Master_Log_Pos has a normal value, and slave
asked weird position, this could be some internal bug. Now I see
only a single way, but it could be difficult: if you have
--log-slave-updates, use slave binary logs to find the last executed
statement and it's position
Hello.
Have you been at:
http://dev.mysql.com/doc/mysql/en/full-table.html
"V. Agarwal" <[EMAIL PROTECTED]> wrote:
> Hi,
> I am using Mysql built-in defaults for starting the
> server. It chokes when the table size grows to 4GB.
> ===
> -rw-rw1 vagarwal dev
Hello.
See:
http://search.cpan.org/~spidb/Net-ext-1.011/lib/Net/Inet.pm
Mike Blezien <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Sorry for the slightly OT question :)
>
> Hoping we have some expert MySQL Function to perl function people on the list.
>
> Is there an equivelant fun
Hello,
this is probably quite simple but I've got a text file that has non-english
characters, when I view it I see :
'Découvrez un réseau européen d'hôtels et de restaurants beignant dans
une atmosphère conviviale et familliale'
I've imported this straight into my myisam DB which is set up
As it looks like no one else has replied.
The default table size is 4GB - effectively if you do not modify the
table create statement this is the size you get.
To alter the table size you need to change the value of the MAX_ROWS
parameter. The table size is governed by MAX_ROWS multiplied by aver
if i start to replicate the following table, i get this error:
050503 10:08:35 [ERROR] Key 1 - Found wrong stored record at 0
050503 10:08:35 [Note] Retrying repair of: './plugin_data/renderer'
with keycache
050503 10:08:35 [ERROR] Key 1 - Found wrong stored record at 0
what's the problem???
---
jkj kjhkjhk wrote:
Hi,
I develop multi-user web tracker system (php+mysql). In these days I have cca 150 users and each of the users has a set of the tables which are all included in central DB. In DB is on the whole cca 900 tables. Each user has also one (log) table in which are logged accesses t
Matthew Boehm wrote:
Hey guys,
(Why is there no C API specific list?)
I want to write a C application that can take some audio file, store it in
MySQL, then at a later date/time (upon request) pull from db and write to
temporary file to be streamed.
I've got the storing portion of the code down. T
On Mon, 02 May 2005 19:56:49 +0200, Eric Bergen <[EMAIL PROTECTED]>
wrote:
The column name is Tables_in_mysql. show syntax doesn't support order
by. Information_schema tables in 5.0 do because they use the normal
select syntax.
-Eric
Jim McAtee wrote:
Hey, thanks.
show tables like 'jst%_foo
53 matches
Mail list logo
