d
> -Original Message-
> From: ryan.esca...@gmail.com [mailto:ryan.esca...@gmail.com] On Behalf
> Of Ryan Escarez
> Sent: Friday, October 16, 2015 2:47 AM
> To: Ryan Coleman
> Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
> Subject: Re: a
>
> c
>
> On Fri, Oct 16, 2015 at 3:01 PM, Ryan Co
ions) >> outfile.sql
> echo "USE `database2`;" >> outflfile.sql
> mysqldump -(secondsetofoptions) >> outfile.sql
>
>
>
>
> On Thu, Nov 21, 2013 at 4:44 PM, Daevid Vincent wrote:
>
> > I'm working on some code where I am trying
I'm working on some code where I am trying to merge two customer accounts
(we get people signing up under different usernames, emails, or just create
a new account sometimes). I want to test it, and so I need a way to restore
the data in the particular tables. Taking a dump of all the DBs and table
How come MySQL is not differentiating between these characters?
SELECT text_id, us, de, es, fr
FROM texts
WHERE us = fr;
Results in matching here. Notice the difference in the "scene" vs "scène"
text_id us es de fr
-- -- -- -
http://www.theregister.co.uk/2013/09/12/google_mariadb_mysql_migration/
For 10 YEARS "we" have been asking for a way to reclaim the ibdata files (or
even .MYD files) and finally someone from mysql/oracle replied. It's not great
news, but at least they acknowledge and give some explanations.
-Original Message-
From: Bug Database [mailto:do-not-re...@mysql.com
> -Original Message-
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Monday, July 08, 2013 2:11 PM
> To: mysql@lists.mysql.com
> Subject: Need query to determine different column definitions across
tables
>
> I'm noticing that across our several
I'm noticing that across our several databases and hundreds of tables that
column definitions are not consistent. I'm wondering if there is a tool or
query (using INFORMATION_SCHEMA perhaps) that will show me all databases,
tables and columns where they don't match (by column name).
For example i
Oh! I must have misread. I didn't see how you had a solution for > 64 bits.
I may have to experiment with that!
> -Original Message-
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Wednesday, June 12, 2013 11:26 AM
> To: mysql@lists.mysql.com
> Subject:
fortunate there isn't a way
to use more than 64-bits natively.
You're RICK JAMES Bitch! :-p (please tell me you know the Dave Chappelles
skit I'm referring to)
> -Original Message-
> From: Rick James [mailto:rja...@yahoo-inc.com]
> Sent: Wednesday, Ju
gt;
> On 6/11/2013 3:59 PM, Daevid Vincent wrote:
> > I am trying to implement a filter so that a user could select various
> genres
> > they want "in" or "out". Perhaps they like 'action' and 'car chases' but
> > don't like &#x
I am trying to implement a filter so that a user could select various genres
they want "in" or "out". Perhaps they like 'action' and 'car chases' but
don't like 'foreign' and 'drifting' (or whatever...)
So I want something sort of like this, however IN() is using an "OR"
comparison when I need it
http://adtmag.com/articles/2013/02/06/mysql-update.aspx
, 2012 1:54 PM
> To: Daevid Vincent; mysql@lists.mysql.com
> Subject: RE: Help with purging old logs for each customer ID
>
> If the 90 days is back from MAX(created_on) for a given customer...
>INDEX(customer_id, created_on)
> will probably be needed. And that should repla
Original Message-
> From: Rick James [mailto:rja...@yahoo-inc.com]
> Sent: Thursday, October 25, 2012 1:09 PM
> To: Daevid Vincent; mysql@lists.mysql.com
> Subject: RE: Help with purging old logs for each customer ID
>
> Off hand, I would iterate over the PRIMARY KEY, looking
I have a customer log table that is starting to rapidly fill up (we have
hundreds of thousands of users, but many are transient, and use the service
for a few months, or use the free trial and quit, etc.)
CREATE TABLE `customers_log` (
`customer_log_id` bigint(20) unsigned NOT NULL auto_incremen
ySQL. Further on, it'd be as
> simples as JOIN by name with a table with ISO-to-country-names, which
> you can fetch in hundreds of places, such as Wikipedia.
>
> -NT
>
>
> Em 03-10-2012 22:22, Daevid Vincent escreveu:
> > Anyone have a SQL dump or other programmatic
Anyone have a SQL dump or other programmatically useable map of country ISO
codes to demonyms?
http://www.geography-site.co.uk/pages/countries/demonyms.html
I can parse the strings I suppose there, but that's not quite as accurate,
and ripping that out of the HTML page to parse seems painful too.
Well, considering that MySQL/Sun/Oracle can't even figure out how to reduce
an ibdata1 file from ever-expanding after a decade
(http://bugs.mysql.com/1341), it doesn't surprise me that parallel computing
is a brain-stumper for them. :-\
Besides, I would suspect that Oracle would see this as one mo
> -Original Message-
> From: Gary Aitken [mailto:my...@dreamchaser.org]
> Sent: Thursday, June 14, 2012 2:58 PM
>
> I can get the table loaded by specifying REPLACE INTO TABLE, but that
still
> leaves me with not knowing where the duplicate records are.
To find duplicate entries
select d
elly [mailto:my...@wastedtimes.net]
Sent: Saturday, May 19, 2012 3:34 PM
To: mysql@lists.mysql.com
Subject: Re: SQL query help. Retrieve all DVDs that have at least one scene
of a certain encoding format
Hi.
On Friday 18 May 2012 18:21:07 Daevid Vincent wrote:
> Actually, I may have figured
> -Original Message-
> Sent: Friday, May 18, 2012 5:34 PM
>
> I have a table of DVDs, another of scenes and a last one of encoding
> formats/files...
>
> I want to find in one query all the dvd_id that have > 0 scene_id that's
> encoded in format_id = 13.
> In other words all DVDs that ar
I have a table of DVDs, another of scenes and a last one of encoding
formats/files...
I want to find in one query all the dvd_id that have > 0 scene_id that's
encoded in format_id = 13.
In other words all DVDs that are format_id = 13 despite not having a direct
link.
CREATE TABLE `dvds` (
`dvd_
Any plans to add sqlite to your list of supported DBs there?
I develop Android and use LAMP as the server backend. Currently I use SQLYog
as I have for like 10 years. But I would really like one GUI to work on both
the android sqlite and the mysql backend since they usually tie together.
> -O
Anyone have any thoughts on how I might optimize this query? It takes about
2 seconds. I know that seems quick, but we get nearly 30,000 hits per second
and so if we can shave this down, it helps. Also we do use memcache, but
even with that, we still see this in the slow-log sometimes. I have index
Ever heard the old saying, "If it ain't broke, don't fix it." ;-)
I'd say that as a general rule:
1. if you aren't experiencing problems then don't upgrade.
2. if you aren't subject to any vulnerabilities that may be found, then
don't upgrade
3. if you don't need a new feature introduced, then do
er_id
AND s.date = x.LastDate
ORDER BY customer_id LIMIT 10;
Thanks to "you know who you are" for pointing me in the right direction.
Hopefully this helps someone else.
d.
> -Original Message-----
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Monday,
-
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Monday, October 24, 2011 1:46 PM
> To: mysql@lists.mysql.com
> Subject: Within-group aggregate query help please - customers and latest
> subscription row
>
> I know this is a common problem, and I've been struggling
I know this is a common problem, and I've been struggling with it for a full
day now but I can't get it.
I also tried a few sites for examples:
http://www.artfulsoftware.com/infotree/queries.php#101
http://forums.devarticles.com/general-sql-development-47/select-max-datetime
-problem-10210.html
> -Original Message-
> From: Halász Sándor [mailto:h...@tbbs.net]
> Sent: Tuesday, October 11, 2011 9:28 PM
> To: mysql@lists.mysql.com
> Subject: Vista crashes
>
> I find that, when under Vista the MySQL daemon has been shut down
There's your first two problems:
[a] why are you runni
http://www.youtube.com/watch?v=b2F-DItXtZs
LOLercopter.
No SQLite support?
http://www.sqlite.org/
Seems curious you wouldn't have this yet, especially given its popularity on
both embedded systems and Android to say the least.
> -Original Message-
> From: Martijn Tonies [mailto:m.ton...@upscene.com]
> Sent: Tuesday, August 16, 2011 6:56 AM
> T
http://dev.mysql.com/tech-resources/articles/nosql-to-mysql-with-memcached.h
tml
I can think of several ways to accomplish this (or close to it).
* Assign each server a number and prefix/append that number to the unique
ID.
* initialize each table on each server at a different huge number so they
don't ever collide:
ALTER TABLE `students` AUTO_INCREMENT=1
http://developers.slashdot.org/story/11/07/09/1256241/Facebook-Trapped-In-My
SQL-a-Fate-Worse-Than-Death
"According to database pioneer Michael Stonebraker, Facebook is operating a
huge, complex MySQL implementation equivalent to 'a fate worse than death,'
and the only way out is 'bite the bullet
I sent this Friday, but it never made it to the list?!
-Original Message-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Friday, May 27, 2011 12:27 PM
To: mysql@lists.mysql.com
Subject: Using where; Using temporary; Using filesort
I'm trying to optimize a query that doesn&#
I'm trying to optimize a query that doesn't seem all that complicated,
however I can't seem to get it to not use a temp table and filesort.
developer@vm_vz_daevid:~$ mysql --version
mysql Ver 14.12 Distrib 5.0.92, for portbld-freebsd8.1 (amd64) using 5.2
EXPLAIN EXTENDED
SELECT
-- d.d
> -Original Message-
> On Tue, May 24, 2011 at 4:19 PM, Jerry Schwartz wrote:
>
> > It looks like there’s no way to rename a database. Is that true?
I know. Retarded right? Version 5.1.x and still what would seem the most basic
of tasks is still impossible.
Maybe Oracle can fix what M
Here’s an email from a good friend of mine that may be of interest. It is done
in Ruby.
From: Brad Robel-Forrest [mailto:b...@gigglewax.com]
Sent: Sunday, May 15, 2011 7:01 PM
To: Daevid Vincent
Subject: MySQL shell...with parameters
Remember a long while back I was bitching about the need
ade 4 pages for me.
Anyone know how to get more pages added?
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Friday, April 01, 2011 4:27 PM
To: mysql@lists.mysql.com
Subject: Any table visualization tools with wires connecting the actual
columns?
I am evaluating various tools for diagra
> -Original Message-
> From: Daniel Kraft [mailto:d...@domob.eu]
> Sent: Friday, April 22, 2011 12:37 PM
> To: mysql@lists.mysql.com
> Subject: WHERE does not work on calculated view field
>
> Hi all,
>
> I'm by no means a (My)SQL expert and just getting started working with
> VIEWs and
8:50 PM
> To: mysql@lists.mysql.com
> Subject: RE: Any table visualization tools with wires connecting the
actual
> columns?
>
> At 05:36 PM 4/7/2011, Daevid Vincent wrote:
> >I am a paid subscriber to SQLYog -- I love that tool, but AFAIK it
> >doesn't do diagrams (with wire
h it as well. But,
another
> tool worth exploring nonetheless.
>
> On Thu, Apr 7, 2011 at 2:17 PM, Daevid Vincent
> wrote:
>
> > Does anyone have any suggestions on this? I've written to SQL Maestro
> > twice and they've not replied either.
> >
> >
sday, April 07, 2011 1:36 PM
> To: mysql@lists.mysql.com
> Subject: Re: Any table visualization tools with wires connecting the
actual
> columns?
>
> At 02:17 PM 4/7/2011, Daevid Vincent wrote:
> >Does anyone have any suggestions on this? I've written to SQL Maestro
> >t
Does anyone have any suggestions on this? I've written to SQL Maestro twice
and they've not replied either.
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Friday, April 01, 2011 4:27 PM
To: mysql@lists.mysql.com
Subject: Any table visualization tools with wires connecting
I am evaluating various tools for diagram generating of existing databases
on some smaller databases (9 tables or so) first.
The two I've tried so far are these:
http://dev.mysql.com/downloads/workbench/
http://www.sqlmaestro.com/download/#mysql
Both _seem_ robust and cosmetically polished, but
There is almost no VM overhead these days. mySQL is disk I/O bound, not CPU
bound.
With VMWare you can setup your partitions to be raw disks (not virtual disk
files) so you get native I/O. If you were to get some SSD's, I bet you
would even see some significant performance increase too even over a
Absolutely true.
We have a master/slave pair and a secondary slave that is our 'live backup'
and we take offline every night to rsync the tarballs to tape backup too.
When it comes online, it syncs up with master. Rinse repeat. Works awesome
and seemless.
> -Original Message-
> From: Joã
http://www.mysqlperformanceblog.com/2007/03/13/to-uuid-or-not-to-uuid/
> -Original Message-
> From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
> Sent: Thursday, January 20, 2011 10:45 AM
> To: Anthony Pace
> Cc: mysql.
> Subject: Re: best way to have a unique key
>
> uuid(
Another option would be to mangle your insert statement with some other
language like PHP, Python, Ruby, etc. so that the inserts are MULTI inserts
instead. Something like:
INSERT INTO `T_DMU_History` (`DM_History_DM_ID`, `DM_History_Customer_ID`)
VALUES (13071, 299519),
VALUES (13071, 299520),
VA
n't require any restarts/reloads.
What have you changed in the my.cnf to solicit a restart?
Andy
From: ext Daevid Vincent [dae...@daevid.com]
Sent: 29 December 2010 20:25
To: 'mysql'
Subject: /etc/init.d/mysql start WITHOUT integrity check?
aster so that no data is written while we copy the snapshot to
the slave.
http://dev.mysql.com/doc/refman/5.0/en/replication-howto-existingdata.html
> Andy
>
>
> ________
> From: ext Daevid Vincent [dae...@daevid.com]
> Sent: 29 December 201
Is there a way to "/etc/init.d/mysql start" WITHOUT doing an integrity
check?
Can I pass in a command line parameter or set something in the my.cnf file?
Our DB is a Billion rows (with a "B") and that check can take HOURS.
All we want to do is restart the server to put another slave online bec
quot; from it?
> -Original Message-
> From: Ewen Fortune [mailto:ewen.fort...@gmail.com]
> Sent: Thursday, November 18, 2010 4:56 AM
> To: Daevid Vincent
> Cc: mysql
> Subject: Re: Does mysql cache strip out /* comments */ first?
>
> Daevid,
>
>
> > My conc
Like most developers, I have a wrapper that all of my SQL queries go
through in PHP.
We have a dedicated "NOC" screen that shows the "mytop" status of each
DEV/TEST/PROD master/slave pair.
http://daevid.com/content/examples/snippets.php (Automatic Monitoring of
remote servers)
We sometimes see s
ss jar" and YOU are the ONLY user on it. Even
then, YOUR account could be compromised too.
-Original Message-
From: Jan Steinman [mailto:j...@bytesmiths.com]
Sent: Saturday, November 13, 2010 1:33 PM
To: mysql@lists.mysql.com
Subject: RE: FW: [USN-1017-1] MySQL vulnerabilities
> Fr
2, 2010 12:18 PM
To: Daevid Vincent
Cc: mysql
Subject: Re: FW: [USN-1017-1] MySQL vulnerabilities
I suspect that that is because this is not a security list, but a general
help list. If you want those things, you'll get them from either your
vendor, bugtraq, or the mysql security-specific ma
How come these kinds of notices are not sent to the mysql list? I realize
this particular one is from Ubuntu, but the vulnerability is not ubuntu
specific, it's mysql. Why aren't the mysql, er um, Oracle people more
pro-active about letting us know these things?
-Original Message-
From: u
> -Original Message-
> From: Joeri De Backer [mailto:fons...@gmail.com]
> Sent: Tuesday, November 09, 2010 1:16 AM
> To: mysql
> Subject: Re: Order by "in" clause
>
> On Tue, Nov 9, 2010 at 10:09 AM, Mark Goodge
> wrote:
> > Hi,
> >
> > I have a query like this:
> >
> > select id, ti
> -Original Message-
> From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On
> Behalf Of Johan De Meersman
> Sent: Thursday, November 04, 2010 2:26 AM
> To: jcbo...@yahoo.com
> Cc: MySQL
> Subject: Re: Death of MySQL popularity?
>
> You may want to read that again, but with your glasses
> I guess it depends on how important your data is too. Quite
> a few of the SSDs on the market have been proven to not
> honour flush requests, so if the power goes out you've got
> corrupted data.
Uh. If you're not using a UPS battery backup then you deserve to loose your
data. And if you do
http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html#c11545
Note that if you are trying to keep your own database of cities and their
timezones, you can NOT use the mysql.time_zone_name.Time_zone_id as your FK
because the key will change the next time you get a new "tzdata" update
(like f
> -Original Message-
> From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au]
> Sent: Friday, October 15, 2010 5:54 PM
> To: MY SQL Mailing list
> Subject: Re: How do I GRANT SELECT to mysql.time_zone_name
> for ANYONE?!
>
> > Any user can get into mysql, it's what they can do after
> -Original Message-
> From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au]
> Sent: Friday, October 15, 2010 2:33 PM
> To: MY SQL Mailing list
> Subject: Re: How do I GRANT SELECT to mysql.time_zone_name
> for ANYONE?!
>
> Hi
>
>
> On 16/10/2010, at 1:47 AM, Suresh Kuna wrote:
>
>
I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for
the very specific mysql.time_zone_name table?? I don't want to GRANT it to
every individual user manually, I want one single GRANT that encompasses
every user simultaneously.
I've tried all of these, and they all are valid
I'm trying to figure out how to join the mysql.time_zone% tables and make
sense of this.
YES, I know how to "use" them with SET time_zone = timezone; and all that.
http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
That is NOT what I need them for (yet).
I have a list of airports and
We have a PSE05 "Master" and PSE06 "Slave" (PRODUCTION servers) both are
Ubuntu 32-bit.
We have a third slave PSE07 which is Ubuntu 64-bit. This is our 'live
backup' so to speak. We take mysqld down daily on there and tarball the
/var/lib/mysql and /var/log/mysql as snapshots (since mysqldump woul
Absolutely was just going to suggest this Travis.
Another option and this is untested, but is to use HAVING and an alias.
Something to this effect...
SELECT INET_NTOA(e.src_ip) AS source_ip
WHERE e.timestamp BETWEEN '2010-10-11 00:00:00' AND '2010-10-12 00:00:00'
HAVING source_ip BETWEEN '10.0.0.
You guys hear talk about NoSQL and here's a good article on the topic
especially as to how it pertains to mySQL...
http://www.linuxjournal.com/article/10770
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
...
http://www.ferdychristant.com/blog//archive/DOMM-84NEJN
_
From: Bryan Cantwell [mailto:bcantw...@firescope.com]
Sent: Saturday, October 02, 2010 5:18 AM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: RE: Any way to change timezone WITHOUT mysqld restart?
As a matter of fa
Did you even look at the manual?
http://lmgtfy.com/?q=mysql+set+timezone
First link.
> -Original Message-
> From: Bryan Cantwell [mailto:bcantw...@firescope.com]
> Sent: Friday, October 01, 2010 10:25 AM
> To: mysql@lists.mysql.com
> Subject: Any way to change tinezone WITHOUT mysqld
Easy.
SELECT DATE_FORMAT(`Time`, '%h:%i%p') as `Time_Format`
FROM `reservation`
ORDER BY `Time`
> -Original Message-
> From: BMBasal [mailto:bmb37...@gmail.com]
> Sent: Wednesday, September 29, 2010 3:50 PM
> To: 'Chris W'; 'MYSQL General List'
> Subject: RE: ORDER BY with field alias is
I gotta ask...
http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html#c11511
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Johnny Withers [mailto:joh...@pixelated.net]
> Sent: Wednesday, September 29, 2010 1:35 PM
> To: Daevid Vincent
> Cc: MySQL
> Subject: Re: How to get hanging 1:M table rows as single
> column in main query?
>
> GROUP_CONCAT() ?
>
> And group by id_fmr ?
>
> JW
>
&g
> -Original Message-
> From: Dan Nelson [mailto:dnel...@allantgroup.com]
> Sent: Wednesday, September 29, 2010 2:26 PM
> To: Daevid Vincent
> Cc: 'MySQL'
> Subject: Re: INSERT DELAYED and created_on timestamps
>
> In the last episode (Sep 29), Daevi
I'm doing some reading on INSERT DELAYED
http://dev.mysql.com/doc/refman/5.0/en/insert.html
I have a user_log table:
CREATE TABLE `user_log` (
`id_user_log` bigint(20) unsigned NOT NULL auto_increment,
`id_user` int(10) unsigned default '0',
`created_on` timestamp NOT NULL default CURRENT_T
Given three basic tables. An "fmr" table which has Field Maintenance
Reports, a Seat table and a "hanging" or "glue" table to map Seats to FMRs.
[See below]
How do I get all the Seats to be in a single "row" with the FMR data?
If I make this kind of query, they come in as separate rows:
SELECT
> -Original Message-
> From: Carlos Mennens [mailto:carlosw...@gmail.com]
> Sent: Tuesday, September 14, 2010 12:54 PM
> To: MySQL
> Subject: Re: Capitalize Input via Auto Complete?
>
> On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent
> wrote:
> > Get th
Get this tool: http://sqlyog.com/ it rocks.
There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
> -Original Message-
> From: Carlos Mennens [mailto:carlosw...@gmail.com]
> Sent: Tuesday, September 14, 2010 9:03 AM
> To: MySQL
> Subject: Capitalize Input via Auto C
> -Original Message-
> From: Kiss Dániel [mailto:n...@dinagon.com]
> Sent: Monday, September 13, 2010 5:59 AM
>
> Well, thanks, but I'm afraid using UUID's (even with hex
> compression) is
> kind of a suicide, when it comes to performance.
> This is a good summary about the issues:
> http
I am curious about something.
I have a "glue" or "hanging" table like so:
CREATE TABLE `fault_impact_has_fault_system_impact` (
`id_fault_impact` int(10) unsigned NOT NULL,
`id_fault_system_impact` smallint(5) unsigned NOT NULL,
KEY `fault_impact_key` (`id_fault_impact`,`id_fault_system_imp
> -Original Message-
> From: Julien Lory [mailto:julien.l...@gmail.com]
> Sent: Thursday, September 02, 2010 12:31 PM
> To: mysql@lists.mysql.com
> Subject: Symlinks not working when pointing to another table.
>
> Hello,
>
> I've done lot of researches and tests but can't find any
InnoDB is one of MANY engines in the RDBMS mySQL.
There IS in fact a few ways to store in temporary tables (both RAM and DISK
based)
http://dev.mysql.com/doc/refman/5.1/en/create-table.html
Look at:
TABLESPACE
PARTITIONS
ENGINE
> -Original Message-
> From: neutron [mailto:neutronsh..
Not sure what you're trying to do, but if all you want to do is toggle
between two things (as in row color zebra stripes or something) then I
would suggest you not use some MOD() routine and instead just flip a
boolean.
For example in PHP just do:
just sayin'.
> -Original Message
:) Ala
http://www.geek.com/articles/news/disgruntled-employee-kills-journalspace-w
ith-data-wipe-2009015/
> -Original Message-
> From: nunziodav...@yahoo.com [mailto:nunziodav...@yahoo.com]
> Sent: Friday, August 27, 2010 5:01 PM
> To: Daevid Vincent
> Subject: Re: Cr
ssh to the slave
mysql -uroot -pPASSWORD -P3306 -hlocalhost
show slave status\G
If the Slave IO is NOT Running, but SQL is, then simply try to restart the
slave...
*** 1. row ***
Slave_IO_State:
Master_Host: 10.10.10.45
While not elegant, you could setup multiple instances of mysql on different
ports on the same box so each instance is a slave to a different master.
>From your web GUI, this is transparent to the end user since your
configuration files and DB wrappers would handle the connections to "4".
We do so
> -Original Message-
> From: Rob Wultsch [mailto:wult...@gmail.com]
> Sent: Thursday, August 05, 2010 6:05 PM
> To: Daevid Vincent
> Cc: MySQL List
> Subject: Re: Possible tricks to ALTER on huge tables?
>
> Having significant amount of overhead for unused colu
Driving to work today, I had an epiphany thought, but wanted to see if
anyone could prove my theory or not.
We currently have some tables that are approaching 1 BILLION rows (real
Billion, with nine zeros, not that silly six zero version). Trying to do an
"ALTER" on them to add a column can someti
ut of it's way to be different
than the standard SQL logic.
> -Original Message-----
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Monday, August 02, 2010 12:35 PM
> To: 'MySQL List'
> Subject: There is something wrong with bugs.mysql.com email
>
witch to ignore temporary
tables
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at
http://bugs.mysql.com/?id=42774&edit=2
Comment by: Bugs System
Reported by: Daevid Vincent
Category: Client
Severity: S4 (Featu
> -Original Message-
> From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On
> Behalf Of Johan De Meersman
> Sent: Friday, July 16, 2010 7:41 AM
> To: MySQL List
> Subject: Re: [ANN] PBXT 1.5.02 Beta Released!
>
> Can I somehow unsubscribe (that is opt-out , as opposed to the more
>
> -Original Message-
> From: Jay Blanchard [mailto:jblanch...@pocket.com]
> Sent: Friday, July 16, 2010 5:25 AM
> To: Michael Dykman; mysql
> Subject: RE: Why is MySQL always linked to Php?
>
> [snip]
> PHP applications are, for the most part, not that ambitious
> and mysql is simply the
> -Original Message-
> From: alba.albetti [mailto:alba.albe...@libero.it]
> Sent: Thursday, July 15, 2010 7:00 AM
> To: mysql
> Subject: Why is MySQL always linked to Php?
>
> Browsing the Web I've seen that usually companies look for
> developers working on MySQL and Php. Why are the
om [mailto:vegiv...@gmail.com] On
> Behalf Of Johan De Meersman
> Sent: Tuesday, July 13, 2010 1:17 AM
> To: Daevid Vincent
> Cc: Machiel Richards; mysql@lists.mysql.com
> Subject: Re: finding exact query being run
>
> Which will still not be particularly helpful for subsecond que
get "mytop"
_
From: Machiel Richards [mailto:machi...@rdc.co.za]
Sent: Monday, July 12, 2010 8:40 AM
To: mysql@lists.mysql.com
Subject: finding exact query being run
Hi All
I am trying to find out how to see the exact query being
run.
When runn
> -Original Message-
> From: Don Cohen [mailto:don-mysq...@isis.cs3-inc.com]
> Sent: Wednesday, June 16, 2010 2:48 PM
> To: Daevid Vincent
> Cc: mysql@lists.mysql.com
> Subject: RE: opening a server to generalized queries but not "too" far
>
> Daev
> -Original Message-
> From: Don Cohen [mailto:don-mysq...@isis.cs3-inc.com]
>
> The http request I have in mind will be something like
> https://server.foo.com?user=john&password=wxyz&;...
> and the resulting query something like
> select ... from table where user=john and ...
> (I w
Easy enough to rectify
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
ALTER TABLE `tbl_xyz` ADD COLUMN `updated_on` TIMESTAMP NOT NULL DEFAULT
CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `prod_id`;
Personally I put a 'created_on' and an 'updated_on' column for mostly every
t
The only way I could think of is to have a column that's an auto updated
timestamp and then just query using that time.
`updated_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP
So for your mass update, I'd SET @updated_time = NOW(); and then you could
use that in your
1 - 100 of 473 matches
Mail list logo
