Hello Michaël,
Thank you for the tips. SHOW CREATE TABLE helped me figure out that my
table was using Latin1 and I was able to change it to utf-8. However, I
did not see any encoding specified on the column with this command.
I tried to fix the connection encoding with this line of Perl code:
VALUES
('$engl','$arab');");
---
I also dropped the English string completely, but the Arabic still writes
to the wrong field--strange behavior, but I'm sure it's a problem with the
Arabic.
Thanks,
Jon
clause 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 wrote:
> 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' passw
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=discussedNews&gid=72881&item=60056153&type=member&trk=eml-anet_dig-b_pd-ttl-cn
On Wed, Aug 3, 2011 at 1:10 AM, Angela liu wrote:
> Hi, Folks:
>
> Does mysql su
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 wrote:
> Hi, Folks:
>
> Does mysql support master to master replication, or master to
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 wrote:
> you can also use EXPLAIN, which will give you much
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 reques
m/doc/refman/5.1/en/mysql-cluster-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.
--
Jo
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
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 work
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 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 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.
>
>
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 = preg_replace("/#.*
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. Y
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 MySQL-p
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
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%22&hl=en&start=90&sa=N
>
> you'll find about a hundred web sites encountering the exact same error.
Indeed, I noticed that ;-)
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:
OperationalEr
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 ho
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 = "S
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 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
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 (not
ke 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 +
l Fischer wrote:
On Wed, 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 th
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, th
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 w
Miles Thompson <[EMAIL PROTECTED]> wrote:
> At 07:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote:
> > .. 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, sin
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 res
These include:
http://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 PROTE
t both, 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]
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
>
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 (phr
h the files nfs
mounted.
mysqladmin status doesn't show any slow queries:
Uptime: 1215323 Threads: 2 Questions: 2191970 Slow queries: 0
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]
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 pos
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
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.
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
s or something
completely different?
Thanks in advance
Jon
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 (Silic
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
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 that
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 differ
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.
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 d
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 driv
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 thr
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 and
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
manually
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
->connect ("DBI:mysql:mailscanner"; mailwatch, mailwatch);
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.p
tem
but I 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 arch
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:htt
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 Database
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
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 Lis
ee the databases 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/tes
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: my
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 havi
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: http://
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 caus
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 caus
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?
I have a sql script that needs to be re entered
Like to know how to query MySQL for loaded or installed modules. Is this done
through using the code:
I'm looking on my system for loaded modules such as DBD-MySQL, zlib-devel and
perl-DBI.
Thanks
Like to know how to query MySQL for loaded or installed modules. Is
this done through u
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.
-jsd-
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 unsubscri
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: './gspo
> 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
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
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 interfac
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 % s
-Original 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 compute
com
> Subject: Re: Non-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/
n-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
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,
L PROTECTED]
> 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
> 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
> tempor
ginal Message-
> 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 performan
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 ...
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? (Basic
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 colu
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
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 indeed
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 b.
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. A
led 4.1.10a 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 s
ib, /usr/lib or some other standard place. If this is the problem,
install the static libraries and try again. If this isn't the problem,
examine config.log for possible errors. If you want to report this, use
'scripts/mysqlbug' and include at least the last 20 rows from config
ey're
64-bit, so I'm currently a) rebuilding openssl to include shared libs and b)
adding the right option to build mysql in 64-bit mode. I will see if I get
further.
As of now, I believe my Qs are:
1. What is the correct usage of curses, term and termcap? Which do I need?
And
ND `f09` =1 AND `f10` =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
cardi
m/order.php
----- Original Message -
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,
for index: 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 fi
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:
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 165
int, but I'm not sure.
So... 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 412 matches
Mail list logo
