On Tue, 13 Jul 2004 23:26:48 +0100, Marvin Wright
[EMAIL PROTECTED] wrote:
Hi,
I'm now running redhat AS 3.0 with kernel version 2.4 and have 8GB of RAM.
If I set my innodb_buffer_pool to 2048M, it just will not start, I get this
error.
040713 22:10:24 mysqld started
040713 22:10:24
Hello,
I wants to copy a full database with all its information to a database on another
computer.
Is it really that simple that I just create a new db on the new system and then copy
the files from the old db directory into the newly created one?
cheers Alex
--
MySQL General Mailing List
For
In article [EMAIL PROTECTED],
Justin Swanhart [EMAIL PROTECTED] writes:
Where is the implicit group? The 'order by'
shouldn't effect how things
are grouped. On MySQL 4.0.17:
Wow. I wasn't aware. Is that expected behavior?
Other databases (Oracle) generate an error when you
include
Il lun, 2004-07-12 alle 13:45, Cemal Dalar ha scritto:
To debug the problem. Make SHOW SLAVE STATUS in the slave and check for
the error number..
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator Web Developer
http://www.gittigidiyor.com http://www.dalar.net
- Original
Thanks Daniel. Finally, I am making use of the C API and the flag
'CLIENT_MULTI_RESULTS' as suggested.
It's working !! :))
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 5:07 AM
Ok. better check .err files in /usr/local/mysql/data/hostname.err for any
errors.. It seems that there isn't any problems on slave but from my
experience there can be problem on the slave like auth. For example when
replica user can not login to master then 'show slave status' doesn't give
any
Astrum Et Securis
Kieran,
Thanks a bunch! Some very useful and handy tips...
Really appreciate it.
Dominor,
RSJ
-Original Message-
From: Kieran Kelleher [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 12:03 AM
To: MySQL Junkie
Cc: [EMAIL PROTECTED]
Subject: Re: mySQL on MAC
mysql wrote:
Hello,
I wants to copy a full database with all its information to a database on another
computer.
Is it really that simple that I just create a new db on the new system and then copy
the files from the old db directory into the newly created one?
cheers Alex
A safer solution is
Have you checked your slow query log and your error logs? Depending on
your usage patterns, you may need to optimize some of your queries. Is
your MySQL server sharing CPU time with any other applications? How many?
Could they be the cause of your CPU usage spike?
To the list: (This may or
What is the amout of volume? Are you reaching max connections? What does the
I/0 look like?
-Original Message-
From: [EMAIL PROTECTED]
To: s.ahmad
Cc: [EMAIL PROTECTED]
Sent: 7/14/04 7:51 AM
Subject: Re: No Response from Server
Have you checked your slow query log and your error
Hi all !
Sorry for the long subject line, but I couldn't find a short one...
Here is the problem :
My database (mysql 4.1.1) consists mostly for compressed MyISAM
tables.
I wrote a script, relying on a temporary memory-based table. This
table is, of course, writable.
If try to do an update or
I actually posted something yesterday, but it got bounced (HTML with long
lines?). I'm starting to wonder whether the problem is my configuration. I
just noticed yesterday that the 4.1 my sysadmin set up is running
bin/safe_mysqld. Unfortunately it will take me some time to get back to
where I
You can test if you can see the server from your other user's machine by
trying to connect to it with telnet. On the other user's machine, open a
telnet session to the server's address on port 3306 and press ENTER a few
times. You should be able to pick the server's executable name and
I don't see 'caldata.resource' anywhere in the statement you posted. Are
you sure you are sending the correct string to MySQL for execution as you
didn't post what MySQL tried to execute (based on its error message) for us
to look at. This may be a variable name typo issue.
One very simple
Hello List
I've recently compiled and installed the latest stable version of MySQL from
source file mysql-4.0.20.tar.gz on Red Hat Linux Advanced Server 3 (without
installing the version of MySQL contained within the Red Hat OS install),
using the standard configure, make and make install. For
If you would entertain a MYSQL/PHP, hope not too off-topicIt's
probably not difficult to solve - but you would be helping me
with some SQL logic.
The only way I can think of to explain what I want to do
is to give you my working newbie MSQL/PHP code that I'm learning
MYSQL/PHP with, and at a
Hi,
What SQL function do I need to convert timestamp 200406011403 into
2004-06-01 14:03 ?
Thanks,
JS.
_
Stay in touch with absent friends - get MSN Messenger
http://www.msn.co.uk/messenger
--
MySQL General Mailing List
For list
I was able to rerun my tests using mysqld (as opposed to safe_mysqld). I'm
happy to report that the times now almost exactly match MySQL 3.23.58.
--Th
-Original Message-
From: Hickey,Thom
Sent: Wednesday, July 14, 2004 9:12 AM
To: 'Lachlan Mulcahy'; [EMAIL PROTECTED]
Subject: RE: 4.1
Reggie
I was hoping to perform the mysql installation myself. I was also hoping
that I don't have to install the full suite as available on the site, but a
subset of that. What I am looking for is the list of necessary files that I
need to install mysql, to package with my VB application. I will
I'm sure there is some subset of files that you can include, based on what
features you want to make available to your clients.
-reggie
-Original Message-
From: Roy Brown [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 10:14 AM
To: 'Reggie Burnett'; [EMAIL PROTECTED]
All I want is to just use mysql as the backend for my application. I don't
want to implement any features from mysql. So basically, I just want the
list of files necessary to use it as a data store.
~roy~
-Original Message-
From: Reggie Burnett [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
Hi All,
Can 'mysql_real_connect' be called using DSN name rather than giving
hostname, database name, port no., etc ?
Thanks,
Nawal.
Hickey,Thom [EMAIL PROTECTED] wrote:
One thing that 4.1 is better at is speeding up repeated queries,
...thanks to query cache, introduced in 4.0.1.
so
for testing we're forced to run thousands of queries through the
system to avoid speed-ups across runs.
SELECT SQL_NO_CACHE is pretty
In MySQL you can do that with: DATE_FORMAT
DATE_FORMAT (column_name,'%Y-%m-%d %H:%i')
-Mensaje original-
De: J S [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 14 de Julio de 2004 08:26 a.m.
Para: [EMAIL PROTECTED]
Asunto: sql function for timestamp
Hi,
What SQL function do I need
While in PHP you can try something like this...
$date_added = $row['date_added'];
$date = date(M d, Y, strtotime($date_added));
echo $date;
H and i do work in PHP as well, I believe, if you want to add the hour and
seconds. Check out the 'date' function in PHP for info.
My question in brief is why wouldn't the physical mysql files change in size
if a substantial percentage of the records are deleted from a given table???
I have a table which contained 13.5 million records. I then deleted 6.5
million records; however, the physical file size did not change.
The
If you have 4.1.1 or greater, you can use GET_FORMAT( timestamp, 'ISO'
).
Otherwise, I think if you just use DATE_FORMAT( timestamp, '%Y-%m-%d
%H:%i ) you will get weird values if your timestamp field doesn't
include seconds. So, either alter your field to be CONCAT( timestamp,
'00' ), or, as
Match() returns a graded relevance rating, as a floating point number
(when called as you call it) for matches. Words present in more than half
the rows are ignored, presence of a word in most rows lowers relevance,
presence of a word in just a few rows increases it, weights are then
combined to
Thanks for your help. I would like to do it with the SQL. However I'm still
having problems with the syntax below.
Is this wrong?
mysql SELECT DATE_FORMAT (20040601123456,'%Y-%m-%d');
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server
In the last episode (Jul 14), Gil Vidals said:
My question in brief is why wouldn't the physical mysql files change
in size if a substantial percentage of the records are deleted from a
given table???
Automatic filesize reduction would only be possible if the deleted
records were at the end of
Run optimize table position_log
Marvin.
-Original Message-
From: Gil Vidals [mailto:[EMAIL PROTECTED]
Sent: 14 July 2004 17:04
To: [EMAIL PROTECTED]
Cc: robert gavina
Subject: deleting millions of records did not change the file size
My question in brief is why wouldn't the physical
In message [EMAIL PROTECTED]
'mysql_real_connect' with DSN
Nawal Lodha [EMAIL PROTECTED] wrote:
Can 'mysql_real_connect' be called using DSN name rather than giving
hostname, database name, port no., etc ?
Are you using ODBC?
Data Source Name(DSN) is an alias of the database in ODBC.
Hi,
I want to find the earliest and latest times in the time column of my table
internet_usage:
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
JS:
When I use DATE_FORMAT(), if I have a space character between
DATE_FORMAT and the ( I get an error. Try writing it like:
SELECT DATE_FORMAT( 20040601123456, '%Y-%m-%d' );
MySQL v4.1.2-alpha-standard
Mac OS X
Wes
On Jul 14, 2004, at 12:20 PM, J S wrote:
Thanks for your help. I would like to
That was it! Thanks so much.
JS
JS:
When I use DATE_FORMAT(), if I have a space character between DATE_FORMAT
and the ( I get an error. Try writing it like:
SELECT DATE_FORMAT( 20040601123456, '%Y-%m-%d' );
MySQL v4.1.2-alpha-standard
Mac OS X
Wes
On Jul 14, 2004, at 12:20 PM, J S wrote:
Thanks
Hi!
On Jul 13, [EMAIL PROTECTED] wrote:
I have a query like this
select hex(blob_field) as myField from table
When the blob field is empty ('') it returns 'x'.
i'm using ADO with Visual Basic and MyODBC 3.51.
MySQL Version is 4.0.18 and SO is Win XP Pro (also happens on Windows 2K)
If
Does access_no contain actual textual data, or is it
simply a key like a category or an integer? If you
don't need to do a fulltext search against access_no
then there is no reason to include it in your fulltext
index. You should most likely have a seperate index
for access_no in that case.
The
In the last episode (Jul 14), J S said:
I want to find the earliest and latest times in the time column of my
table internet_usage:
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
Hi!
On Jul 14, Hickey,Thom wrote:
I was able to rerun my tests using mysqld (as opposed to safe_mysqld). I'm
happy to report that the times now almost exactly match MySQL 3.23.58.
It's VERY strange. It cannot have any affect on the speed.
Are you sure you run the correct version of mysqld ?
Hi!
On Jul 14, Lachlan Mulcahy wrote:
Sergei, Thom..
I am interested in seeing this thread followed through. As developers at my
work have experienced similar performance issues between 3.23.x and 4. Our
database is also of similar size and a full optimize has been run.
Could you provide
Creating a key will make that query execute very fast,
but if that is the only reason for the key you are
going to be trading quite a lot of space for the speed
of one query.
How often are you going to run this query? If you
have 324 million rows, then that index is going to
consume somewhere
Thanks OGINO San.
You are right.
I am using MySQL API. So, I need to connect thro' hostname,
databaseName, etc. only and not thro' the ODBC DSN.
-Original Message-
From: OGINO Tomonori [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 9:57 PM
To: [EMAIL PROTECTED]
Subject: Re:
You _can_ do this in SQL, it just takes several steps.
What you need to do is create a table that contains the ID values of the
records you want to get rid of. If you want to keep the first record in a
set of dupes try this:
CREATE TABLE DeleteMe
SELECT t.email, t.ID
FROM yourtablenamehere
Thanks for your reply. Can I just check my syntax is right for creating the
key?
CREATE INDEX urlindex ON internet_usage (time);
I ran this before but got an error 27 (eventhough the filesize ulimit was
set to unlimited). So just wondered if I was using the wrong syntax?
JS.
In the last
hi
when ppl paste from MS Word to a text field in a form,
characters like apostrophe before s (e.g. It's) in
docs looks like (it looks like a comma but at the
top). in a mysqldump, i can see that it's stored as
#8217;. i tried editing the in a text box and when i
reprint it, it's looks like it
In the last episode (Jul 14), J S said:
Thanks for your reply. Can I just check my syntax is right for
creating the key?
CREATE INDEX urlindex ON internet_usage (time);
I ran this before but got an error 27 (eventhough the filesize ulimit
was set to unlimited). So just wondered if I was
soapbox
If all you need from your query is one column, then ask for just that one
column. Don't overuse SELECT *. You wind up filling your data transfer
channels with unnecessary and unused data.
/soapbox (sorry about that, one of my pet peeves)
You can store the results of your fulltext
At 11:04 AM 7/14/2004, you wrote:
My question in brief is why wouldn't the physical mysql files change in size
if a substantial percentage of the records are deleted from a given table???
Why would it? If you delete 1 row from the middle of the table, it leaves a
hole. This space is recovered
Hmmw your syntax should ork. Possibly try
CREATE INDEX urlindex ON internet_usage (time(8));
W 8hich will only use the first charaters of your time field, it should
make the index significantly smaller in size.
Though I'm not completly sure shorting time field this way is legal, but
you can
Lopez David E-r9374c wrote:
matt
1) inserts using this format is much faster:
INSERT INTO table (col1, col2) VALUES (val1,val2), (val3,val4)
is much faster then single row insert. My experience is
2.5 hrs vs.. 36 hrs.
2) The PACK_KEYS=1 may be hurting you. I've never used it.
3) There
Egor Egorov wrote:
Are you running this under Microsoft Windows?
Yes, windows 2k and 2003, mysql-nt 4.0.16
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
You may want more indexes but you might be getting killed because you already have too
many.
To test - try loading into a table without indexes and see if it makes a difference.
At the very least - check to see if the primary index which starts with 'dic' can make
your
Hi,
I am currently working on a hold system. The system will allow
Coordinators to hold international students to place them with American
Host Families. I am having a hard time coming up with a good MySQL
table design for this process.
I have a table now that looks something like:
CREATE
In the last episode (Jul 14), John Larsen said:
Hmmw your syntax should ork. Possibly try CREATE INDEX urlindex ON
internet_usage (time(8)); W 8hich will only use the first charaters
of your time field, it should make the index significantly smaller in
size.
A timestamp field is only 4 bytes
Indexes can generate vast amounts of random i/o.
Because of rotational latency, random i/o can really
slow you down, especially if you are using IDE or SATA
disks because they can't do tagged queueing like SCSI
disks can.
If you have the budget for it, I would consider
getting some solid state
I don't see how hold_tracker coordinates a student with a coordinator (is
the coordinator the user_Id ?)
What is this #1 position you speak of? I don't see anything like a
priority or ranking field in the table you posted. Maybe if you posted
your entire data structure, things would make
Hi,
I have a quick question about how programs linked against the mysql C
libraries handle the following:
-assume three mysql hosts, say 10.0.0.2, 10.0.0.3, and 10.0.0.4
-assume a dns name db.example.com that returns the following:
[EMAIL PROTECTED] host db.example.com
db.example.com has
In the last episode (Jul 14), J S said:
Thanks for your reply. Can I just check my syntax is right for
creating the key?
CREATE INDEX urlindex ON internet_usage (time);
I ran this before but got an error 27 (eventhough the filesize ulimit
was set to unlimited). So just wondered if I was
Greetings all,
I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved
the old installation to a directory called old_mysql in my home
directory. I can start the new installation using mysqld_safe .
Now, when I try to do something like:
/new/install/mysqladmin -u root -p version
Hello All,
I hope someone can shed some light on this problem...
This concerns large InnoDB tables (having on the order of millions of rows).
When I run ALTER TABLE (for example, to change the default column value) or UPDATE or
DELETE queries that affect many rows, mysqld-max crashes and
Hi,
I am testing mysql on a large database (10GB). When I post a large
select request via myodbc all other process threads lock until that
thread completes. I am not locking any tables.
How do I stop a read only select statement with a large result set from
locking all the other threads until
I'm using SqlPassthrough In VFP 8.0
Ive got a Sql statement that looks like this.
This following fails:
Update User
Set Active = True
Where UserId = ?pnUserId
pnUserId is 222 in this instance.
The following works fine:
Update User
Set Active =
I recently started experimenting with the text field.
It generally works OK, but I have a question about
pasting in the text.
It seems a little awkward in phpMyAdmin, and I
generally wind up with everything mushed together like
this:
p clsas=firstspan class=dropcapV/spanermont
is nicknamed the
The correct way to deal with this is to edit /etc/my.cnf and, in the
mysqld section set the location of the socket.
[mysqld]
socket = /tmp/mysql.sock
if there are other systems expecting it to be at the new location, a
simple end run might be to create a link at /tmp/mysql.sock -
What type of select is this? Is the application and the database on the same
machine? Is this query build a large temp table?
-Original Message-
From: John Nairn
To: [EMAIL PROTECTED]
Sent: 7/14/04 7:11 PM
Subject: Any select with a large result set locks all other threads until it
Hello,
Probably this mail should go to the internals list :)
I was looking into MySQL Client libaray and I could
figure out the DATA are kept as linked list of
MYSQL_ROW structure i.e. in MYSQL_ROWS being one node.
Now MYSQL_ROW is typedefed as char** that is array of
strings.
Looking into the
Okay, so what I did to solve this was:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
That seems like a bit of a hack though. The my.cnf file has this line:
socket=/var/lib/mysql/mysql.sock
Anyone know why it's looking in /etc ?
On Jul 14, 2004, at 4:53 PM, Jough P wrote:
Greetings all,
I
Greetings All,
I see some files in the data dir with names like #sql-85d_4.MYI. Some of these are
pretty old. Are these the temp tables that didn't get deleted properly? Is it OK to
shut down the server and delete them?
Thanks,
Sergei
Sergei,
please run CHECK TABLE on the tables, and check if it prints something to
the .err log.
Also, resolve the stack trace printed by the crashing mysqld, as explained
in the manual.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB
69 matches
Mail list logo
