Yes... OS X 10.4 with a 32 but MySQL binary is stable... it is the
combination of 64 bit OS (Tiger), and the 64 bit MySQL binary, and
accessing more than 2Gbytes of memory within the mysqld process that
blows up the machine. You can also run the 64 bit binary but keep the
memory allocation
I tried changing the status, but it seems only MySQL staff can do it (so the
message says), so I can't do that. Any idea how it's possible to do so?
From: Nuno Pereira [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: AES_DECRYPT output
Date: Wed, 07 Sep 2005 12:19:01 +0100
I suppose
Hi,
MySQL 4.0.26, a new version of the popular Open Source/Free Software
Database Management System, has been released. It is now available in
source and binary form for a number of platforms from our download pages
at http://dev.mysql.com/downloads/ and mirror sites.
Note that not all mirror
MySQL General List,
Server specifications:
MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
My specifications:
MySQL beginner, PHP intermediate, HTML and CSS advanced.
The situation:
I have recently installed a forum ( http://www.simplemachines.org/ )
on my web site. I
Talking limit, does it limit the search result after ordering according to
relevancy and the likes, or before?
thanks
-
Click here to donate to the Hurricane Katrina relief effort.
Talking limit (in select query), does it limit the search result after
ordering according to relevancy and the likes, or before?
thanks
-
Click here to donate to the Hurricane Katrina relief effort.
'Yemi Obembe [EMAIL PROTECTED] wrote on 08/09/2005 10:33:25:
Talking limit (in select query), does it limit the search result
after ordering according to relevancy and the likes, or before?
thanks
LIMIT operates after ORDER BY.
Alec
--
MySQL General Mailing List
For list
Hi,
MySQL locks work only until a session expries, so they will not be of much use
in your case. The best solution will be to implement this logic in your
application - the simplest method is to add a field to the table which will
keep the information about whether the specific record is locked
Just a note: the main site still reports version 4.0.25-0.
I dowloaded version 4.0.26 from a mirror, but it was necessary to tweak the URL.
Congratulations for this fantastic project,
Diana Soares
On 9/8/05, Joerg Bruehe [EMAIL PROTECTED] wrote:
Hi,
MySQL 4.0.26, a new version of the
Hello.
Here is described the possible way of how to force the rollback
(you can kill the mysqld process and set innodb_force_recovery to 3 to
bring the database up without the rollback, then DROP the table that is
causing the runaway rollback):
Hello.
I can tell, I have no my.cnf file in place, so there must be some default
Create your own and the appropriate value for the table_cache. See:
http://dev.mysql.com/doc/mysql/en/option-files.html
http://dev.mysql.com/doc/mysql/en/program-variables.html
Hello.
MySQL team verified this issue, but they've said that this is rather
a feature request, not really a bug. See:
http://bugs.mysql.com/bug.php?id=13032
Jason Pyeron [EMAIL PROTECTED] wrote:
Thanks Michael,
but it now seems that on prepared selects, the values are still
Hello.
In my opinion - yes it is, however, trust only the benchmarks :)
Jason Pyeron [EMAIL PROTECTED] wrote:
Am I correct in the statment second query is faster? This query gets
executed several million times.
mysql explain select A.* from files as A where
Is there any way I can find out how big I should set max_allowed_packet?
I have changed it from the default 1M to 32M, but I still get that error.
Or is it a bug? We use MySQL 4.0.12 on the slave and 4.0.15-max on the master.
How big should I set max_allowed_packet? The servers are dual Pentium
Hi Diana, all,
Diana Soares wrote:
Just a note: the main site still reports version 4.0.25-0.
I dowloaded version 4.0.26 from a mirror, but it was necessary to tweak the URL.
Yes, that was my fault, I sent the mail too early - sorry about it.
Glad you could work around this!
This is now
please help!
i have a fairly large innoDB table with 800mb (index 500 mb, data 300mb) and
1.8 million data sets.
the server has 8 gig ram.
the statement
SELECT id FROM table1 WHERE cityname = 'bla' (cityname has been indexed)
takes 0.0002 seconds and returns 0 rows, which was expected.
Hi!
mathias brandt wrote:
[[...]]
the statement
SELECT id FROM table1 WHERE cityname = 'bla' (cityname has been indexed)
takes 0.0002 seconds and returns 0 rows, which was expected.
the statement:
SELECT id from table1 WHERE id IN ( SELECT id FROM table1 WHERE cityname = 'bla
)
still
Hello all,
It seems that you can't change the status from closed (or can't repeat)
to another. The only hope you have is someone in the developing teem
test your bug with the combination you used: MySQL + ASP.NET + MyODBC.
But I continue to say that the problem is not in MySQL Server, maybe in
Problem solved, at least for the most and major distributions and packages.
Diana Soares wrote:
Just a note: the main site still reports version 4.0.25-0.
I dowloaded version 4.0.26 from a mirror, but it was necessary to tweak the URL.
Congratulations for this fantastic project,
Diana Soares
We found, to our chagrin, that a dump of an encoded field does not
restore properly in all cases.
Specifically, we use encode() to code credit card numbers before inserting
them in the database. We did a mysqldump to produce a transport file
from version 3 of mysql to insert the data into
hi all, here is the suituation
i've installed mysql4.1.14 under the /usr/local directory. the problem
is, the server can work properly, however, mysqladmin doesn't. i
posted it yesterday, and someone suggested me to issue the following
command, however the same error 111 occured.
#mysqladmin
We did a mysqldump to produce a transport file
from version 3 of mysql to insert the data into version 4 of mysql.
The encoded numbers were munged, presumably because they were
binary data in the dump.
Isn't this what the --hex-blob option to mysqldump is for?
--
MySQL General Mailing List
Thank you. This is a very promising answer. I don't know that we want to
drop the table if we don't have to, but knowing that we can restart the DB
without the rollback operation is a boon! We could certainly do a mysqldump
of just that table (which works fine, we continue to run nightly
This recipe is intended to minimize the impact on ongoing database
operations by inhibiting writes only during a relatively speedy
operation (creating a snapshot). The long dump operation can then be
performed on the (stable) snapshot, without interfering with ongoing use
of the live database.
Instead of your cron job, I suggest http://codenode.com/mysqlreport
The mysqlreport documentation (http://codenode.com/mysqlreportdoc)
is a pretty baseline introduction to comprehending server performance
via a mysqlreport report, and a little bit about what you can do for
certain issues.
Hello.
In my opinion (it is based on looking through the source code, but I
can be wrong) - the max_allowed_packet should be at least more than
any event in the master's binary log. The tool for researching
binary logs is mysqlbinlog utility. See:
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/limit-optimization.html
'Yemi Obembe [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 8bit, charset: iso-8859-1, 7 lines --]
Talking limit (in select query), does it limit the search result after
ordering according to
Hello.
This is not a step by step instructions. But taking into an account
that you're a MySQL beginner, in my opinion, you should read some
parts of the manual:
http://dev.mysql.com/doc/mysql/en/string-functions.html
http://dev.mysql.com/doc/mysql/en/insert-select.html
Hi,
Like advised I posted the problem in the win32.mysql.com list as well.
Still though, I'm not convinced that this is an ASP.NET problem. I say
because I tested this problem without ASP.NET too, in the program
MySQL-Front. The results there were the same as in ASP.NET, meaning the type
was
Hello.
A few months ago you've been writing about issues with InnoDB
when using a similar recipe. Please, share your experience of
how you've solved that problems.
James G. Sack (jim) [EMAIL PROTECTED] wrote:
This recipe is intended to minimize the impact on ongoing database
I would like to form
a San Diego mySQL user group, I notice we don't have one down here that I can
see. I do not want to take the burden of putting the group together but I do
have the building, large meeting room, access at night/evening, PA system if
needed, projectors if needed etc.
We did a mysqldump to produce a transport file
from version 3 of mysql to insert the data into version 4 of mysql.
The encoded numbers were munged, presumably because they were
binary data in the dump.
Isn't this what the --hex-blob option to mysqldump is for?
There is no such option to
I have lots of tables that are similar in nature:
id int(11) PRI NULL auto_increment
Name varchar(30)
DateTimeNext int(11)
The DateTimeNext field represents when this records needs attention. A
value of zero indicates it is being ignored. There are times when *lots* of
records DateTimeNext
When you add that index are more than 30% of the rows in the table
DateTimeNext1126215680?
Dan Baker wrote:
I have lots of tables that are similar in nature:
id int(11) PRI NULL auto_increment
Name varchar(30)
DateTimeNext int(11)
The DateTimeNext field represents when this records needs
It appears that mysqld is not listening on /tmp/mysql.sock.
Log into mysql and run show variables like 'socket';
This will tell you where mysqld is actually listening for socket
connections.
Then update your my.cnf files so they all have the same sock file
location as the
one that mysqld is
packet too big errors in replication are often a sign of corrupt
binary logs. If it's on a slave reading the relay log
often times flushing it will temporarily solve the problem. The easiest
way to flush the relay logs is to do a slave stop; change master to back
to the current file name and
Rick,
I will be glad to join you
Nestor :-)
-Original Message-
From: Rick Schulze [EMAIL PROTECTED]
Sent: Sep 8, 2005 1:21 PM
To: mysql@lists.mysql.com
Subject: San Diego mySQL usergroup
I would like to form a San Diego mySQL user group, I notice we don't
have one down here that I can
Eric Bergen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
When you add that index are more than 30% of the rows in the table
DateTimeNext1126215680?
There are currently 28.53% of the rows that have DateTimeNext1126215680
Does this mean something of interest? If so, what?
Thanks
Dan Baker wrote:
Eric Bergen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
When you add that index are more than 30% of the rows in the table
DateTimeNext1126215680?
There are currently 28.53% of the rows that have DateTimeNext1126215680
Does this mean something of interest?
Hi all,
I'll give you a little background so that my question is put into context.
I've already posted this question to my local programmers message group and
they said to post it here. So, here it goes:
I have a phone order system that I wrote in PHP. It has a series of pages
starting with
Hi,
Does somebody point me out where I should refer to understand what is
row level replication implemented in 5.1?
I should have read the source comments in the source tree, but the bk
port is closed at my environment.
Regards,
Kenji
--
MySQL General Mailing List
For list archives:
Isn't this what the --hex-blob option to mysqldump is for?
There is no such option to mysqldump in version 4.1.11.
From the manual:
--hex-blob
Dump binary string columns using hexadecimal notation (for example,
'abc' becomes 0x616263). The affected columns are BINARY, VARBINARY,
and BLOB
So now my question... is it possible that MySQL didn't execute that first
UPDATE query on that first page until after the rest of the process completed?
- The customer page is a basic form that posts the information to itself
with a simple UPDATE command and then goes to the next page.
hmmm... let me ask the guys how they have it all set up.
Jenifer
- Original Message -
How is your MySQL installation set up? At my company, we have a
master server and several slaves replicating off that master. All
inserts/updates go to the master, and all selects go to the
44 matches
Mail list logo