May i know, how could i know which of the data files that InnoDB MySQL engine is not
used ?
Did i i made a mistake when adding table space ?
Heikki Tuuri <[EMAIL PROTECTED]> wrote:
Ady,
InnoDB thinks that the tablespace size is 10 706 MB.
You have specified 36 782 MB of data files in the my.
I read in a couple of places that on a dedicated server the innodb buffer pool size
should not exceed 70% of total physical memory. Where does this number come from?
Thanks in advance,
Sergei
Thank you for your replies. I should have been more specific. I was just
using the sql editor in MySQL Control Center. I have two databases that I'm
managing that sit on different physical machines, but have the same database
names and table names etc., basically a test environment and a production
Hi!
On Aug 25, 2004, at 8:16, <[EMAIL PROTECTED]> wrote:
Is there any way to not sending the result of a user variable
assignment to
the client?
I.e. Suppress the result of;
SELECT @temp := columnID FROM table WHERE column = whatever LIMIT 0,1
...since I only use @temp in my next statement to pro
Nifty idea, but it doesn't work for me:
$ cat < \P cat /dev/null
> SELECT @id := id FROM users ORDER BY id DESC LIMIT 1;
> \n
> SELECT * FROM users WHERE id = @id;
> EOF
@id := id
3
PAGER set to stdout
id first lastemail
3 testy mctest [EMAIL PROTECTED]
Ideally, the output wou
Just finish compiled the mysql 4.0.20-0 windows source 4.0.20-0 with
the openssl options, generate certificates and edited the my.cnf file
with this values:
[client]
ssl-ca=c:/certifi/ssl/cacert.pem
ssl-cert=c:/certifi/ssl/client-cert.pem
ssl-key=c:/certifi/ssl/client-key.pem
[mysqld]
ssl-ca=c:/
How about
mysqldump > /dev/nst0
Tucker, Gabriel wrote:
Hello All
I have been searching the archives and was unable to find an answer.
I need the ability to backup MySQL instances directly to a tape device.
Currently, I run a mysqldump to disk and have legato pick up the file. As I get to
some l
Heikki Tuuri wrote:
Devanada,
normally you do not need to tune this option at all.
I introduced the option when certain Linux binaries showed 'thread
thrashing' at high concurrency. Setting the option to 1 or 2 could in some
cases alleviate the problem.
You can experiment by setting the option to 5
* Brian Menke
> I'm trying to specify a host name and database name to do an update to a
> table. I can't quite figure out what the correct syntax is? Is it
> something
> like:
>
> USE [EMAIL PROTECTED] I have tried several permutations of that but
> can't quite seem to get the syntax just right.
Are you using the mysql client to connect? If so, you can use the -h
and -D flags:
mysql -h hostname [-u username -p -P port] -D databasename
The -D flag isn't even necessary. The command above is equivalent to
this one:
mysql -h hostname [-u username -p -P port] databasename
http://dev.m
* Raghudev Ramaiah
> I need this since I have around 3 sets of 20 fields each are
> of the same data type .
> if i am able to use arrays , i can say
>
> integer[20] m1;
> integer[20] m2;
> integer[20] m3;
>
> if not , i will have to declare 60 fields
> integer m1 to integr m60.
>
> any
I'm trying to specify a host name and database name to do an update to a
table. I can't quite figure out what the correct syntax is? Is it something
like:
USE [EMAIL PROTECTED] I have tried several permutations of that but
can't quite seem to get the syntax just right.
Thanks.
-Brian
Start mysql on fc2 with
/etc/rc.d/init.d/mysql start
If that fails then look at the mysql error log.
Donny
> -Original Message-
> From: Danesh Daroui [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 02, 2004 3:04 PM
> To: [EMAIL PROTECTED]
> Subject: Installing MySQL 4.1 from RPM o
Hi,
I need this since I have around 3 sets of 20 fields each are of the same data type
.
if i am able to use arrays , i can say
integer[20] m1;
integer[20] m2;
integer[20] m3;
if not , i will have to declare 60 fields
integer m1 to integr m60.
any solutions please?its quite urgent!
Tha
At 01:33 PM 9/2/2004, Sun, Jennifer wrote:
I did 'handler table_name read limit large_numbers'. Is there a way I can
use lower number, but automatically loop through the number and display
all of the table records? Thanks.
If "large_numbers" is the number of rows in the table, then of course it
Numeric types are simply that: numbers. They cannot be arrays.
http://dev.mysql.com/doc/mysql/en/Numeric_types.html
Incidentally, why would you need this? Maybe the group can come up with
a viable alternative for you.
Cheers,
--V
Raghudev Ramaiah wrote:
hi
i have used column types such as intge
hi
i have used column types such as intger and float and double for fields in the MySQL
tables. can i use arryas of integers, floats and doubles as column type? i.e., can a
field ina table be an integer array or float array ?
ex: count[20] integer is it allowed and is it an array?
thanks and re
-
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now.
Dear Friends,
I have installed MySQL-devel RPM (Standard - gcc) and used it for
compiling PHP. MySQL Server remains the same intel build. It is working
perfectly although this may not be the desired solution.. please post if u
find any results.
Special Thanks to Mr.Egor Egorov for giving me a good
Hi all,
I have installed Server, Client, Benhcmark, Share, Embeded and Compact-Share RPMs
version 4.1 on a Fedora2 system. The have been installed successfully but when I type:
Shell> mysql -u root
it says that it can not open socket and I think it is because mysqld is not alive.
When I type:
On Thu, 2 Sep 2004 15:19:44 -0400, Sun, Jennifer
<[EMAIL PROTECTED]> wrote:
> Thanks Marc,
>
> What version of myisam table you are talking about? We are on 4.0.20, when I ran the
> big table query, I tried to insert to it twice without any issues.
> The -q worked good for mysql client. Thanks.
Thanks Marc,
What version of myisam table you are talking about? We are on 4.0.20, when I ran the
big table query, I tried to insert to it twice without any issues.
The -q worked good for mysql client. Thanks.
Jennifer
-Original Message-
From: Marc Slemko [mailto:[EMAIL PROTECTED]
Sen
Due to the nature of myisam tables, when you are doing a query then
the table will be locked for writes. Reads will still be permitted
until another write request is made, at which time all further reads
and writes will be blocked until the query completes.
This, however, is already happening eve
I did 'handler table_name read limit large_numbers'. Is there a way I can use lower
number, but automatically loop through the number and display all of the table
records? Thanks.
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 02, 2004 10:37 AM
To: [EMAI
The command is issued from mysql command line. Is there any parameters or options I
can use without locking the table?
-Original Message-
From: Marc Slemko [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 02, 2004 2:24 PM
To: Sun, Jennifer
Cc: [EMAIL PROTECTED]
Subject: Re: tuning sug
On Wed, 1 Sep 2004 11:40:34 -0400, Sun, Jennifer
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> We have a job that do 'select * from big-table' on a staging mysql database, then
> dump to data warehouse, it is scheduled to run once a day, but may be run manually.
> Also we have several other small OLTP da
Peter,
Thank you ! I like that suggestion of graying out the
button!
Stuart
--- Peter Brawley <[EMAIL PROTECTED]>
wrote:
> Stuart,
>
> If one member may have a max of three resumes, then
> the relationship is
> one-many with cardinality=3, implementable with a
> foreign key in resumes (eg
> r
K ...so I have it set up correctly. After I posted,
"then" went back and scoured through your previous
responses. Realized, it's not a many to many.
I honestly think if I was only doing the database,
life would be a whole lot easier :). Sorry , that's
humour.
Thank you
Stuart
--- [EMAIL PR
Devanada,
normally you do not need to tune this option at all.
I introduced the option when certain Linux binaries showed 'thread
thrashing' at high concurrency. Setting the option to 1 or 2 could in some
cases alleviate the problem.
You can experiment by setting the option to 500 to disable res
Pandu,
this might be the '4 billion bug' that is fixed in upcoming 4.0.21.
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
Ord
Alex,
since the floating point format in all the common architectures is the same
nowadays, you can freely copy data files and .frm files across platforms.
To avoid problems in table name case, use always lower case table names and
database names:
http://dev.mysql.com/doc/mysql/en/Moving.html
"
Stuart,
If one member may have a max of three resumes, then the relationship is
one-many with cardinality=3, implementable with a foreign key in resumes (eg
resumes.memberID). MySQL doesn't have tools for implementing cardinality
constraints, so you would have to do that in application code, ie gr
Ady,
InnoDB thinks that the tablespace size is 10 706 MB.
You have specified 36 782 MB of data files in the my.cnf line :(.
Now you should figure out what are the data files that InnoDB is using, and
remove the end of the innodb_data_file_path line, as well as the unused
ibdata files. Remember t
Hi list,
In general, is there any guarantee that the .frm and innodb files
(including logs) will be exactly the same cross-platform? More
specifically, would the database data files created on Windows work when
placed on an OSX installation of the same version?
Assume whatever version of mysq
Mauricio,
please send the FULL .err log to me. Do not cut anything off.
[EMAIL PROTECTED]
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.co
-- yep, I'm hanging around ;-)
You don't have a many-to-many relationship between resumes and members.
It's a one-to-many (each member can have multiple resumes but each resume
belongs specifically to only 1 member)
That's done with a single table like this (not 3 different resume tables):
CR
A little question on my slave upgrade.
In the log is see as an error whne my slave is connecting to my master. See
below
Is all normal ?
Meanwhile I run the fix suggested for password .
Thanks
Massimo
---
All sorted now, Ian.
- Original Message -
> Hope this helps
>
> If not try this (joking):
>
> http://foldoc.doc.ic.ac.uk/foldoc/foldoc.cgi?RTFM
>
> Ian
> --
That's what was missing. LOL
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
Yep, understand about the 0 and checked the code no
-1's. All is weird, but here is a situation that in
the back of my mind I keep thinking maybe I need a
many to many. The problem is I "again" can't quite
conceptualize it. If I'm making a rehash again , I
really apologize.
Here is the situation
Formatting shouldn't be an issue if you entered the query exactly as you
said you did. However, I'm a little dubious that you did; the error message
seems to be saying that you have a negative sign in front of the first 1 in
the Limit clause.
Check your typing and try the query again. Also, rememb
Thank you both.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 9:54 -0600 9/2/04, Mark C. Stafford wrote:
Should I care that USAGE still shows up after all rights have been
revoked? It feels like a potential security hole...
USAGE *means* "no privileges", that's why it shows up when all privs
have been revoked.
It does mean that the account can be used to c
"USAGE" is a synonym for "no privileges." Yes, it's kind of a confusing
term which implies "this user can use the system" when in fact the
situation is exactly the opposite.
http://dev.mysql.com/doc/mysql/en/User_resources.html
Cheers,
--V
Mark C. Stafford wrote:
Should I care that USAGE still
On Sep 2, 2004, at 6:04 AM, Egor Egorov wrote:
Michael Winston <[EMAIL PROTECTED]> wrote:
Okay, so the first thing to try is obviously enlarge the
max_connections.
Have you tried this?
Yes. It's set to 400 (a number we will never reach unless there's some
sort of logjam). max_connect_errors is
The query works fine on it's own, but generates a SQL
error in my page:
SELECT *
FROM MemberRez
WHERE LurkID=colname (I've tried it without this line)
ORDER BY andnext asc limit 1,1
andnext is the pk auto inc.
Page error:
You have an error in your SQL syntax. Check the manual
that corresponds to
Did you actually stop all writes to the master data while you were copying
the data over to the slave database? Is it possible that the connection you
issued the read lock with timed out before the transfer was completed?
-Original Message-
From: Alex Greg
To: [EMAIL PROTECTED]
Sent: 9/2/
Hello All
I have been searching the archives and was unable to find an answer.
I need the ability to backup MySQL instances directly to a tape device.
Currently, I run a mysqldump to disk and have legato pick up the file. As I get to
some larger databases, hundred's of gigs, and higher transac
Hi,
We recently moved to new servers, and also upgraded from MySQL 3.23 to
4.0.20. We have one master database server and a second identical
machine configured to replicate all databases from the master.
Previously this has worked without a hitch, but we seem to be having
some problems.
The wa
Should I care that USAGE still shows up after all rights have been
revoked? It feels like a potential security hole...
-- working around the system to ensure a clean environment
-- i feel like i shouldn't have to do this...but want to start with a
clean slate
DELETE FROM mysql.user WHERE user =
Problem solved!
Changing the CurrentControlSet MySQL ImagePath from 'mysqld-opt' to
'mysqld' now brings up the correct (or rather, the expected) version.
On reflection, perhaps I didn't shut down MySQL before running the setup
for the gamma version, and that is why it continued to use the older
On 2 Sep 2004 at 16:01, Terry Riley wrote:
> Victor
>
> C:\MYSQL\BIN\mysqld-opt --defaults-file="C:\WINDOWS\my.ini" MySql
>
> is what the path-to-executable states. If I remember rightly, the new
> version should be mysqld, period. Is that what's wrong?
>
> Will I have to tweak the registry to
DuBois just trumped me. Just check the version from the command line.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 9/2/04 10:13 AM
Subject: RE: 4.1.4 still reports itself as 4.1.3b-beta
Further to last message, I've found that string in three different
places
in
At 10:13 -0500 9/2/04, Victor Pendleton wrote:
You can test if this is correct by manually starting the service from a dos
window and logging and seeing what version this executable actually is.
Or check from the command line without even starting it:
mysqld --version
-Original Message-
Fr
gerald_clark wrote:
We have no idea what you are running, or what you are running it on.
matt ryan wrote:
040901 18:36:21 Error reading packet from server: binlog truncated
in the middle of event (server_errno=1236)
040901 18:36:21 Got fatal error 1236: 'binlog truncated in the
middle of event'
Well I try to avoid the manual , but refer to some
books that I've collected. Essentially the same, but
more palatable for my tastes. Not that I wouldnl't
check the manual.
What I needed was "order by Desc limit (x, x) . In my
case 3 queries, with (0,1)(1,1)(2,1) .
The first 3 records , 1 at a
Further to last message, I've found that string in three different places
in the registry:
HKEY_LOCAL_MACHINE\system\controlset001\services\MySQL\ImagePath\
HKEY_LOCAL_MACHINE\system\controlset003\services\MySQL\ImagePath\
HKEY_LOCAL_MACHINE\system\currentcontrolset\services\MySQL\ImagePath\
You can test if this is correct by manually starting the service from a dos
window and logging and seeing what version this executable actually is.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 9/2/04 10:01 AM
Subject: RE: 4.1.4 still reports itself as 4.1.3b-beta
Here is the manual. I suggest you try a search for "LIMIT" in the
context of a SELECT.
http://dev.mysql.com/doc/mysql/en/index.html
However what it sounds like you really ought to do is give a walk
through the tutorial.
http://dev.mysql.com/doc/mysql/en/Tutorial.html
If, after exploring these
Say it with me:
"The manual is your friend. The manual is your friend. The manual..." -
(it just bit me, too, on another thread) LOL
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Stuart Felenstein <[EMAIL PROTECTED]> wrote on 09/02/2004 11:02:06 AM:
> Wait!!
Shawn,
I'm not certain you are saying otherwise (or simply recommending against
it), but I want to point out that mysql can handle separate auto_increment
series for each client_id with MyISAM or BDB tables. You set up the table
like this:
CREATE TABLE messages (client_id UNSIGNED INT NOT NU
Thank you. Michael. I do remember reading that (now that you got me to
re-read that part of the manual. "The manual is your friend. The manual is
your friend. The...") but I have never used that feature so it didn't come
to mind as I was writing. Apologies to all for not pre-checking myself
(no
Victor
C:\MYSQL\BIN\mysqld-opt --defaults-file="C:\WINDOWS\my.ini" MySql
is what the path-to-executable states. If I remember rightly, the new
version should be mysqld, period. Is that what's wrong?
Will I have to tweak the registry to change that?
Cheers
Terry
- Original Message -
>
Wait!! Don't answer...it's that LIMIT
thing.
:)
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I'm tring to extract all records belonging to one ID
> in a table.
> BUT! I want to do it in piece meal. Meaning a
> record
> at a time.
> I am assuming I need some kind of
I'm tring to extract all records belonging to one ID
in a table.
BUT! I want to do it in piece meal. Meaning a record
at a time.
I am assuming I need some kind of count mechanism.
Example:
I want to see the first 3 purchases this member made.
Instead of grabbing them all in one shot, I want t
Hi,
I've experienced a hang after running a query wich is run usually 2 to 3
times a day without a problem till now.
This is what the error log reports
nnoDB: Thread 4784139 stopped in file btr0pcur.c line 205
Attempting backtrace. You can use the following information to find out
where mysqld
That's a little trickier. You can use SUBSTRING_INDEX() to split a string
on the Nth '/', but N will vary with path length. With N = -1, though,
we'll get the piece after the last '/' (the filename). Then we could
replace that with nothing in the original string. That is, something like
thi
I didn't understand the problem very well, but maybe disabling the pager
before that query where you set @temp, do the query, setting the pager
to its default value and then do the "next statement to produce the
actual result."
\P cat /dev/null
SELECT @temp := columnID FROM table WHERE column = w
At 04:13 PM 9/1/2004, Sun, Jennifer wrote:
Thanks Mike.
Seems like even with handler, the big query process is still consuming all
my RAM and swap and being killed with error
'VM: killing process mysql
__alloc_pages: 0-order allocation failed (gfp=0x1d2/0)'
I would like to find a startup paramete
In the registry and/or the windows service utility see which executable is
actually in the path.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 9/2/04 9:19 AM
Subject: Re: 4.1.4 still reports itself as 4.1.3b-beta
Oh, yes, certainly, Egor. I stopped it before doin
Oh, yes, certainly, Egor. I stopped it before doing the upgrade, and
restarted afterwards. And have restarted several times since, because I
couldn't believe it!
The majority of the files now in the c:\mysql directory have creation
dates on or about 27 August, the documentation is for 4.1.4gamm
No, you aren't asking too much of MySQL in most of your questions but in
another question, you are. Let me explain.
PRIMARY KEYs are nothing more than UNIQUE INDEXES on a table. How many
columns it takes to uniquely identify any row of information depends on
your data structure. Many people use
Yes, I confirm, it's a bug.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /
A)
0. optionally: start transaction;
1. create temporary table mytemptable select * from mytable order by mytableprimarykey
limit 10;
2. insert into destinationtable select * from mytemptable;
3. delete * from mytable order by mytableprimarykey limit 10;
4. drop mytemptable;
5. optional
"Santhanam" <[EMAIL PROTECTED]> wrote:
> Dear Friends,
>I am trying to compile PHP with MySQL support in an HP DL380
> server (Xeon Processors). The MySQL is build with Intel Compiler.
> I am getting the following problem / error :
You have to link the client applications with some intel
What _exactly_ would you like to know? The term "architecture" is rather
all-encompassing and, to me anyway, too vague to answer . What specific
element(s) of MySQL do you want detailed information about?
Of course, you could RTFM -> http://dev.mysql.com/doc/mysql/en/index.html
It's on-line, se
We have no idea what you are running, or what you are running it on.
matt ryan wrote:
040901 18:36:21 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040901 18:36:21 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when re
J S wrote:
Hi,
I want to copy data from one table to another. However I need to do
this carefully because I haven't got much of space left. I was
thinking of maybe selecting data from every 10 rows of the old
table, inserting it into the new table, then deleting those rows from
the old tab
Seena Blace <[EMAIL PROTECTED]> wrote:
> I wanted to setup connectivity between mysql database and oracle database.I have one
> database in mysql from which all tables data I want to insert real time data into
> oracle database.How to connect mysql database with oracle database?
>From what I
Terry Riley <[EMAIL PROTECTED]> wrote:
> I have tried several instals (Windows XP), using binaries from several of
> the mirrors, over a 4.1.3b-beta-log version.
>
> No errors reported during any install, but it still reports itself as the
> 4.1.3b-beta-log version - both in MySQL Administrator
"Ronan Lucio" <[EMAIL PROTECTED]> wrote:
> I had a problem with our MySQL server-4.0.18 where
> it suddenly stoped working.
> Even a KILL command didn´t killed the mysqld process.
Use brute force - kill -9.
> Does anyone knows what could make MySQL hangs?
Improper build, wrong hardware, miscon
"Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> wrote:
> We are trying to put a monitoring solution in place at a client and have
> come up against something during testing. If the replication user
> disappears off the master and the slave cannot log in, the
> Slave_IO_Thread still shows runni
Michael Winston <[EMAIL PROTECTED]> wrote:
Okay, so the first thing to try is obviously enlarge the max_connections.
Have you tried this?
Is it a webserver backend database?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
Hi,
I want to copy data from one table to another. However I need to do this
carefully because I haven't got much of space left. I was thinking of maybe
selecting data from every 10 rows of the old table, inserting it into
the new table, then deleting those rows from the old table.
Could so
040901 18:36:21 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040901 18:36:21 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when reading data from binary log
040901 18:36:21 Slave I/O thread exiting, read up to log
Wim Verhaert wrote:
Is there any way to return multiple result variables from a stored
procedure? And I guess the answer is NO.
Or does anyone know how I can Concatenate (using the CONCAT function) to
glue together
my multiple results into one string that then can be post processed in
perl.
85 matches
Mail list logo
