Brian,
unfortuntately, to use AWE/PAE in the InnoDB buffer pool you have to compile
MySQL yourself. See /mysql/innobase/os/os0proc.c. The reason is that the
MySQL official binary is built using an older version of MS Visual C++.
Then you could also lower the default 1 MB that Windows allocates
Just wondering... I have this simple join:
SELECT b.id_commentaire AS id_commentaire, id_skynaute, id_article,
created_on, read, expediteur, email, text FROM comment_base AS b LEFT JOIN
comment_content AS c USING (id_commentaire) WHERE id_skynaute = 4671022 AND
id_article = 58366086;
Hi,
MySQL 4.0.14
This may have been queried a lot here.
We get this error and after re-starting the server
(MySQL) it seems to go away for a while.
As per instructions we have changed the max connection
in the My.ini to 500 (max_connections=500).
MySQLAdmin displays connections = 120.
Is
Thanks for your help guys!
By looking at your solutions I understand how it's meant to work. The
problem is that I'm using the older MySQL 3.23.58. And I'm bound to
stick with that version since it's standard in most Redhat
distributions, and the program I'm writing will be used on several of
Since a search on the MySQL website doesn't yield any returns for
load_defaults() - in fact it splits it into Load and defaults and doesn't
search for it directly - and none of the MySQL documentation covers this
function, does anybody know how to specify and alternate location for the
.my.cnf
From: Kevin Cowley
Since a search on the MySQL website doesn't yield any returns for
load_defaults() - in fact it splits it into Load and defaults and doesn't
search for it directly - and none of the MySQL documentation covers this
function, does anybody know how to specify and alternate
Hi,
I am facing problem while inserting more than 20,000 records using LOAD
DATA INFILE statement through comma seperated file.
Here is my statement:
LOAD DATA LOCAL INFILE '/home/mysql/isa_logs/a.txt' INTO TABLE
FirewallLog_1 FIELDS TERMINATED BY ',';
I have persistantly observed that when
Thanks for the response but I already knew about that page. The problem is
with a client application it doesn't know anything about how the server is
configured and it doesn't matter.
Basically it's a case of doing
main(int argc, char **argv)
{
my_init();
load_defaults();
I am trying to install Mysql 4.1 on a Toshiba laptop running XP, when I get
to the stage of specifying install as Windows service and include Bin
directory in Windows PATH the installation halts.
Can anyone advise how to overcome this problem / what is causing it, please?
Thanks for any help.
Warning messages, where are they to be found?
Part of the construct from a cron job script file run at the command
line interface
$ /usr/local/bin/mysqlimport -v -l --fields-terminated-by=|
--local fisheries -L -u administr -p $CRONBASE/trawler.tmp
Connecting to localhost
All,
We run mysql 3.23.58 on a Tru64 OSF 4.0F. There are 3 tables that are
consitently corrupt; these tables are fixed using myisamchk and after a
couple of hours they are corrupt again. The following are errors in mysql
error log.
/usr/local/mysql/bin/myisamchk: ISAM file
Alpesh Kothari wrote:
Hi,
I am facing problem while inserting more than 20,000 records using LOAD
DATA INFILE statement through comma seperated file.
Here is my statement:
LOAD DATA LOCAL INFILE '/home/mysql/isa_logs/a.txt' INTO TABLE
FirewallLog_1 FIELDS TERMINATED BY ',';
I have persistantly
HI,
I've 2 fields in a select query rif_CF, ID_CF...
the rif_CF value (C or F) indicate the meaning of the ID_CF...
IF rif_CF=C then the ID_CF is a customer ID, IF rif_CF=F the ID_CF is a
furnisher ID.
How can I join 2 tables (customer, and furnisher) in a query?
SELECT ID_doc, data_doc, rif_CF,
[snip]
How can I join 2 tables (customer, and furnisher) in a query?
[/snip]
RTFM http://dev.mysql.com/doc/mysql/en/JOIN.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have done this numerous times. What you have to do is match 2 conditions
in your ON clause.
I need to make up some information to answer your question because I don't
know all of the table names involved in this particular query (you didn't
say in your original post). I know you have two
Like an idiot I locked myself out of the mysql database when I went to
change the password for the root user. Is there any way I can get back
into that database and restore my mistake?
Thanks,
jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
[snip]
Like an idiot I locked myself out of the mysql database when I went to
change the password for the root user. Is there any way I can get back into
that database and restore my mistake?
[/snip]
Stop the mysql serivce, then start it from a command line with the
skip-grant-tables option. You
OK, the 2° condition on the ON caluse works
now I'll use an IF caluse to select 1 column only, like this: SELECT
IF(rif_CF='C',A.descr,F.descr)
thanks
Ciao, Carlo
At 15.43 12/01/2005, you wrote:
I have done this numerous times. What you have to do is match 2 conditions
in your ON clause.
I
I had the same error for quite some time, the issue seemed to be server
resources not being able to kill off connections quickly enough. We had a lot
of traffic and some pretty slow queries. Optimizing the queries bought us some
time, but ultimately we had to upgrade hardware. This bought us
Hi everyone.
I have been putting together a c++ wrapper for the mysql c libraries and
have stumbled across the following error...
g++ -L/usr/local/mysql/lib -I/usr/local/mysql/include -o connection
connection.cpp -lmysqlclient -lnsl -lsocket -lz -lm
Undefined first
Kevin Cowley [mailto:[EMAIL PROTECTED] wrote:
Thanks for the response but I already knew about that page.
The problem is with a client application it doesn't know anything about how
the server is configured and it doesn't matter.
Basically it's a case of doing
main(int argc, char **argv)
{
Hello,
I am trying to copy my innodb table spaces to a new array. When I copy
the files to their new location and start mysql-max with the new
configuration, invariably I get the following after I attempt to
actually connect to a database with the command line client:
mysqld-max process
Hello.
[mysqldump]
default_character_set = latin1
[EMAIL PROTECTED] wrote:
amazing.. I failed to see that in the last msg - but that seemed to do the
trick - The images appear correctly now.. is there anyway in my.cnf to tell
it to always use the command?? Thanks much for the
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
Jay Paulson [EMAIL PROTECTED] wrote:
Like an idiot I locked myself out of the mysql database when I went to
change the password for the root user. Is there any way I can get back
into that database and
Hello.
Installations often aborts at this stage when you already have the MySQL
service. What exact version of MySQL do you use? The recommended is 4.1.8.
Have you seen any error message?
Simon Tierney [EMAIL PROTECTED] wrote:
I am trying to install Mysql 4.1 on a Toshiba laptop running
Hello.
Try increasing the verbosity level, for example, with -vv or -vvv.
Joseph E. Maxwell [EMAIL PROTECTED] wrote:
Warning messages, where are they to be found?
Part of the construct from a cron job script file run at the command
line interface
$
Hello.
Such errors often occurs when you already have installed MySQL service.
freshm4n [EMAIL PROTECTED] wrote:
I got a mysql-4.1.8-win.zip,when installed,i got a error:Cannot create
Windows service for MySQL.Error:0~~How to solve?thanks~~ :) sorry for
my poor english~~
--
For
Hello.
There reason can be in big queries wich consume the resources (temp space
for example). Turn on log_slow_queries to find the guilty queries.
See:
http://dev.mysql.com/doc/mysql/en/Slow_query_log.html
You have old enough version of MySQL. Use the latest release.
A Z
Thanks for all your help Gleb! I Appreciate all your hard work!
In a message dated 1/12/2005 5:31:19 AM Eastern Standard Time, Gleb Paharenko
[EMAIL PROTECTED] writes:
Hello.
[mysqldump]
default_character_set = latin1
[EMAIL PROTECTED] wrote:
amazing.. I failed to see that in the last
Steve
Yes I am on a *ix system but this has nothing to do with the server startup
or configuration.
This is how to tell a client application where it can locate a .my.cnf file
not the system my.cnf file for the database itself.
The purpose of the .my.cnf file is to allow the client to know
I have a problem with searching for a specific term. I have a database
of about 50k names, and am attempting to search the lastname field for
'self'. My query looks something like this:
SELECT * FROM users where MATCH (first_name, last_name) against ('self').
This query works fine if I use any
Hi, mysql newb here, coming mostly from ms sql server.
I'm wondering how to find out basic info (type, str length, column name if
getting all cols from a list of tables, etc), about a set of columns from a
number of different tables. I'm also interested in getting a list of the
tables in a db.
May I introduce you to the family of SHOW commands?
SHOW DATABASES - lists all databases on a server
SHOW TABLES - lists all tables within your current database
SHOW CREATE TABLE x - returns a table containing a SQL statement you
could use to recreate the table x if you needed to
It isn't a reserved word, but self is a full-text stopword, so it isn't
indexed.
If you've built from source, the stopwords are in
path-to-source/myisam/ft_static.c
You can create your own stopword list, or turn off stopwords altogether, if
you want. See
In addition to Shawn's suggestions, the other approach you could take would
be to write Java programs that make use of the DataBaseMetaData and
ResultSetMetaData interfaces. I've used this approach with success, although
not to any great extent yet.
Of course, if you don't know Java or don't
Richard,
- Original Message -
From: Richard F. Rebel [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, January 12, 2005 8:07 PM
Subject: InnoDB files corrupt after copy to another disk???
--=-55yKssoEPEmA1J8GXefY
Content-Type: text/plain
Content-Transfer-Encoding:
I've got a question the mysql.server script (came with 4.0.12 and 4.1.8
at with the Linux binary distribution) . My shell scripting knowledge is
not even good enough to be called 'limited', but here goes:
I'm trying to use mysql.server (Redhat 9) to start MySQL in a
non-standard location.
On
[Sending this to this list, just for general reference, since I didn't
notice that Reply on this list goes to the poster, not the list. No other
list I'm on works that way, so I plead Failure To Open Eyes.]
Dave Merrill
Dave Merrill wrote on 01/12/2005 04:56:34 PM:
Thanks Shawn, looks like
SHOW TABLES lists tables in a db
DESCRIBE tablename (= SHOW CREATE TABLE tablename) outputs column info,
but your application will have to parse it.
EXPLAIN is for query optimisation analysis, not table column listings.
The manual's pretty clear on these topics.
PB
-
Dave Merrill wrote:
Hi,
I have a pretty standard database schema here with the primary key prod_id
being my most often used join column in select queries. Categories, rankings
.. just about anything having to do with products uses prod_id in a join,
and user access on these queries is pretty heavy.
I wonder whether the
| Field| Type
| Null | Key | Default | Extra |
+--+--+--+-+-++
| id | int(10)
Jerry Swanson wrote:
| Field| Type
| Null | Key | Default | Extra |
+--+--+--+-+-++
| id |
Jerry,
You could also have 3 rows returned by running the following:
select count(*)
from account
where status in ('received','send','canceled')
group by status
;
This will return 3 rows, similar to the following
+-+---+
| status | count(*) |
I have table account (see below). I need to get count of received,
count of send and cound of cancelled records. I know that I can do
this in 3 queries.
#1. select count(*) from account where status='received';
#2. select count(*) from account where status='send';
#3. select count(*) from
44 matches
Mail list logo