27;ll need to add one on user, as was specified in the
> create table you originally posted.
>
> On 28 April 2017 01:21:39 CEST, David Mehler wrote:
>>Hello,
>>
>> Here's the output of the command show create table
sman wrote:
>>
>> I note that the innodb status says it couldn't find an index on the
>> referenced column. Did the create statements come from your create
>> scripts
>> or from a show create table statement? I'm suspicious about the index on
>> virtual_use
Hello,
Tried recreating the virtual_users table didn't solve anything. Would
it be possible for anyone to check out my box directly?
Thanks.
Dave.
On 4/24/17, Peter Brawley wrote:
> On 4/24/2017 20:47, David Mehler wrote:
>> Hello,
>>
>> Thanks. Here&#
ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (`user`),
FOREIGN KEY (`user`) REFERENCES virtual_users(`user`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Thanks.
Dave.
On 4/24/17, Peter Brawley wrote:
> On 4/24/2017 18:16, David Mehler wrote:
>> Hello,
>>
>> I'm running Mysq
Hello,
I'm running Mysql 5.7.18.
My virtual_users are working fine, it's the new table that isn't. Or
am I missing something?
Thanks.
Dave.
On 4/24/17, Peter Brawley wrote:
> On 4/24/2017 17:41, David Mehler wrote:
>> Hello,
>>
>> Here's the outp
gt; On
On 4/24/17, Peter Brawley wrote:
> On 4/24/2017 13:59, David Mehler wrote:
>> Hello,
>>
>> root@localhost [mail]> show engine innodb_status;
>> ERROR 1286 (42000): Unknown storage engine 'innodb_status'
>
> Well it's very unlikely InnoDB m
Hello,
root@localhost [mail]> show engine innodb_status;
ERROR 1286 (42000): Unknown storage engine 'innodb_status'
This is on a Mysql 5.7 setup.
Thanks.
Dave.
On 4/24/17, Peter Brawley wrote:
> On 4/24/2017 12:28, David Mehler wrote:
>> Hello,
>>
>>
Hello,
Here's the create table sand error message.
root@localhost [(none)]> use mail;
Database changed
root@localhost [mail]> CREATE TABLE IF NOT EXISTS `lastauth` (
-> `user` varchar(40) NOT NULL,
-> `remote_ip` varchar(18) NOT NULL,
-> `timestamp` timestamp NOT NULL DE
Hello,
I'm trying to add a table to an existing database. I'm wanting it to get
one of it's fields from an already existing table. I've done this
before in this database. This works:
CREATE TABLE `virtual_users` (
`id` int(11) NOT NULL auto_increment,
`domain_id` int(11) NOT NULL,
`u
Ok I have source code thank you...I go into the build directory and I read the
reame file and for a windows build it
refers to a mysql.sln which I can't find anywhere in the file set. Anyone got
any ideas on that.
On Tuesday, April 29, 2014 3:37 PM, shawn l.green
wrote:
Hello
mysql is open source as I understand it.
I have one project out of about 6 that is failing.
I want to debug into libmysql.lib to get a better idea what might be going on...
even if it is a problem in my code. Where might I find the source/project files
to to this?
Thank you,
David Clark
Chris, take a look at Federated tables
https://dev.mysql.com/doc/refman/5.5/en/federated-storage-engine.html
No, it is not as easy as Oracle's dblinks.
David.
David Lerer | Director, Database Administration | Interactive | 605 Third
Avenue, 12th Floor, New York, NY 10158
Direct: (646) 487
ot in (Select min (B.id) from icd9x10 B
group by B.icd9, B.icd10).
I have not tested it (sorry it is a weekend here...), but I hope it will lead
you into the right direction.
David.
David Lerer | Director, Database Administration | Interactive | 605 Third
Avenue, 12th Floor, New York, NY
Thanks Shawn, This may work for us with some script changes. We'll take a look.
By the way, too bad we cannot rename a database, or can we?
See http://dev.mysql.com/doc/refman/5.1/en/rename-database.html about removal
of a "dangerous RENMAE DATABASE" statement...
David.
David L
Thanks Wayne. This a great idea to prevent user activity on the server. I’ll
use it in the future.
But I’m looking for a way to prevent user activity on a database ((i.e.
"database" being a "schema" or a "catalogue).
David.
David Lerer | Director, Database Admin
tabase so that it will be a perfect match (object wise) to production.
Is there an easy way to lock the whole database for the duration of the import
- so that no developers can update the database?
Obviously, I can revoke permissions, but I was wondering whether there is a
better approach.
Th
tabase so that it will be a perfect match (object wise) to production.
Is there an easy way to lock the whole database for the duration of the import
- so that no developers can update the database?
Obviously, I can revoke permissions, but I was wondering whether there is a
better approach.
Th
have not
tried the Percona tool. David.
- Original Message -
From: Anupam Karmarkar [mailto:sb_akarmar...@yahoo.com]
Sent: Wednesday, October 10, 2012 08:02 AM
To: mysql@lists.mysql.com
Subject: Re: Monitoring Sessions
Thanks Johan for info,
We already tried with tcpdump and wireshark
Thanks Shawn. Very informative and useful. David.
The information contained in this e-mail and any attached
documents may be privileged, confidential and protected from
disclosure. If you are not the intended recipient you may not
read, copy, distribute or use this information. If you have
Thanks Shawn. This is very useful.
Could you shed some light on how rolled-back transactions (or not-yet-committed
transactions for that matter) are treated as far as the binary logs? Are these
updates actually go to the binary logs, thus trigger replication to the salve?
Thanks, David
Cabbar, try to replace the IN subquery with an EXISTS. Something like:
SELECT * FROM A WHERE EXISTS (SELECT * FROM B WHERE A.id=B.A_ID and B.name
like 'X%');
Does it help?
David.
-Original Message-
From: Cabbar Duzayak [mailto:cab...@gmail.com]
Sent: Friday, July 06, 201
Dante, consider using views that are defined with your alternate column names
and present the application with these views rather than underlying table names.
David.
-Original Message-
From: D. Dante Lorenso [mailto:da...@lorenso.com]
Sent: Friday, May 18, 2012 5:22 PM
To: mysql
.
David.
-Original Message-
From: Carsten Pedersen [mailto:cars...@bitbybit.dk]
Sent: Monday, May 14, 2012 6:16 AM
To: P.R.Karthik
Cc: Nilnandan Joshi; Rafał Radecki; mysql@lists.mysql.com
Subject: Re: MySQL slowlog - only in file?
Alternatively, you can copy the data into another table
le indexes. In our case, the
deletes/inserts statements were invoked by a stored procedure.
David.
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Monday, May 14, 2012 9:28 AM
To: Baron Schwartz
Cc: MySql
Subject: Re: Deadlock due lockwait. How can I tell mys
Alternatively, you could use MySQL Enterprise Monitor (Oracle) and capture the
queries for very easy analysis.
I have found it very effective, especially when you have very high number of
queries per second.
I have not noticed any impact on database performance.
David.
-Original Message
select 'U02714','U02718';
insert into my_table values('U02714');
insert into my_table values('U02718');
Let me know if this is what you intended.
Dave
>
> From: "h...@tbbs.net"
>To: mysql@lists.mysql.com
>Sent: Friday, March 23, 2012 5:14 PM
>Subject: big
Jeff,
I would use a join table, teacher_flights.
create table teacher_flights(
teacher_id int(11) not null,
flight_id int(11) not null,
primary key(teacher_id, flight_id));
Dave
>
> From: Mark Phillips
>To: Mysql List
>Sent: Friday, March 23, 2012 7:28 PM
>
I was trying to get a confirmation too.
In any event, Charles, I'd try these three steps below and see what happens. I
assume that information_schema is populated "on the fly".
David.
-Original Message-
From: Brown, Charles [mailto:cbr...@bmi.com]
Sent: Friday, March 1
, users, passwords, etc (Assuming of course that the
schemas are identical on the two instances).
Thanks, David.
-Original Message-
From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf Of
Baron Schwartz
Sent: Friday, March 16, 2012 2:20 PM
To: MySql
Subject: Re: how to
Try with a combination of functions LOCATE and SUBSTR.
Locate will return the positions for WordA and WordB within the original text,
and, SUBSTR will allow you to string what you you need all together.
David.
On Thu, Mar 8, 2012 at 4:11 PM, Hank wrote:
> I have a simple problem:
>
>
Have you tried to set city = null (i.e. without the quotes)? David.
-Original Message-
From: Richard Reina [mailto:gatorre...@gmail.com]
Sent: Friday, March 09, 2012 4:24 PM
To: mysql@lists.mysql.com
Subject: query problem with null
When I do the following query:
SELECT * FROM
On Thu, Mar 1, 2012 at 8:57 AM, Shawn L Green wrote:
> On 2/29/2012 5:54 PM, LUCi5R wrote:
>
>> JW,
>>
>>
>>
>> I'm trying to understand LEFT JOIN as we go - but it's not working.
>>
>>
>>
>> This query
>>
>>
>>
>> SELECT *
>>
>> FROM CUSTOMERS
>>
>> LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHON
It may not have an impact on you, but be aware of this severe (imho) bug that
caused read_pnly to be ignored regardless of running transactions in version
5.5.8.
See bug#58669 and others.
We upgraded to 5.5.17 where the bug was fixed.
David.
From: Viacheslav
What version do you use? David.
-Original Message-
From: Viacheslav Biriukov [mailto:v.v.biriu...@gmail.com]
Sent: Monday, November 28, 2011 7:09 AM
To: mysql@lists.mysql.com
Subject: Read_only and InnoDB transactions
Hi all.
>From the Mysql Documentation:
If you attempt to ena
Hi Folks,
I'm in need to connect from my SQL 2008R2 (64 bit) server, to my MySQL
database server...
I found this page:
http://www.mysql.com/downloads/connector/net/
This page has the 32 bit drivers, but I *believe* I would need 64 bit,
since it's being installed on the 64 bit SQL server, correct
s to this
list, and I have not been bashful about saying so publicly and privately.
David
Thanks Bier. I see what you mean.
(As a rule we always use SQL SECURITY INVOKER)
David.
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Thursday, August 18, 2011 4:20 AM
To: David Lerer
Cc: mysql@lists.mysql.com
Subject: Re: Concerned : Developer getting
Correct me if I am wrong, but my impression is that usage of
"DEFINER=" in stored procedures has no impact on runtime and is
actually optional.
(not to be confused with the clause SQL SECURITY INVOKER which is
crucial.)
Note: I use 5.1.32-enterprise-gpl-advanced-log.
David.
--
MyS
ather than trying to
move it around from platform to platform.
-Original Message-
From: Jan Steinman [mailto:j...@bytesmiths.com]
Sent: Thursday, August 11, 2011 2:37 PM
To: David Brian Chait
Cc: mysql@lists.mysql.com
Subject: Re: Import from Quicken 2004 Mac?
On 11 Aug 11, at 14:17, David
The QIF file includes a lot of data aside from basic transactions, what exactly
are you trying to end up with at the end of the day? Simply a copy of your QB
data in Mysql?
-Original Message-
From: Jan Steinman [mailto:j...@bytesmiths.com]
Sent: Thursday, August 11, 2011 2:15 PM
To: mys
dures, etc.) sortable and searchable. I use a prefix
though. My prefix is a number for one reason: Ease of communication with stuff.
A schema is assigned to a range of numbers.
Sounds old fashioned? Cobolish? So?
My 2c. David.
- Original Message -
From: Arthur Fuller
To: Martin Gaint
I agree. I use the same column name in all tables where it has the same
function - but I consistently add a suffix or prefix. And yes, it is the
old fashion way David.
-Original Message-
From: h...@tbbs.net [mailto:h...@tbbs.net]
Sent: Thursday, August 04, 2011 8:26 AM
To: r
X1234_Employee_Id on Etc.
Yes, the column names may be longer this way, but easy to refer to and
easy to communicate (by specifying a table number). I wonder what others
think about it.
David.
-Original Message-
From: Rik Wasmus [mailto:r...@grib.nl]
Sent: Wednesday, August 03, 2011 6
Hard to tell. It depends on the cardinality of tables' id (I assume the
IDs are not unique in each of the tables). David.
-Original Message-
From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com]
Sent: Tuesday, August 02, 2011 2:47 PM
To: Adarsh Sharma
Cc: mysql@lists.mysq
Add:
datadir=/path/to/datadir/mysql
to your my.cnf file and restart mysql.
-Original Message-
From: Tina Matter [mailto:ti...@umich.edu]
Sent: Friday, May 13, 2011 8:22 AM
To: mysql@lists.mysql.com
Subject: URGENT: Change Default Location of where Database Files get written?
I have a My
Go to the cmd line and type ps -ef , do you see mysqld listed? If so then it is
already running.
-Original Message-
From: Gergely Buday [mailto:gbu...@gmail.com]
Sent: Tuesday, April 26, 2011 5:56 AM
To: mysql@lists.mysql.com
Subject: problem starting server
Hi there,
I installed a my
y and depth and breadth of useful information.
David
...@gmail.com]
Sent: Sunday, February 27, 2011 12:38 PM
To: David Brian Chait
Cc: Johnny Withers; mysql@lists.mysql.com
Subject: Re: centos server's mysql version's problem
about 8,000,000 visit,and about 40,000,000 sql do
about 2g database,and the large table who aften use about 400m
2x
it performance better than 5.0 on centos when it has
> large traffic?
> 5.1 is newer,but i know not newer is better
How much traffic is "large traffic"? How large is your database? How is it
structured? What type of hardware are you using?
-David
--
MySQL General Mailing List
environments are heterogeneous
these days, not geared toward one platform vs. another.
-David
-Original Message-
From: Y z [mailto:yan...@hotmail.com]
Sent: Wednesday, February 09, 2011 8:32 AM
To: vegiv...@tuxera.be
Cc: mysql@lists.mysql.com
Subject: RE: Replacing MS SQL with MySql
To borrow your line of reasoning, translators can be rather slow and
unreliable. Adding the extra overhead and complexity is certainly not worth the
potential gains.
-Original Message-
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Tuesday, Fe
7:20 PM
To: Yannis Haralambous
Cc: David Brian Chait; mysql@lists.mysql.com; y...@mpi-inf.mpg.de
Subject: Re: How do increase memory allocated to MySQL?
You're query is doing a full table scan.
2011/2/3 Yannis Haralambous
mailto:yannis.haralamb...@telecom-bretagne.eu>>
just a single ta
.
Thanks,
David
-Original Message-
From: Yannis Haralambous [mailto:yannis.haralamb...@telecom-bretagne.eu]
Sent: Thursday, February 03, 2011 5:43 PM
To: mysql@lists.mysql.com
Cc: y...@mpi-inf.mpg.de
Subject: How do increase memory allocated to MySQL?
Hi everybody,
I have loaded a very big
an operation that takes 1s. Congratulations, you've just
poured $$ down the drain. But boy wasn't that fun! :)
Good luck with the implementation. I'd love to hear how it pans out once
you're done, and I'm sure the list would find it useful as well.
David
uires searching
first for all children, then all grandchildren, and so on, resulting in a
recursive query.
Using the nested sets model requires a single non-recursive query to get the
same data.
David
adjusted. Adding categories to the hierarchical model is definitely faster
so it comes down to your insert-to-select ratio. Moving a subtree is also
much easier with the hierarchical model.
David
On Thu, Jan 20, 2011 at 2:40 PM, Jerry Schwartz wrote:
>>-Original Message-
>>From: Dotan Cohen [mailto:dotanco...@gmail.com]
>>Sent: Thursday, January 20, 2011 11:25 AM
>>To: Jerry Schwartz
>>Cc: mysql.; php-general.
>>Subject: Re: Organisational question: surely someone has implemented m
On Thu, Jan 20, 2011 at 2:26 PM, Dotan Cohen wrote:
> On Thu, Jan 20, 2011 at 21:24, David Hutto wrote:
>>> Is this a troll? Am I about to be baited?
>>
>> Baited to deploy what is designed to the consumer's specification?
>> Surely. From what is want
> Is this a troll? Am I about to be baited?
Baited to deploy what is designed to the consumer's specification?
Surely. From what is wanted to what is needed. Troll on that.
>
> --
> Dotan Cohen
>
> http://gibberish.co.il
> http://what-is-what.com
>
--
The lawyer in me says argue...even if you'
Pseudo = Design Algorithm
Design Algorithm = Actual Code
Actual Code = Alterable db tables
Alterable db tables = manipulated data through the app interface with data
--
The lawyer in me says argue...even if you're wrong. The scientist in
me... says shut up, listen, and then argue. But the lawyer
more difficult.
David
TO 'g...@supercrunch' IDENTIFIED BY 'qatip' WITH
> GRANT OPTION' at line 1
>
> Leaving out the quotes makes no difference.
>
> Gary R
>
> Gary, if that is the actual command, you've misspelled PRIVILEGES.
HTH,
David
Hi,
I want to check daily a large database. If I execute a "mysqlcheck", its
execution is longer the 8 minutes.
What is the best practice to check tables daily ? medium option? Fast
option?
Regards,
David
> From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
> Sent: July 1, 2010 7:58 AM
> To: David Stoltz
> Cc: mysql@lists.mysql.com
> Subject: Re: phpMyAdmin and other management tools
>
> Hi Dave,
>
> I recommend you to use "Toad for MySQL".
>
> It h
Hi Folks,
I'm currently using phpMyAdmin to manage the mySQL databases. I'm
wondering what most people like to use? I know there is "mySQL
Workbench", which I haven't really fooled with yet
Can anyone comment on what they use and why?
Thanks!
Dave
Awesome - thanks all for that clarification!
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Wednesday, June 30, 2010 1:42 PM
To: David Stoltz
Cc: mysql@lists.mysql.com
Subject: Re: INSERT with auto increment
generally, it is:
INSERT INTO TABLE1 (fieldname
Hi All,
In MS SQL, if the table has an identity field/primary key which is set
to auto increment, you can leave the value out of an INSERT statement,
and the next highest value will be automatically inserted...
For instance, with a two column table I could do "INSERT INTO TABLE1
VALUES('stu
Actually,
That table isn't supposed to have a PK, so I removed that, and it
works...same effect you suggested.
Thanks!
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: Wednesday, June 23, 2010 12:29 PM
To: David Stoltz
Cc: mysql@lists.mysql.com
Subject: Re:
Hi Folks,
I use an online SQL Design tool to design my tables, etc. This generates
script code that I can run in phpMySQL to create the tables, etc.
The below code is causing an error - see below:
CREATE TABLE `testresults` (
`id_employees` INTEGER DEFAULT NULL ,
`id_test_test` INTEGE
Hi,
Thanks to you and everyone.
I will test the same request with the ORDER BY clause.
Regards,
David.
-Message d'origine-
De : Mattia Merzi [mailto:mattia.me...@gmail.com]
Envoyé : mercredi 28 avril 2010 17:54
À : mysql@lists.mysql.com
Objet : Re: Replication : request D
Hi,
In the MySQL documentation, it is written that the two versions are
compatible to make a replication.
It seems that if I make a DELETE without the 'LIMIT 7500', the query is
replicated to the slave.
Regards,
David.
-Message d'origine-
De : Krishna Ch
master but not on the slave.
Do you know why the request is not executed on the slave?
Regards,
David.
?
Regards,
David.
-Message d'origine-
De : phark...@gmail.com [mailto:phark...@gmail.com] De la part de Perrin
Harkins
Envoyé : jeudi 15 avril 2010 02:36
À : Dan Nelson
Cc : David Florella; mysql@lists.mysql.com
Objet : Re: Make delete requests without impact on a database
On Wed
SELECT requests done on
the same time?
Regards,
David.
Hello,
Iam using OpenBSD 4.6 GENERIC kernel with mysql-server .
Machine A (faster)
AMD Athlon(tm) 64 X2 Dual Core Processor 5200+ ("AuthenticAMD"
686-class, 512KB L2 cache) 2.72 GHz
2GB of RAM
wd0 at pciide1 channel 0 drive 0:
wd0: 16-sector PIO, LBA48, 152627MB, 312581808 sectors
wd0(pciide1:
Thanks!
2010/2/16 Peter Brawley
> David,
>
> >I need count the messages don'tread in a thread.
>
> Have a look at the edge list examples at
> http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html.
>
> PB
>
> -
>
> David Arroyo Menend
Hello,
I've the next table structure:
CREATE TABLE tx_cc20_mensajes (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4)
of, "Just put up anything so our (internal) users can react to
it." Talk about vague. Geesh! However, a senior programmer told me years
ago that the life of a programmer is often filled with doing, undoing, and
redoing. And not enough appreciation for the work involved. I try to keep
that in mind.
David
On Mon, Dec 28, 2009 at 5:41 PM, Carsten Pedersen wrote:
> David Giragosian skrev:
>
>> On Mon, Dec 28, 2009 at 2:32 PM, D. Dante Lorenso
>> wrote:
>>
>> Will anything ever be equal to NULL in a SELECT query?
>>>
>>
> ...
>
> What's s
On Mon, Dec 28, 2009 at 2:32 PM, D. Dante Lorenso wrote:
>
> Will anything ever be equal to NULL in a SELECT query?
>
> SELECT *
> FROM sometable
> WHERE somecolumn = NULL;
>
> I have a real-life query like this:
>
> SELECT *
> FROM sometable
> WHERE somecolumn = NULL OR somecolumn = 'abc';
On Sat, Dec 12, 2009 at 9:54 AM, Victor Subervi wrote:
> Hi;
> I have a column defined as a set. How do I insert data into that column?
> Please give me an example.
> TIA,
> Victor
>
Lots of examples here:
http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html
Tom Worster wrote:
> how about using LEFT JOIN:
>
> SELECT ...
> FROM listings a
> LEFT JOIN Transactions b ON b.PartNumber = a.PartNumber
This gives me a result set of 456,567 lines. I'm looking for a result
set of 60-70 lines. (That's how many part numbers we have.)
> and for speed, does Tra
select distinct a.PartNumber as 'Part Number', (
select count(1)
from Transactions b
where b.PartNumber = a.PartNumber) as 'No. Sold'
from listings a
order by a.PartNumber
It currently takes 30 seconds to run. Transactions has 1200 records and
listings has 7000.
Multiple listings can
the next one without the failure on the
connection.
Any ideas as to what I need to do to make it work properly.
Thanks,
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ID' in field list is ambiguous
>
> Please note the error is about ambiguity. "products" has an ID field and so
> does "categories". If I run the statement taking out the "ID" from the
> select, it runs. So, where is the ambiguity??
> TIA,
> V
Just prefix the ID with either table name like products.ID or categories.ID.
David
item3,
> ...
> )
>
> TIA,
> Victor
>
CREATE TABLE set_test(
rowid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
myset SET('Travel','Sports','Dancing','Fine Dining')
);
From: http://dev.mysql.com/tech-resources/articles/mysql-set
Hi all,
I've got a quite large database (23G) that is running on a 5.0.32
version of MySQL. I really want to upgrade out of 5.0.32 to the
latest version of 5.1 (or even 5.4) but a straight mysql_upgrade of
the database takes long enough that I'd have serious down-time issues
(last time I benchmar
Hi all,
I'm trying to drag a database through the upgrade process from 5.0.32
but I keep running into small cross-version compatibility issues.
At present my live database is running 5.0.32 and is large enough that
it would take too long (read days) to perform an upgrade on, and
drives an importa
compare apples to oranges.
Thanks
David
Little, Timothy wrote:
> We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
>
> We are wondering how long LVM snapshots take.. in that how long might
> the DB be read-locked? Do we have to read-lock it and flush tables?
Take a look at mylvmbackup which takes care of flushing tables,
I've been doing some experimenting with the data model from the "MySQL"
book (Addison Wesley). I have no trouble understanding joins between
two tables, but I'm finding it's a little confusing when 3 or more
tables are involved. I'm going to cite a particular set of tables and a
specific quer
27;
>
> How can I reset this and allow Root access, otherwise nobody has access!
>
> Thanks,
>
> -Jason
You need a -p before the password in your command line.
David
Glyn Astill wrote:
>> Begone Postgres troll!
>
> Oh the hostility of a scorned mysql user. Joshua has posted no more FUD
> than you mysql chaps have done yourselvs over the past few days. You were
> worried about the future and he's posted a few ideas of how you can
> prepare.
No he didn't. He p
Joshua D. Drake wrote:
> I would expect that MySQL in two years likely won't exist except on the
> most tertiary level. Most new projects will be developed in either
> PostgreSQL, Interbase or one of the forks (MariaDB, Drizzle).
>
> Sincerely,
>
> Joshua D. Drake
>
> --
> PostgreSQL - XMPP: jdr
I would recommend PilotPig << http://www.pilotpig.net/ >>
Good service, good support, reasonably priced, and integrity to boot.
David
I think normally NULL values will sort at the end, correct? I believe
there's a way to make NULL values sort at the beginning, but I can't
remember how to do it. I just searched a couple of MySQL resources, but
I couldn't find it.
--
MySQL General Mailing List
For list archives: http://lists
> Right now if you want a more scalable *current* version of
> MySQL, you need to look to the Google patches, the Percona builds (and
> Percona XtraDB, a fork of InnoDB), or OurDelta builds.
Is there a webpage somewhere that compares and contrasts the above patchsets?
I thought the Google patches
Hi all,
I'm just creating my first partitioned table and have run into a bit of a
snag. The table primary key is a double and I want to create partitions based
on ranges of the key.
I have read the Partition Limitations section in the docs which states that
the partition key must be, or resolve
)) ";
>
> I'm a little lost here.
> Could somebody explain, please?
>
> Maybe the LIKE operator would be sufficient:
SELECT * from book
WHERE
last_name LIKE "I%" OR
last_name LIKE "J%" OR
last_name LIKE "K%";
David
1 - 100 of 2490 matches
Mail list logo
