ideas? I tried the manual, Google and the list with no sucsess.
Thanks,
Dan T
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks Peter,
That looks pretty good to me. I never would have figured that out on
my own.
Dan T
On Jun 1, 2006, at 4:06 PM, Peter Brawley wrote:
Dan,
>I want to get a particular users 'rank' or row number from the query.
SELECT 1+COUNT(*) AS Rank
FROM results r1
INNER JO
9 | 10 |
+--+--+
I have been able to pretty much figure out any other complex query on
my own or found help from the manual but this one has me stumped.
Any help, direction or suggestions would be great.
Thanks,
Dan T
--
MySQL General Mailing List
For list arch
| pc-linux-gnu|
| wait_timeout| 28800 |
+---------+-+
Thanks again.
Dan
>
> Regards,
>
> Chandru,
>
> www.mafiree.com
>
> On Mon, Jan 12, 2009 at 9:07 AM, Daniel Kasak
> wrote:
&g
to be backed up by mysqldump. And it's worrying
that the default --opt can't do that. When I get some time I'll enter a
bug ...
Thanks for you help Chandru.
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
owed_packet to some absolutely astronomical level without
endangering things, maybe that's the way to go. Maybe ...
Anyway, thanks for the comments Andrew.
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ume you've already done this when you say that executing
the updates outside of the loop works OK.
Sounds like you're on the right track with your diagnosis so far anyway.
> Is there anything I should change in my My.Ini file?
I doubt it.
Dan
--
MySQL General Mailing List
Fo
users entered a blank space
> which is then counted as a character and is thus not null.
>
> This is causing all kinds of havoc for them as Oracle apparently still
> sees this as nulls.
I'm not sure what export method you're using, but you should be able to
fix t
long) to find the specific area that the point is located in.
I tried a simple index with my n,e,s & w but it still takes along time to
run such a query i.e. phpmyadmin times out. Any idea on the best structure
for such a query?
Thanks,
Dan T
--
MySQL General Mailing List
Fo
> 49.012 AND s < 49.012 AND e > 110.0245 AND w
< 110.0245; but takes an average of 15 seconds
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Sat, 01 May 2010 15:28:46 -0500, mos wrote:
>
> SELECT * FROM `grid`� force index(section) WHERE n > 49.012 AND s <
49.012
> AND e >
> 110.0244 AND w < 110.0244;
>
> It should give you the answer around 0.1 seconds. Give it a try. :-)
>
> Mike
It actually makes it worse by ab
nds a specific point.
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mal lat / long data.
Dan
On Sun, 2 May 2010 06:43:13 -0700, Ted Yu wrote:
> I think you may have seen this:
> http://dev.mysql.com/doc/refman/5.0/en/relations-on-geometry-mbr.html
>
> On Sat, May 1, 2010 at 11:12 PM, dan wrote:
>
>>
>> Can any one hel
4145, 49.07756615 101.36764145, 49.07756615 101.36211395) |
| POLYGON(49.08123016 101.36211395, 49.07756615 101.36211395, 49.07756615
101.36764145, 49.08123016 101.36764145, 49.08123016 101.36211395) |
| POLYGON(49.08489418 101.36211395, 49.08123016 101.36211395, 49.08123016
101.36764145, 49.0848
Sun, 2 May 2010 12:54:07 -0700, Ted Yu wrote:
> Have you tried replacing GeomFromText in place of PolygonFromText ?
>
> On Sun, May 2, 2010 at 10:59 AM, dan wrote:
>
>>
>> I am still lost... I tried this:
>>
>> UPDATE `grid` SET poly = PolygonFromTex
NOT NULL
On Sun, 2 May 2010 14:00:16 -0700, Ted Yu wrote:
> Have you declared poly to be of spatial type ?
> Cheers
>
> On Sun, May 2, 2010 at 1:03 PM, dan wrote:
>
>>
>> Tried it but no luck:
>>
>> mysql> UPDATE `grid` SET poly = GeomFro
x27;))'));
(I also created a new GEOMETRY lsd_poly column rather than the poly POLYGON
one).
Now I need to figure out the rest of it...
Dan
On Sun, 2 May 2010 14:00:16 -0700, Ted Yu wrote:
> Have you declared poly to be of spatial type ?
> Cheers
>
> On Sun, May 2,
It works great for me. After working out the bugs and adding the spatial
index I am now searching in the 0.05 second timeframe vs. minutes
otherwise.
Dan
On Sun, 2 May 2010 23:39:41 -0700, Rob Wultsch wrote:
>>>> >> >>> On Sat, May 1, 2
On 2011-1-16 20:22, Jørn Dahl-Stamnes wrote:
Hello,
I got a table that store information about which photo-albums that a client is
viewing. I want to get the N last visited albums and use the query:
mysql> select album_id, updated_at, created_at from album_stats order by
updated_at desc limit
Can anyone recommend a good tool to generate a PDF or HTML Data Dictonary
from a MySql 5 database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've searched the documentation and Google but can't find the answer.
How do I disable the multiple statements processing in v4.1.x?
I don't want the user to be able to send more than one statement (like it
was in 4.0.x).
ie: SELECT * FROM table; DROP TABLE table;
would generate a SQL error.
I w
I just installed the 5.0.4 binary for OS X.
Where's the client? It's not in my PATH. Surely I don't have to now
download the source and compile the client myself?
Dan
BEGIN-ANTISPAM-VOTING-LINKS
--
If you are not the CanIt ad
"designed to work with" and "not compatible with anything over" are two
/VERY/ different things. Yes, it performs very well on smaller tables...it
also happens to work quite nicely on bloody huge ones. My computer's
motherboard has a "designed for Windows XP" sticker on its box. That
doesn't mea
ca.adelphia.com' becomes just
'adelphia.com'. The problem is there is a more or less random amount of
stuff to the left of the goodies I actually want. So...is there an easy way
to just grab the two right-most bits between the periods?
Thanks bunches!
Dan
--
MySQL General Mailin
nda befuddling to me. Oh, the page is
in PHP if it needs a little extracurricular touch.
thanks a million!
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;);
INSERT INTO `readings` VALUES (20040120154905, '1307.6', '4.62.127.164',
'lsanca1-ar1-4-62-127-164.lsanca1.dsl-verizon.net');
INSERT INTO `readings` VALUES (20040123194031, '125.8', '68.66.221.27',
'68-66-221-27.vnnyca.adelphia.net
e only written on completion of a test,
after that I'm just looking at them to see what they were. I suppose to
avoid bloat I might have a maintenance script cut off everything older than,
say, a year...but that's a ways off yet.
thanks for all your help,
Dan
- Original Message -
I have used varchar for ALL my fields as this is the only one i know.
Alot of my rows just contain image link text ie.
/image/logoa.gif
Is using varchar overkill for these fields?. Would i be better using something else?
Any advice?
TIA
Dan
ps. for my row which contains numbers it seems i
this up and running soon ) but I'd still
like to get the issue fixed.
Any takers?
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Gary Broughton wrote:
Hi all
I've just recoded a website in PHP from ASP, running off IIS 5. It has
been tested by a dozen users over the weekend, but now I have put it
live the CPU utilisation is up at 100%, mainly swallowed up by
mysql-nt.exe. I wondered if anyone could offer any advice as to
xed 2 *nasty* bugs in apply method that were preventing the
fieldlist from being processed and applied to DB Server or in-memory
recordset
- Added 'delete' method
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm pleased to annouce the 6th release of Gtk2::Ex::DBI ...
http://entropy.homelinux.org/Gtk2-Ex-DBI/
Gtk2::Ex::DBI is an open-source helper object that makes your Gtk2-Perl
apps data aware.
It handles querying, 'painting' records on your Glade-generated form,
passing updates back to the database
I almost forgot to mention versions:
Master is:
MySQL 4.0.14-standard-log
Redhat 8
kernel 2.4.18-14
Slave is:
MySQL 4.0.12-log
Redhat 9
kernel 2.4.20-19.9
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or slave
code.
030914 2:04:14 Error running query, slave SQL thread aborted. Fix the
problem, and restart the slave SQL thread with "SLAVE START". We stopped
at log 'db-bin.012' position 709264328
Master is:
MySQL 4.0.14-standard-log
Redhat 8
kernel 2.4.18-14
Slave is:
MyS
: table ./dan_logs_innodb/sent has a primary key in InnoDB
InnoDB: data dictionary, but not in MySQL!
can anyone tell me how to fix this?
Thanks,
Dan.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
we had a database blown away (oops) and we still have the old
.frm files, is there any way to get this structure back?
is there a way to view the contents of the .frm files to
see how the tables/indexes were setup?
I can't find anything in the docs, faqs, etc.
Dan.
--
MySQL General Ma
4.1 seems stable enough, been running it since it was released.
in production, busy, commercial, enterprise environment.
plus it fixes some bugs in 4.0 and adds some (could be potentially)
necessary functions
Dan.
On Tue, 23 Mar 2004 [EMAIL PROTECTED] wrote:
>
> Hi,
>
> A qu
ng back to version 3.23 or something.
Yes the structure changes, but still...
Dan.
At 02:36 AM 3/24/2004, you wrote:
you can very well use those files, though, im not sure, if you can check the
table structure bafore restoring it.
HTH
Nitin
- Original Message -----
From: "dan" &l
just out of curiousity,
have you tried the 4.1.1 version?
there may (or may not) be something from 4.1.0 to 4.1.1
could be a total waste of time, but you never know.
Dan.
On Mon, 29 Mar 2004, Jack Coxen wrote:
> A quick update on this.
>
> I tried upgrading to the latest product
not working,
maybe you could even do a patch or two? :)
Dan.
On Tue, 30 Mar 2004 [EMAIL PROTECTED] wrote:
> I've downloaded and installed 5.0, it seems to be working fine. However, I
> need a graphical user interface to create tables and such (when I say I
> need, trust me, I need
her.
too bad, it was really a great product.
Dan.
On Tue, 30 Mar 2004, Gerald Jensen wrote:
> I would not recommend MySQL-Front ... the version they are selling is not
> from the same developer that did MySQL-Front 2.5 (and earlier).
>
> I bought a license (took a month to get
Uhm,
what are you talking about?!?
Linux has no such limitation.
you can grow files as large as you like.
right now I have an InnoDB dbase with Mysql on a linux
system and the file is over 60 GIGS in size!
maybe you meant 2 Tb? and if you did, let's see you make one that big.
Dan.
On T
nice flame! :)
btw-
Doesnt exist in out-of-the-box Linux distros,
or any distro you can currently download.
or any distro you could download (or buy) over the last few years.
it doesnt occur in "vanilla" distributions or any other
retail, commercial, or otherwise distribution...
well maybe Suse,
sing files
larger than 2gigs with mysql. perhaps because I always choose the best
file system available at the time. I chose journalling as soon as it was
available, things like ReiserFS come to mind.
for me, large files was always the default, never had to choose it
manually or change any settings. oh
oot -h `hostname` password
for me, it was always the host access line that failed. but give this
a shot.
hopefully it helps a bit.
Dan.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
o read the INSTALL-BINARY docs that come with
the solaris version.
trying to get a freebsd binary working on solaris is in for a world of
pain tho.
Dan.
On Wed, 7 Apr 2004, Ravi T wrote:
> Hi,
>
> I am trying to install MYSQL on a Sun Solaris box and here are the details and the
>
Perhaps stated a bit more correctly:
Apache is NOT unique to Linux, so any system using Apache would need this
configuration, that would include windows, MAC OS, Solaris, Irix, etc.
Can't blame the OS on a softwares requirements...
Dan.
At 08:07 AM 4/9/2004, Paul Smith wrote:
%% Dan N
Sory for the double postings, I was getting an error from the MySQL list manager and
didn't think they had been posted.
I also found the solution to my problem...
Regards,
Dan Cumpian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
on
scheme, with one master and one slave on separate machines, both using the
latest stable version of mysql 3.23.54a.
Any ideas? Is there a better "how to" on the web that any of you know of?
Have any of you seen this issue.
I really appreciate any help you have to of
http://worldcommunity.com/opensource/utilities/mysql_backup.html
I've heard great things about this script and I'm just about to start using
it myself.
-Dan
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 11:31 PM
To: MyS
dy can analyse it.
The problem is not only on the *.54 revision - i tryed to catch the bug for
more than year and did several upgrades to actually released versions
If someone has an idea how to catch more information about a problem, let
write to me. Note, it is production environment and only place
I have come across the following bug in MySQL Control Center 0.8.8 Beta for Windows:
When you have two databases that are identicle (ie, a master and a slave) and you
connect to both databases (one on a server and one on the local machine) when you
open a table listing for one database and open a
s...
Thank you,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hello again list
i've been trying to install the mysql dbd module on a cobalt-linux box and with some
help from this list, i was able to pass most of the tests on the install... only 3
remain and i don't know why it's failing. could someone please look at this output
and tell what's wrong? o
All,
I want to use the libmysql.dll in Visual Basic, I have seen a few dll's floating
around that do the wrapping for you but I want to do this myself.
Can someone point me in the direction of an example or some documentation.
ow what's happening? Alternatively, has anyone made a package
for Slackware? The rpms segfault on executing.
Please email me if you want more info (I tried attaching the config.log
but apparently it's too big...). I'm subscribed to the digest - but that
will take a day, and I'd lik
ne have an example they could cut and past here for me.
Thanks,
Dan.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-ma
make[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/root/mysql-3.23.47'
gmake: *** [all-recursive-am] Error 2
bash-2.05a#
it's complaining about this line (mysqld.cc:2314):
if (select((int) max_used_connection,&readFDs,0,0,0) < 0)
I'm running NetBSD 1.5.2. Thanks
Hi,
I'd like to alter a field and change it from being Unique using the alter
table command but can't seem to get the syntax correct? Can someone give
me an example? IE:
alter table hrcontact modify login varchar(70) not null default'' _NOT
UN
Anyone know how to seach for a subsctring instead of the whole field? sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
mysql and Perl
Can someone tell me what's wrong with this code:
$sth=$dbh->prepare("SELECT Contacts FROM Info WHERE Name=?);
$sth->execute("%$sname%");
$dname = $sth->fetchrow_array;
$names is supposed to be a substring. So if I want to search for a middle
name or just a first name or even a
as their own tmp tables... But I don't know how to check for
the existance of tables.
How should I go about this?
Thanks in advance!
Dan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
ormation work? Or is
there an easier way that i have overlooked.
Dan
x27;s
always more efficient to cache inside mysql, though, since read
syscalls aren't free.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In the last episode (Apr 15), Charles Q. Shen said:
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> > In the last episode (Apr 15), Charles Q. Shen said:
> > > This question is about tuning the innodb_buffer_pool_size in an
> > > experiment related to my earlier post
ere reversed (you had
a 3.2 server that crashed and you wanted to bring the tables into
5.0) that might work fine.
Hope this helps,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
player_id
> ORDER BY
>score,
>back_9;
It's useful to note that SELECT statements generally work in the order
they are written. The WHERE clause applies to the records as they are
read from the source tables, and at that point, no grouping has been
done, so there's n
In the last episode (Apr 19), Dan Nelson said:
> It's useful to note that SELECT statements generally work in the
> order they are written. The WHERE clause applies to the records as
> they are read from the source tables, and at that point, no grouping
> has been done, so the
] section of your my.cnf file, and restarting the
MySQL server software. Would easily help you identify whether DNS is
the cause of your issue.
Hope this helps,
Dan
Hi @all
i have a Problem with Login into a MySQL 5 Server. When i try to login from a
remote Machine into the Server, it needs
ll me how to do so on mySQL 4.x.
> [/snip]
>
> Triggers are not available in 4.x, you will need 5.x
And even triggers won't help. You will need to have your php script
poll mysql for the changes.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For l
---+---+
| pending| 2 |
| processing | 1 |
| shipped| 0 |
++---+
3 rows in set (0.00 sec)
Dan
Hello,
I would like merge this 3 query into a single one...
SELECT COUNT(*) AS count FROM orders WHERE order_status = 'pending',
SELECT COUNT(*) AS count F
eck the manual that
> corresponds to your MySQL server version for the right syntax to use
> near '('2006-04-20', '%Y-%m-%d'))' at line 2
>From the manual:
* STR_TO_DATE(str,format)
STR_TO_DATE() is available as of MySQL 4.1.1.
http://dev.mysql.com/do
way I have?
You only need one unique index to enforce uniqueness, so you can safely
convert your idxfk2 to a single-column regular index and save a little
bit of space.
ALTER TABLE t drop key idxfk2, add key idxfk2 (fk2);
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General
ields mysql
needs is in the index and it won't have to fetch row data.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sample nearest to the
point 15 minutes after the previous sample, which will end up with you
drifting off the "quarter of the hour" marks but will get you better
spacing between samples.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The easiest way might be to tell mysql in the config file where to
look for the data directory.
In your my.cnf file (typically /etc/my.cnf) under the [mysqld] section:
datadir = /Volumes/mysql-data/data
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
query only references those fields, mysql should be able to return
your results just by scanning the index.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
> The result field is different size. Is it normal behaviour for MySQL 5
> or bug? Because i have trouble with this behaviour in my apps. I use
> Delphi 5/6 for my development tool.
MySQL 5's result is correct. MySQL 4 converts "decimal" values to
"d
.locid = t3.locid
and t1.locid = t4.locid
and t2.locid = t3.locid
and t2.locid = t4.locid
and t3.locid = t4.locid
and (2720518136 >= t3.startIpNum)
and (2720518136 <= t4.endIpNum)
limit 1
Hope this helps!
Dan
Hello,
I am running Ver 14.7 Distrib 4.1.12, for redhat-linux-gnu
(i386)
p://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n order.
Hope this helps!
Dan
Adam Wolff wrote:
I have a very simple table that looks like this:
CREATE TABLE `contacts` (
`id` int(11) NOT NULL auto_increment,
`fullname` varchar(100) default NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `user_i
ut I think this holds true for both table types.
Dan
Adam Wolff wrote:
Thanks for the response, Dan. I did try ORDER BY on the table. Didn't help
-- I presume because the query is using an index.
Unfortunately, the point of my current development is to show searches
against millions o
Hello, all -
It's been a while since I've posted here, but I read the list daily.
Thanks for all the help.
What I'm dealing with here is memory problems using MySQL 5.0.19 under
FreeBSD. Although I've enabled allocation of more memory per-process,
as described by the FreeBSD notes for 5.0.x
ontractlevel cl
left join contract c using (level)
group by cl.level;
Hope this helps!
Dan
Jay wrote:
Thank you, Peng Yi-fan
but incase there is no contract with the level 5, it will not be shown.
I would like to see:
level amount
1 34
2 0
3 18
4 986
5 0
I
. In your case I'd add a UNIQUE index on the contractlevel table,
more to guard against duplicate values than for performance, though it
certainly won't hurt performance.
Dan
Jay wrote:
Thank you Dan,
[...]
Otherwise it's just not possible to show
what's not there - in
Scott, is it as easy as SELECT DISTINCT?
SELECT DISTINCT u.username
FROM user u, transactions t
WHERE u.userid = t.userid
AND t.status = 'wells'
Dan
Scott Haneda wrote:
Mysql 4.x
I have a one to many case, key is `id`, in this case, I have tables users
and transactions.
A user
it for certain queries, for example.
Hope this helps.
Dan
RV Tec wrote:
Folks,
I had some recommendations about operating system last time I posted,
and decided to follow it. It's been a couple of weeks running Gentoo
Linux 2006.0 SMP 2.6.15-gentoo-r5, with glibc 2.4 (NPTL), gcc 3.4.4, XF
ng at $2K or so. Depending on what
you have now you could put MySQL logging on some inexpensive slower
disks and re-use existing disks in a new setup.
Good luck!
Dan
RV Tec wrote:
Buettner,
First of all, thanks a lot for your reply!
This server has 4 disks to MySQL usage, in two pairs of RAI
.com/doc/refman/5.0/en/string-functions.html
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max_allowed_packet | 10484736 |
++--+
1 row in set (0.00 sec)
or:
mysql> select @@max_allowed_packet;
+--+
| @@max_allowed_packet |
+--+
| 10484736 |
+--+
1 row in set (0.00 sec)
--
Dan
Hi -
I'm trying to import some data into a MySQL database, which was dumped
from mysqldump. Just looking at the .sql file generated, there's only
about 7000 lines, on an 800M dump. I guess this tells me I have some
extremely long lines, which would be happy to take up more than
'max_allowed
Kishore Jalleda wrote:
On 5/18/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Hi -
I'm trying to import some data into a MySQL database, which was dumped
from mysqldump. Just looking at the .sql file generated, there's only
about 7000 lines, on an 800M dump. I guess this tell
unsubscribe:" :)
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
o mysqldump:
-R, --routines Dump stored routines (functions and procedures).
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi, Eugene!
I suspect that you have run into locking issues with your table, which I
am guessing is a MyISAM table. MyISAM provides only table-level locking
- that is, only one write operation can occur at any time on the table.
Other operations are blocked until their turn comes.
It appe
fragmented to the
point where performance was 1/4 of what it should have been. I started
running an OPTIMIZE TABLE command every few hours, took a couple of
seconds each time, and performance stayed good.
Hope this helps, Eugene.
Dan
Eugene Kosov wrote:
Hi, list!
I have a little table (about
osting setup/relationship.
Hope this helps,
Dan
Jan Gomes wrote:
Hy Guys,
I have a simple structure of tables, howewer has 50 million of registers and
2,5 GB of data.
The table is MyIsam and has 4 integer fields and 1 Text field, one primary key with two integer fields
and one btree ind
Ben, what does SHOW ENGINES show you? It should list all known storage
engines and indicate whether your MySQL install supports it or not.
Here's mine (5.0.21) for comparison; I was able to create a test table
as InnoDB and the SHOW CREATE showed it as InnoDB:
-> show engines;
++
or log for messages.
Dan
Ben Clewett wrote:
Hi Dan,
This is what I have. What does this mean with regards to InnoDB?
++--++--+-++
| Engine | Support
Hi -
It's been a short while since I've seen any discussion on this subject,
and I'm wondering what's happened in this arena since then.
I'm curious as to what you guys use for benchmarking nowadays. I'd like
to benchmark preformance of an InnoDB database on a fancy new server,
compared to
1 - 100 of 2044 matches
Mail list logo
