, just in the wrong column.
Thanks,
Jon
, but the Arabic still writes
to the wrong field--strange behavior, but I'm sure it's a problem with the
Arabic.
Thanks,
Jon
to something like this:
WHERE [total_words = correct_words] OR [COUNT(total_words = correct_words) =
0]
but this is bad syntax. I put the brackets there for readability.
Thanks,
Jon
.here is one way
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
On Mon, Oct 10, 2011 at 4:47 PM, Jessica Bela jessicabel...@yahoo.comwrote:
Hi all,
how I can import in my PC a database Mysql that has been created in
another PC and with other tools?
Perhaps he could make the stored procedure functional by creating a user
with the EXECUTE permission (somebody please fell free to correct me if I am
mistaken) if it is to be used to execute a stored procedure. You don't want
someone to attempt using the 'root' username with a typical 'mysql'
MySQL, to my knowledge, supports only Master to Slave replication- as well
as Master-slave-slave replication.
http://dev.mysql.com/doc/refman/5.0/en/replication.html
On Wed, Aug 3, 2011 at 1:10 AM, Angela liu yyll2...@yahoo.com wrote:
Hi, Folks:
Does mysql support master to master
I had seen a discussion here as well, but honestly did not test it. It may
be of help.
http://www.linkedin.com/groupItem?view=srchtype=discussedNewsgid=72881item=60056153type=membertrk=eml-anet_dig-b_pd-ttl-cn
On Wed, Aug 3, 2011 at 1:10 AM, Angela liu yyll2...@yahoo.com wrote:
Hi, Folks:
http://dev.mysql.com/doc/refman/5.1/en/query-log.html information on query
log may become useful for you in the future. Also, search the slow query
log, which also may help you in the future
On Mon, Aug 1, 2011 at 11:54 AM, Prabhat Kumar aim.prab...@gmail.comwrote:
you can also use EXPLAIN,
Low Priority Lock
Hello was wondering if anybody would have some input:
This will be on the same table.
Client (A) acquires a READ lock;
immediately thereafter a large amount of clients wait for a read lock as
well, and client(B) requests a LOW PRIORITY insert.
Another surge of clients
-news- and tacking on
.html to the end.
This sounds complicated, so here's an example:
The changelog for MySQL 5.1.23-ndb-6.2.14 can be found at
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-5-1-23-ndb-6-2-14.html
cheers
jon.
--
Jon Stephens - [EMAIL PROTECTED]
Technical
On Wed, Jun 13, 2007 at 12:50:03PM -0700, Mufaddal Khumri wrote:
mysql select * from t1 where sid != 2;
As you can see, the rows that had sid = NULL did not get returned in
the results when i did ... where sid != ;
Question: Is this behaviour correct and is in accordance to the SQL
On Tue, Jun 12, 2007 at 11:09:41AM -0400, kalin mintchev wrote:
I guess a lot of that depends what an acceptable query execution time for
you is.
well... i don't really know. 30 secs maximum?! i've never worked with
such huge tables. 3 - 5 million records is fine but i've never worked on
On Fri, Jun 08, 2007 at 03:14:18PM +0530, Ananda Kumar wrote:
How do i give only select privilege to a specific database.
GRANT SELECT ON abc.* to 'ab'@'%' identified by 'ab';
Like that.
mysql select select_priv from user where user='qa';
+-+
| select_priv |
+-+
On Fri, Jun 08, 2007 at 04:25:00PM +0530, Ananda Kumar wrote:
So, what ever i did is right?
Yes. User 'ab' can SELECT on all tables in database 'abc'.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, Jun 06, 2007 at 05:56:44PM -0700, Peter Rosenthal wrote:
On 04/06/07, Jon Ribbens [EMAIL PROTECTED] wrote:
Um, what? Both that and the methods described in the magazine are
completely wrong. You use mysql_real_ecape_string(), that's it.
I would disagree on the use
On Mon, Jun 04, 2007 at 02:44:25PM -0700, Daevid Vincent wrote:
Thanks for the magazine. I already incorporated a little extra SQL
injection checking into my db.inc.php wrapper...
//[dv] added to remove all comments (which may help with SQL injections
as well.
$sql =
On Tue, May 15, 2007 at 04:13:33PM -0500, Kenneth Loafman wrote:
Can't tell. The docs are somewhat lacking in detail, however, if I do a
db.autocommit(True) it works as it should.
Will have to dig into the API code and see if that is where the semantic
discontinuity lies.
The
On Tue, May 15, 2007 at 06:39:21PM -0500, Kenneth Loafman wrote:
Interesting... guess the intent was a disconnect that would break code
trying to work on MySQL, regardless of engine selected. That decision
makes it two products, MySQL/MyISAM and MySQL/InnoDB with different
semantics. Yes,
On Thu, May 10, 2007 at 05:17:12PM +0100, Jon Ribbens wrote:
I suspect some sort of bug in the MySQLd authentication code.
I've managed to discover using --debug that it's due to MySQLd failing
to handle EINTR from read() in the authentication stage.
I've filed a bug report: http
On Thu, May 10, 2007 at 03:37:26AM +0100, Jon Ribbens wrote:
I've just upgraded all the clients and servers to 5.0.41 (which looks
like it just came out); I'll see what happens.
It hasn't solved the problem, but it has changed the error message to:
OperationalError:
(2013, Lost
On Thu, May 10, 2007 at 08:58:37AM -0600, mos wrote:
If you do a google search:
http://www.google.ca/search?q=lost+mysql+connection+%22reading+authorization+packet%22hl=enstart=90sa=N
you'll find about a hundred web sites encountering the exact same error.
Indeed, I noticed that ;-)
Maybe
We are using MySQL 5.0.27 on RedHat Enterprise Linux ES release 4,
and the MySQL-python-1.2.1_p2 connector.
We are getting intermittent mysterious errors as follows:
OperationalError:
(2013, 'Lost connection to MySQL server during query')
when attempting to connect to the MySQL server
On Wed, May 09, 2007 at 09:22:34AM -0400, Michael Dykman wrote:
I realize that's quite unlikely that you have performed a similar
sloppy import but there is likely some edge condition on your server
(wierd permissions in the data directory, corruoted tables, etc.)
but I still recommend that
On Wed, May 09, 2007 at 11:17:59AM -0400, Michael Dykman wrote:
When we first examined our server logs, we saw the same.. in our case
(again) it was only when we slowed down and examined the timestamps on
the start/stop messages that we realized that the server was
restarting at unexpected
On Wed, May 09, 2007 at 07:14:38PM +0200, Martijn Tonies wrote:
I have a table of properties that is linked to a table f images with a one
property to many images relationship. I have manged this with nested
queries but want to try and do it on one line. My current query
$query = SELECT *
On Wed, May 09, 2007 at 10:07:41PM -0400, Mathieu Bruneau wrote:
We found a similar issue because we were using persistent connection in
php and had a firewall between the mysql and the webserver. The problem
is that our persistent connection were setup for lasting up to something
like 8 hours
it into the official 5.1.14 release announcement is entirely my
fault, and I hope you will accept my deepest apologies for the omission.
cheers,
j.
--
Jon Stephens - [EMAIL PROTECTED]
Technical Writer - MySQL Documentation Team
___ Brisbane, Australia (GMT +10.00)
_x_ Bangkok, Thailand (GMT +07.00
I'm curious to know why simply having a UNIQUE constraint on the
column is inadequate...
-JF
On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote:
Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
Performance issues? In mysql, in general?
Yes, in the context of the application,
, Nov 08, Jon Frisby wrote:
On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote:
Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
Performance issues? In mysql, in general?
Yes, in the context of the application, there is a very good
reason for doing this, and not using an auto
Miles Thompson [EMAIL PROTECTED] wrote:
At 07:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote:
snip .. further notices; and SolidDB, which
is still β.
Help this poor English-speaker - what's the symbol you use to describe
SolidDB?
I assume it is a beta character, since
disclaimer: i know nothing about java or jdbc. a co-worker is trying to
access a database i've set up using jdbc. he says that my enum column
is always returning an integer value instead of the string. obviously
this is less than desirable.
does anybody have any advice i could give him on
I have a simple single-table SELECT query that takes of several
minutes to complete, due to a very large number of result rows being
involed. I don't think there is any way to optimise the query - MySQL
is already using the appropriate index etc, it's just a huge table and
the query has a large
://dev.mysql.com/tech-resources/articles/mysql_5.1_partitioning_with_dates.html
http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitions.html
- both of which discuss date-based partitioning techniques that you
might find useful.
cheers
jon.
--
Jon Stephens - [EMAIL PROTECTED]
Technical
, LOCK TABLES and read-only in my.cnf, don't
get this result.
How about only granting select rights to the user?
/Jon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Opens: 0 Flush tables: 1 Open tables: 64 Queries per second avg:
1.804
Thanks in advance
/Jon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 8/17/06, Chris [EMAIL PROTECTED] wrote:
Jon Molin wrote:
Hi list
I have 5 tables:
words (word_id int auto_increment, word varbinary(40)) (has ~3.5M
rows) with the keys:
PRIMARY KEY (`word_id`),UNIQUE KEY `word_ind` (`word`)
phrases (phrase_id int auto_increment, phrase varbinary(100
On 8/17/06, Chris [EMAIL PROTECTED] wrote:
Unfortunately didn't that help, it leads to:
++-+---+---+---
| id | select_type | table | type | possible_keys
| key | key_len | ref | rows| Extra
|
Ed Pauley II wrote:
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication
Thanks both Devanada and Peter, your replies helped me resolve it.
/Jon
On 7/30/06, Peter Brawley [EMAIL PROTECTED] wrote:
*I'm trying to make stored procedures use parameters for limit and
tables, I
guess this is either me using the wrong datatype or it's not possible.
I'm
having the same
different?
Thanks in advance
Jon
On 7/25/06, Visolve DB Team [EMAIL PROTECTED] wrote:
Hello Jon.
Hi there Team :)
And thanks for the quick reply
Could you tell me the version of MySql ?. You can find the version by
excuting the command
SELECT version()
If the version is below 5, the stored procedure feature would
But the scope of a prepared statement is only the session? I want a stored
procedure to avoid some sql in clientside code...Or do you mean a prep in
the stored?
/Jon
On 7/25/06, Burke, Dan [EMAIL PROTECTED] wrote:
If I understand correctly, what you need is prepared statements.
http
On 7/25/06, Chris White [EMAIL PROTECTED] wrote:
On Tuesday 25 July 2006 02:10 am, Jon wrote:
CREATE PROCEDURE sp_test1 (IN some_limit int)
select * from some_table limit some_limit;
and
CREATE PROCEDURE sp_test2 (IN some_table table)
select * from some_table;
Well, first off
It was my impression, from the information we've collected that our
problem is very specific to Opteron. It's possible that your problem
is actually unrelated. :(
-JF
On Jul 14, 2006, at 7:24 AM, living liquid|Christian Meisinger wrote:
We're using Opterons, Linux 2.6.x, and a SiL
We're using Opterons, Linux 2.6.x, and a SiL (Silicon Image) SATA
chipset whose particular model number I don't have in front of me.
After MUCH MUCH MUCH trial and error we've discovered that:
1) 2.6.16 substantially alleviates the problem but doesn't eliminate it.
2) There is a 3Ware card
On Jul 13, 2006, at 3:03 PM, mos wrote:
At 03:45 PM 7/12/2006, Jon Frisby wrote:
This REALLY should be an academic concern. Either you have a system
that can tolerate the failure of a drive, or you do not. The
frequency of failure rates is pretty much irrelevant: You can train
incredibly
This REALLY should be an academic concern. Either you have a system
that can tolerate the failure of a drive, or you do not. The
frequency of failure rates is pretty much irrelevant: You can train
incredibly non-technical (inexpensive) people to respond to a pager
and hot-swap a bad
On Jul 12, 2006, at 12:45 PM, Scott Tanner wrote:
I am hoping the newer SATA II drives will provide SCSI performance
at a
reasonable price. It would be interesting to see if anyone has
polled ISP's
to see what they're using. I know they charge more (or at least
they used
to) for SCSI
On Jul 12, 2006, at 12:56 PM, Daniel da Veiga wrote:
On 7/12/06, mos [EMAIL PROTECTED] wrote:
At 12:42 PM 7/12/2006, you wrote:
On Tuesday 11 July 2006 19:26, mos wrote:
SCSI drives are also designed to run 24/7 whereas IDE drives
are more
likely to fail if used on a busy server.
This
On Jul 12, 2006, at 12:58 PM, Chris White wrote:
On Tuesday 11 July 2006 04:18 pm, Brian Dunning wrote:
My understanding is that SCSI has a faster transfer rate, for
transferring large files. A busy database needs really fast access,
for making numerous fast calls all over the disk. Two
It's my understanding that the biggest remaining difference has to do
with SCSI having far superior command queueing capabilities --
although SATA's command queueing may have closed the gap somewhat --
which provides for much better real-world performance when you have
multiple database
Markus Fischer wrote:
Basically, this means if I've a table like this
id1
id2
id3
id4
id5
and I've two different select statements:
select * from ... where id1 = .. and id2 = ..
and the other being
select * from ... where id3 = .. and id4 = ..
I would create two indexes, one for id1/id2
I'm still having a problem starting MySQL.
I get the following message:
Unable to initialise database connection: Can't connect to local MySQL server
through socket '/var/run/mysqld/mysqld.sock'
I've check the /etc/mysql/my.cnf and the sock file is supposed to load in
'/var/run/mysqld.
Thanks
Our mysql master machine crashed (hardware problem) and rebooted. When
it came back up, it started a new master log file. The slaves, however,
were all stuck on the last log file. They still showed both replication
threads running, no errors, but they just did not advance. I had to
Is there a way to recreate the mysqld.sock file, it has gone missing from
:/var/run/mysqld . Now MySQL will not run.
Thanks
Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
Resellers for: Novell Gold Partner, Cisco
);
if ($dbh) {print Connection successful! \n }
error message:
DBI version 192.168.10.4 required--this is only version 1.46 at
/usr/share/perl/5.8/Exporter/Heavy.pm line 107.
BEGIN failed--compilation aborted at ./dbi.pl line 5.
Any ideas?
Jon
--
MySQL General Mailing List
For list archives
believe this to be Version: 4.0.18 Release: 32.20 (this is with Service
Pack 3 from Novell).
How do I do a backup of the existing and restore to the current? Are there any
changes that may cause my apps to have a fit?
Thanks
Jon
--
MySQL General Mailing List
For list archives: http
I've created a database with a table and etc. I'm now getting a msg stating
the table has gone missing.
Is their a way to either reindex or import the database so the table can show
up.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Having an error in a script that I cannot figure out why it's not working. The
problem is on line 15 while ($row = mysql_fetch_object ($result)).
Movie DatabaseBR
pre
?php
// Connect to MySQL server
// User name is root and password is blank
$link =
In a new setup I had the users table in MySQL. A few hours later I went to
setup a new account and found out that the user table is missing. Is there a
way to get it back? I can still login as root and myself.
I wanted to add another user to the database.
Thanks
--
MySQL General Mailing
and create databases,
tables and input the data.
I'm using Apache2, PHP4 and MySQL Ver 12.22 Distrib 4.0.24, for pc-linux-gnu
(i386)
Thanks
Jon
Movie Database
Fatal error: Call to undefined function: mysql_connect() in
/var/www/test5.php on line 8
/var/www/test5.php:
HTML
BODY
Movie
Does anyone know of some good tutorial sites of using Apache, PHP and MySQL.?
Just starting out and want to create a website (mine) where I can change up the
data as often as I.
Thanks
Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http
I've installed mysql 4 and noticed that both mysql 4.0 and 4.1 was on the
system. In my attempt to remove the older version I may have done away with my
mysqld.sock. When I try to access mysql i'm getting the following message:
debOS:~# /etc/init.d/mysql start
Starting MySQL database server:
System:
Red hat 7.2
My SQL modules:
MySQL-devel-4.0.13-0
php-mysql-4.1.2-7.2.6
MySQL-shared-3.23.55-1
MySQL-server-4.0.13-0
MySQL-client-4.0.13-0
CAMysql-9.0-220
Msql-Mysql-DBI-perl-bin-1.1823-1
I would like to log or turn on the facility to do a verbose logging to
troubleshoot an issue I'm
I need to upgrade MySQL from a RH7.2 server to either a Suse Enterprise 9.2 or
Debian 3.1 server. I understand that the only way to get the data from the
RH7.2 server is via mysqldump. Are there any gotchas or issues doing this?
Thanks
--
MySQL General Mailing List
For list archives:
I'm trying to initialize to a database on another server from a mail server. I
can telnet to it but cannot initialize the database.
The account and user exists in the database and the paasword as I've tried it
from the mysql server.
Is there another test I can do to find out exactly what is
I'm trying to initialize to a database on another server from a mail server. I
can telnet to it but cannot initialize the database.
The account and user exists in the database and the paasword as I've tried it
from the mysql server.
Is there another test I can do to find out exactly what is
Like to know how to query MySQL for loaded or installed modules. Is this done
through using the code:
? phpinfo(); ?
I'm looking on my system for loaded modules such as DBD-MySQL, zlib-devel and
perl-DBI.
Thanks
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META
I have a sql script that needs to be re entered using the following command
mysql create.sql but the database already exists. IS there a way to
overwrite or update the database using the script, or do I have to delete the
existing database?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0
What happened to MySQL Control Center (aka mycc or mysqlcc)? The
dev.mysql.com site redirects to the Query Browser page. QB is a poor
substitute for mycc. It looks like neither of them has had active
development much lately but at least mycc, even in its beta stage, is
fairly useful.
Gleb Paharenko wrote:
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/not-enough-file-handles.html
thanks, i've upped the open-files-limit variable. we'll see how it goes.
-jsd-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Master and slaves are both Mysql 4.1.14 standard. There are six slaves,
and this error kept happening on #2 and #4, but then it stopped. I
thought it was all gone for good but today it happened on #3.
The symptom is: Replication stops with the following error:
Error 'Can't find file:
Better, mark this view (or particular rows if it's not too
expensive) as dirty and recompute it only on access, you
may spare few cycles...
That sort of depends on what you're going for. Typically materialized
views are used for summarizations of hypercubes for OLAP systems (data
marts /
You want a Pivot Table. Excel will do this nicely (assuming you have
65536 rows or less), but SQL does not provide a mechanism to do this.
If you want a web based interface you can look at Jtable. (I *think*
that's what it's called -- it's a Java web app that provides an HTML
pivot table
Create an Excel spreadsheet. Import the raw data, structured as-is,
into a worksheet. Select all the relevant columns. Go to Data -
Pivot Table and Pivot Chart Report. Click Finish. From the
PivotTable Field List, drag the respondant ID into the box labeled
Drop Row Fields Here, then drag
About 6GB... Is there any way to forcibly limit this?
-JF
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 16, 2005 2:23 AM
To: mysql@lists.mysql.com
Subject: Re: Non-linear degradation in bulk loads?
Jon,
your hardware/OS combination
in bulk loads?
Jon,
your hardware/OS combination is quite new and unusual. It
might indeed be an OS problem. We observed from a 64-bit RHEL
4 that when the file cache of the OS grew bigger than 4 GB,
then the file I/O performance dropped to one tenth of the
normal. You would not expect
-linear degradation in bulk loads?
Jon,
your hardware/OS combination is quite new and unusual. It
might indeed be an OS problem. We observed from a 64-bit RHEL
4 that when the file cache of the OS grew bigger than 4 GB,
then the file I/O performance dropped to one tenth of the
normal
Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Monday, October 17, 2005 10:52 AM
To: mysql@lists.mysql.com
Subject: Re: Non-linear degradation in bulk loads?
Jon,
I do not know. Why not install a 64-bit Linux in your computer?
Regards,
Heikki
Oracle/Innobase
as
the sole application on the machine?
-JF
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Monday, October 17, 2005 10:55 AM
To: mysql@lists.mysql.com
Subject: Re: Non-linear degradation in bulk loads?
Jon,
I am not 100 % sure that the problem we saw
]
Sent: Wednesday, October 12, 2005 8:15 AM
To: mysql@lists.mysql.com
Subject: Re: Non-linear degradation in bulk loads?
Jon,
hmm... maybe one of the indexes inevitably is in a random order.
Please post a typical
SHOW INNODB STATUS\G
when the inserts happen slowly.
What is your
Two solutions: 1) sort the rows to be inserted on the key
'email' before inserting.
2) Or:
http://dev.mysql.com/doc/mysql/en/innodb-tuning.html
If you have UNIQUE constraints on secondary keys, starting from MySQL
3.23.52 and 4.0.3, you can speed up table imports by
temporarily
Everyone,
We're trying to do some bulk data loads on several different tables (on
several different machines, using several different techniques) and
seeing dramatically worse-than-linear performance.
We've tried the bulk-INSERT syntax, and the LOAD DATA INFILE syntax.
We've done ALTER TABLE ...
-
From: Manoj [mailto:[EMAIL PROTECTED]
Sent: Monday, October 10, 2005 8:51 PM
To: Jon Frisby
Cc: mysql@lists.mysql.com
Subject: Re: Non-linear degradation in bulk loads?
Not sure but given that you suffer from non-linear
degradation in performance;my guess is you might be extending
your
I'm moving from 32-bit intel to the brave new world of AMD64. Our new
servers are dual Opterons with 16GB of RAM. We will be running mysql
4.1.14-standard on redhat enterprise linux 4 x86_64.
Since I'm new to this, what's my best bang-for-buck in setting up
mysql's memory usage?
-jsd-
Brian Dunning wrote:
I have a table of questions, and a table of answers. Each question has
a related answer record for each person who has answered that question,
and each answer is timestamped. How do I find a list of questions where
the MOST RECENT answer is less than 30 days ago?
Pooly wrote:
Damnit !
Thanks for pointing it, I forgot these things.
But it's a bit more subtle :
If any column in a table has a variable length, the entire row becomes
variable-length as a result. Therefore, if a table contains any
variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR
i'm trying to run this query:
SELECT COUNT(1) FROM MSGS m, MBOARD b WHERE b.BaseType = 0 AND m.BoardID
= b.BoardID;
MSGS has 9.5 million rows, and is indexed on BoardID
MBOARD has 69K rows and is indexed on BaseType
EXPLAIN shows:
mysql explain SELECT COUNT(1) FROM MSGS m, MBOARD b WHERE
Andrew Braithwaite wrote:
Hi,
You're doing a join on 'BoardID' on the tables MSGS and MBOARD. Is the
BoardID field indexed on the MSGS table too? If not then that may be your
problem.
MSGS.BoardID is indexed, and the EXPLAIN output I included in the
original message shows that it is
Andrew Braithwaite wrote:
Sorry, I meant to say is the 'BoardID' field indexed on the MBOARD table
too?
yes, BoardID is the primary key. BaseType is also indexed.
from the EXPLAIN output i can see that mysql is choosing to use BaseType
as the index for MBOARD (as we know, mysql can only use
Quite new to MySQl and queries in general and would like some help in the
following query:
select prDate, prName, prLEmployee, prDescription, prTotalHours, prLStatus,
prCompletionDate, prActive from tProject where prDate =2005-05-09
It generates a listing that has years from 2001 to present.
config.log for possible errors. If you want to report this, use
'scripts/mysqlbug' and include at least the last 20 rows from config.log!
So, it appears I've made things worse. :(
Any ideas where to go from here?
Cheers!
Jon
--
Jon Earle
Software Developer / Network Manager
Specialising
for AIX 4.3.3 and resolveip seems to work.
Would still like to get a current version (4.1.11 for AIX5.1), or get it to
compile.
Cheers!
Jon
--
Jon Earle
Software Developer / Network Manager
Specialising in Open Source Software Solutions
http://kronos.honk.org/~earlej/
Rocket science is a lot more fun
` =1 runs in 0.07 seconds with 200,000 records.
When I add indeces to fields f01 and f02, the query now takes 0.23
seconds. Is this expected? Is this simply the time required to load the
index? Are indeces simply not designed to work with something of such low
cardinality?
Thanks,
Jon
5.1
environment like that gives them a smooth compilation?
2. The docs say that using CXX=gcc (to use gcc as a c++ compiler) is
preferable. Why does it seem to fail for me, forcing me to using the true
g++ compiler?
Many thanks!
Jon
--
Jon Earle
Software Developer / Network Manager
Specialising
-
From: Jon Wagoner [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 07, 2005 7:31 PM
Subject: Out of memory, but plenty of swap space left
Recently I've been getting error 1041 at times, which gives the
message
to update the ulimit or add swap space. =20
Recently I've been getting error 1041 at times, which gives the message
to update the ulimit or add swap space.
This is a dedicated MySQL server, so I have no ulimit set for MySQL.
According to /proc/meminfo I have over 1GB of swap free.
Mem: 2118533120 2067628032 509050880 19677184
SELECT product_lines.* FROM product_lines LEFT JOIN
manufacturer_product_line_index ON
manufacturer_product_line_index.product_line_id = product_lines.id WHERE
product_lines.id IS NULL
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 07, 2005 11:39 AM
To:
: 1
MyISAM-table 'theTable' is corrupted
Fix it using switch -r or -o
Renato Golin wrote:
On Wednesday 06 April 2005 20:05, jon wrote:
Normal recovery seems to grab 490 rows... but, originally there were
some 22 million rows in there.
Seems your data file was corruped too not only the indexes
... what are my options here?
Machine is linux - using ubuntu on the recovery box.
-- jon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 397 matches
Mail list logo