I've read a lot about the 32-bit/malloc-induced 2GB memory limit on
MySQL for the innodb_buffer_pool_size. Does this apply to HEAP table
size as well? In other words, if I have enough RAM can I set
max_heap_table_size > 2 GB and have a > 2GB heap table sitting in
memory?
I've used AWE with innodb
mysqladmin password secret
should work if not then mail i'll work
out a bit and reply.
--
harsh
http://www.cse.iitb.ac.in/~harsh
--
On Wed, 2
Hi there,
Restart the mysql server with option "--skip-grant-tables".
You can then login without password. And then you reset your password with
the update command like this:
UPDATE user SET password='' WHERE user='root';
Restart the server again.
Set a new password with mysqladmin like this
hi everybody,
i have a strange thing going on - i'm trying to update privileges on
some databases but it doesn't happened - even after flush privileges -
according to the manual the changes with GRANT an REVOKE should take
effect immediately but they don't. i'm using command line
also if i
You can set password again using root
and mysqladmin command.try mysqladmin --help.
correct me if i m wrong
regards
--
harsh
http://www.cse.iitb.ac.in/~harsh
--
Dear all,
I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL
password, how can it be retrieved?
Looking forward to hearing from you all.
Regards,
DT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
> What does internal distribution mean? Is it another thing than copying?
I've wondered that myself.
See
http://www.gnu.org or
http://www.fsf.org
to get more information on the GPL. Licensing, etc., is explained on
their site,
http://www.mysql.com/doc/en/Licensing_and_Support.htm
My newbie problem is solved and it may help other newbies if I share it.
The idea is to take two or more tables and combine their data into one table
that you can query. Each of the source tables may only have one or two
columns of overlap. You want records (rows) that do not fill in data in
unu
I think you have some slight errors in your connection line:
Werner van Mook wrote:
>/usr/local/mysql/bin/mysqladmin -u root password
should be:
/usr/local/mysql/bin/mysqladmin -u root --password=
>/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password
>
should be
/usr/local/mysql/
Hello,
I am running the binary mysql 4.0.13 pclinux i686 with a linux
2.4.19 kernel. I have the problem that every time a client
connects to the server and then exits, a defunct thread is
left behind. Eventually the system prevents any further threads
from being created.
Even a simple c
Ola Ogunneye wrote:
Is anyone out there running mysql with Apache and php on windows 2000?
Yes: PHP 4.3.2 with Apache 2.0.46.
What's your problem?
Peter.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The only Windows webserver that I never had security problems with was
running apache, not iis.
Curtis
> running mysql 3.23.56-nt and apache 1.23.-don't-know-exactly on windows
> 2000 professional sp3 (going to upgrade to sp4 soon) - no problems by
> now
>
> what's your question? :)
>
> ··· yve
Pete,
INSERT ... SELECT ... does not replicate properly with AUTO_INCREMENTs.
Regards,
Heikki
- Original Message -
From: "Pete Harlan" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 1:10 AM
Subject: Re: ERROR 2013:Lost
On Wed, Jul 02, 2003 at 12:55:38AM +0300, Heikki Tuuri wrote:
...
> 4.0.13 has better diagnostics. Please upgrade to it if you are not using
> MySQL replication.
Is there something wrong with 4.0.13's replication, or does it not
replicate properly with 4.0.12?
--Pete
--
MySQL General Mailing Li
Miguel,
best to upgrade to 4.0.13 because it has better diagnostics.
Regards,
Heikki
- Original Message -
From: "Miguel Perez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 1:03 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server
Heikki:
The only thing that I did with those tables is that I renamed both of them.
And I didn't drop anything. Do you think that the renamed thing did affect
my tables?..
Greetings
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Miguel Perez" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
Subject: R
Miguel,
the failing assertion is in dict_load_table():
ut_a(DB_SUCCESS == dict_load_foreigns(table->name));
Are you sure you do not have foreign keys which REFERENCE those tables?
4.0.13 has better diagnostics. Please upgrade to it if you are not using
MySQL replication.
"
Fixed a bug:
I am running the 4.0.12 version
For those tables I don't have FOREIGN KEYS here is the table desc.
CREATE TABLE CLIENTE (
FINGCIOID smallint(6) NOT NULL default '0',
FINOTIENDA smallint(6) NOT NULL default '0',
FICTEID int(11) NOT NULL default '0',
FIDIGITOVER smallint(6) NOT NULL default '0',
On Tue, Jul 01, 2003 at 04:09:26PM -0500, Miguel Perez wrote:
> The OS I'm using is Red Hat 7.3, and the mysql version is 4.0
>
> The wierd thing is that I could access those tables but just after I
> rebooted my PC
> I couldn't access the 2 tables.
> The log files has the following:
>
> "030701
Miguel,
what exact MySQL version you are running?
Have you created FOREIGN KEY constraints to those tables?
Have you downgraded to a lower MySQL version?
Regards,
Heikki
- Original Message -
From: ""Miguel Perez"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday
The OS I'm using is Red Hat 7.3, and the mysql version is 4.0
The wierd thing is that I could access those tables but just after I
rebooted my PC
I couldn't access the 2 tables.
The log files has the following:
"030701 14:27:38 InnoDB: Assertion failure in thread 36874 in file
dict0load.c line
everything you need to know and do is here:
http://www.entropy.ch/software/macosx/mysql/
On Tuesday, July 1, 2003, at 04:30 PM, Werner van Mook wrote:
Hi all,
I'm new to this list so forgive me if I tear open old wounds..;-)
I installed MySQL 4.0.13 on my mac with OS X 10.2.6
I followed the in
On Tuesday 01 July 2003 9:39 pm, Ola Ogunneye wrote:
> Is anyone out there running mysql with Apache and php on windows 2000? If
> you are out there, please respond and hopefully you may be able to help me.
> I see that most of the posts are geared towards unix/solaris.
>
> I am a newbie that needs
Hi all,
I'm new to this list so forgive me if I tear open old wounds..;-)
I installed MySQL 4.0.13 on my mac with OS X 10.2.6
I followed the instructions onthe mysql.com site.
Everything seems to be in order until I have to do :
/usr/local/mysql/bin/mysqladmin -u root password
I run this comman
Taylor,
you are running a very old alpha version of MySQL. Lots of bugs have been
fixed since.
Please upgrade to 4.0.13, or if you use replication, then 4.0.12 is a safer
choice.
Regards,
Heikki
- Original Message -
From: "Taylor Lewick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sen
I've setup my my.cnf file on the slave as:
[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock
server-id=2
master-host=206.xxx.xxx.xxx
master-user=replicateuser
master-password=replicatepassword
Master.info is:
tux-bin.001
3109
206.xxx.xxx.xxx
replicateuser
replicatepasswo
[snip]
SELECT sum(a), b, c
FROM table
WHERE statement
GROUP BY b, c
HAVING sum(a) > 0
The problem is that I was the results to be in descending order by
sum(a). I
know that GROUP BY works as an ORDER BY at the same time, but I cannot
use
the group function into the GROUP BY statement...!
What ca
Hello.
I have this simple query:
SELECT sum(a), b, c
FROM table
WHERE statement
GROUP BY b, c
HAVING sum(a) > 0
The problem is that I was the results to be in descending order by sum(a). I
know that GROUP BY works as an ORDER BY at the same time, but I cannot use
the group function into the GROU
Taylor,
SHOW TABLE STATUS reports an estimate of the number of rows.
What do you mean that you cannot access any data from the table? All SELECTs
hang?
What OS, what MySQL version?
What does
SHOW INNODB STATUS\G
print?
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transaction
running mysql 3.23.56-nt and apache 1.23.-don't-know-exactly on windows 2000
professional sp3 (going to upgrade to sp4 soon) - no problems by now
what's your question? :)
··· yves at unclassified.de
-Ursprüngliche Nachricht-
Von: "Ola Ogunneye" <[EMAIL PROTECTED]>
An: <[EMAIL PROTECT
Is anyone out there running mysql with Apache and php on windows 2000? If you are out
there, please respond and hopefully you may be able to help me. I see that most of the
posts are geared towards unix/solaris.
I am a newbie that needs help.
Thanks
Hi all. I did a delete query on an InnoDB table where items were older than a certain
date.
That worked fine, and it told me that some 30,000 objects had been deleted.
i did a commit, and then decided to delete a few more by changing the date parameter.
Now the query just hangs, and when I do a
Hi,
On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote:
> I have the following problem, when I try to connect to my DB servicios
> I get connected succesfully, but when I try to access certain tables I get
> the error
> "ERROR 2013: Lost connection to MySQL server during query" but only
Hi folks:
I have the following problem, when I try to connect to my DB servicios
I get connected succesfully, but when I try to access certain tables I get
the error
"ERROR 2013: Lost connection to MySQL server during query" but only with
those certain tables, to be more specific there's only 2
Hi I am trying to compile a small "C" program that
suppose to connect,create Database,tables.
It compiles fine with no errors but at execution the
function mysql_init(NULL) wich is suppose to return
the pointer returns nothing at all ..so i cannot
connect to the server.(I also added the librar
Run the Analyze table command. It will recalculate the Cardinality of a
key structure.
-->-Original Message-
-->From: Steve Quezadas [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, July 01, 2003 10:37 AM
-->To: [EMAIL PROTECTED]
-->Subject: MySQL gets slower over time
-->
-->HIdey Ho.
-->
-->I
Do you have a waittimeout set in you're my.cnf file? If so mysql would
of forced closed a connection that it determines was inactive for >
waittimeout seconds.
-->-Original Message-
-->From: Tina Motaye [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, July 01, 2003 5:28 AM
-->To: [EMAIL PROTEC
On 1 Jul 2003 at 10:28, Karl J. Stubsjoen wrote:
> > The normal way to do a search for a range of dates would be
> >
> >... WHERE a.submitdate BETWEEN '2003-07-01' AND '2003-07-14';
> >
> > Is that what you're looking for?
>
> submitdate happens to be a DATETIME field.
> Your suggested query
MySQL & OS version and hardware ?
Jerry
- Original Message -
From: "Steve Quezadas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2003 6:36 PM
Subject: MySQL gets slower over time
HIdey Ho.
I have a fairly large mysql database (a few million records) and queries
HIdey Ho.
I have a fairly large mysql database (a few million records) and queries run pretty
damn fast. However, over time (say, over the course of a month), performance gets
slower and slower. I am not sure why! I suspected a memory leak so i restarted mysql.
No dice. Now, if I reboot the who
Keith,
> The normal way to do a search for a range of dates would be
>
>... WHERE a.submitdate BETWEEN '2003-07-01' AND '2003-07-14';
>
> Is that what you're looking for?
submitdate happens to be a DATETIME field.
Your suggested query doesn't pull any results. Must I convert the field
first?
The MySQL homepage says:
2. Free use for those who never copy, modify or distribute
As long as you never distribute (internally or externally) the MySQL
Software in any way, you are free to use it for powering your application,
irrespective of whether your application is under GPL or other OSI appr
Two databases
data1
data2
data1 has table1 and data2 has table2
both the tables have uid field common
I want to list out common uid's from table1 annd table2
Tried many commands as i understood from documentations
but somewhere i m always wrong.
thanks
regards
---
On 1 Jul 2003 at 9:25, Karl J. Stubsjoen wrote:
> ROWS: 34,000 + searched
> explain
> select
> a.submitid,a.url,a.submitdate,a.name,a.company,a.address1,a.city,a.sta
> te,a.z
> ipcode,a.country,a.email,a.phone,a.keywords,a.title,a.description,a.su
> bmitte dby from submit as a inner join re_idx as
Egor,
It says 'update command denied to user: 'any user i put here' for table
'test2'
No matter what user/host combination I use I ALWAYS get this error.
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 5:13 AM
To: [EMAIL PROTECTED]
Subject: Re:
Hi folks,
I do a considerable amount of queries based on a date, and or date range. I
have not had much luck with optimizing these queries. In some cases I use a
date field and others a datetime field.
The following query searches through 34,000 + records, while specifiying the
exact date searche
MySQL List Archives Stats
June, 2003
Note: Up/Down % as compared with May, 2003
Posts: 2723 (Up 12%)
Authors: 745 (Up 10%)
Threads: 900 (Up 6%)
Top 20 Contributors by Numb
On 1 Jul 2003 at 11:31, Fabio Bernardo wrote:
> select (current_date - 1 )
>
> and the result was:
>
> (Currentdate -1)
> ---
> 20030700
Use this instead:
SELECT CURRENT_DATE() - INTERVAL 1 DAY;
The documentation for DATE_ADD() and other date and time f
mysql> select date_sub(curdate(), interval 1 day) as wibble;
++
| wibble |
++
| 2003-06-30 |
++
1 row in set (0.00 sec)
-Original Message-
From: Fabio Bernardo [mailto:[EMAIL PROTECTED]
Sent: Tuesday 01 July 2003 15:32
To: Mysql (E-mail)
Subject: d
today´s date: 2003-07-01
Hi there,,,
I wrote down this statement
select (current_date - 1 )
and the result was:
(Currentdate -1)
---
20030700
when i write select (current_date )
I have:
(Currentdate)
---
2003-07-01
but act
On Tue, Jul 01, 2003 at 04:14:17PM +0200, Maunza Kater wrote:
> Which Version of MySQL was used in 1999?
Looking at the MySQL Change History in the docs:
- 3.22.7 went gamma in februari 1999 (some people would use it)
- 3.22.19 was the first production release in march 1999
- 3.23.0 was the fir
hello,
I'm exporting a very big table from ACCESS to MySQL using ODBC.
I was able to do it by increasing the value of the max_allowed_packet variable in
mysql since otherwise ODBC lost the connection and I was getting an error.
But the thing is I dropped the table for a test and now I'm not b
Which Version of MySQL was used in 1999?
"Phil Dowson" <[EMAIL PROTECTED]> wrote:
> Very good question, I believe I do since it does work 90% of the time. Only
> occasionally it doesnt work, and thats why I need help
>
In wich cases it doesn't work? We need repeatable test cases.
>
>
> - Original Message ---
--
For technical s
"michael watson (IAH-C)" <[EMAIL PROTECTED]> wrote:
> Hi Victoria
>
> Thanks for your reply! However, I don't seem to have a "my.cnf" file?
> I have /etc/mysqlaccess.cnf - is that it?
> But that doesn't have anything that looks like
>
> [mysqld]
> socket=/var/lib/mysql/mysql.sock
>
> in it.
>
Seth Redmond <[EMAIL PROTECTED]> wrote:
> sorry, should have said - I get the record created, but with a null
> value in the blob - as you would for a file larger than the
> max_allowed. but I've checked numerous times (and have gone up to
> longblob) and still can't load above around 1mb.
> I s
For Mysql, 127.0.0.1 is not the same as localhost.
Localhost refers to the socket file on the operating system, and is
faster than 127.0.0.1.
Use 'root'@'127.0.0.1' in your grant statements.
Ola Ogunneye wrote:
Please somebody help me.
I have installed MySql 4.0.13 and it works up until I try
I have a field where I want to remove non-alphanumeric characters at the
end of the field. I thought of using a query like:
UPDATE table SET field=REPLACE(field, ".", "") where
It does not seem possible to use regexes inside the replace() function.
I have two questions on possible improveme
Peter Moscatt <[EMAIL PROTECTED]> wrote:
> I have just installed 'MySQL-server' and
> 'MySQL-client' onto a Mandrake 9.1 system.
>
> The two RPMs installed without error and running mysql
> from the shell was fine and did what was expected of
> it.
>
> I have now rebooted the system and when I go
"Reto Baudenbacher" <[EMAIL PROTECTED]> wrote:
> hi
>
> Sorry for this newbie-question:
>
> is it possible to simplifiy the following (working) query?
>
>
>
> "SELECT * FROM mytable WHERE
>
> ((col1 LIKE '%test%') OR (col2 LIKE '%test%') OR (col3 LIKE 'test%'))
>
> AND
>
> (col5 = 'y' OR
Maciej Bobrowski <[EMAIL PROTECTED]> wrote:
>
> Sometimes I want to restrict the structure of my data. Let's say that I
> need to some records does not contain NULL values, or some numbers are not
> longer then 10 digits. But when I try to use
>
> login char(32)NOT NULL default 'tralala',
>
Rupert Stokoe <[EMAIL PROTECTED]> wrote:
>
> I'm having problems trying to construct a delete query
> from a table. Below is a scaled down version of the
> table
>
> host userdateid
> -
> mars john 27-6 1
> pluto dave 27-6 2
> venus
"michael watson (IAH-C)" <[EMAIL PROTECTED]> wrote:
>
> I am having problems POST-installation with MySQL. A bit about my setup:
>
> SUSE Linux 8.1
> MySQL 4.0.13 (installed from tar ball)
> MySQL installed in /usr/local/mysql
>
> Everything on the installation worked fine.
> I then ran mysql
"Twibell, Cory L" <[EMAIL PROTECTED]> wrote:
>
> I have the user table which contains user record
> | Host | User| Pass | Select...|
> ---
> |% || | N... |
>
> The db record is
> | Host | Db| User | Select...|
> --
[EMAIL PROTECTED] wrote:
>>Description:
>I have just installed MySQL 4.0.4 on Linux kernel 2.4.2-2 on a
> Hewlett-Packard
>Kayak machine. I ran the mysql_install_db script with no problems,
> but am unable
>to create a root password as directed by the script. I have started
Hi,
I am trying to build DBD-mysql-2.1012 perl and mysql database driver on HPUX 11.11
operating system. I am getting this error, if I say 'make'. Can you help me to resolve
this. Mysql 3.23.42 and DBI 1.37 are installed on the machine.
ipvbs:/tmp/DBD-mysql-2.1012>make
/bin/sh -c true
Hi!
Yesterday mysql created 5 big temp files. This resulted in a full /tmp directory.
In normal condition, it is nothing in the /tmp directory.
Do someone knows what files these are, and how to prevent mysql to create big
tmp-files?
-rw-rw1 mysqlmysql697434112 Jun 30 20:03 #s
Hi
I am having problems POST-installation with MySQL. A bit about my setup:
SUSE Linux 8.1
MySQL 4.0.13 (installed from tar ball)
MySQL installed in /usr/local/mysql
Everything on the installation worked fine.
I then ran mysql_install_db
I then changed ownership of everything in /usr/local/my
Hi,
I'm having problems trying to construct a delete query
from a table. Below is a scaled down version of the
table
host userdateid
-
mars john 27-6 1
pluto dave 27-6 2
venus jane 27-6 3
mars john 28-6 4
saturn
hi
Sorry for this newbie-question:
is it possible to simplifiy the following (working) query?
"SELECT * FROM mytable WHERE
((col1 LIKE '%test%') OR (col2 LIKE '%test%') OR (col3 LIKE 'test%'))
AND
(col5 = 'y' OR col6 = 'y' OR col7 = 'y') ORDER BY col1"
Thanks for any suggestions!
Ret
Hi,
Sometimes I want to restrict the structure of my data. Let's say that I
need to some records does not contain NULL values, or some numbers are not
longer then 10 digits. But when I try to use
login char(32)NOT NULL default 'tralala',
or
id bigint NOT NULL default 5000
Hi!
I read mysql doc (4.0.5-beta.) and see this:
Note that upon connection, mysql_real_connect() sets the reconnect flag (part of the
MYSQL structure) to a value of 1. This flag indicates, in the event that a query
cannot be performed because of a lost connection, to try reconnecting to the serve
>Description:
since a few days the start of a UDF-Function crashes the
DB-Engine which results in a Restart. I have a Version
from 2003-06-03 (Bitkeeper-Archive) without any Problems.
>How-To-Repeat:
starting any UDF-Function
>Fix:
>Submitter-Id:
>Origina
>From the manual:
"If you don't have any variable-length columns (VARCHAR, TEXT or BLOB
columns), a fixed-size record format is used. This is much faster but unfortunately
may waste some space."
Can anyone more precisely quantify how significant is the difference in
performance if the table us
74 matches
Mail list logo
