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
, Nov 21, 2013 at 4:44 PM, Daevid Vincent dae...@daevid.com wrote:
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
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
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]
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
-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 databases and hundreds of tables
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, June 12, 2013 9:39 AM
To: Daevid Vincent; mysql@lists.mysql.com
Cc
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: RE: How do I select all rows
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 to be
-Original Message-
From: shawn green [mailto:shawn.l.gr...@oracle.com]
Sent: Tuesday, June 11, 2013 2:16 PM
To: mysql@lists.mysql.com
Subject: Re: How do I select all rows of table that have some rows in
another table (AND, not OR)
Hello Daevid,
On 6/11/2013 3:59 PM, Daevid
http://adtmag.com/articles/2013/02/06/mysql-update.aspx
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
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 at a thousand rows
at a time
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 replace KEY `customers_id`
(`customer_id`).
Maybe
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
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 programmatically useable map of country
ISO
codes to demonyms?
http://www.geography-site.co.uk/pages
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
-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
...@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 it out. Is there a better
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` (
-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 are
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.
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
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
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
-
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 with it for a
full
day now but I
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, October 24, 2011 4:06 PM
-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 running
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
To:
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`
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'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
--
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't seem
-Original Message-
On Tue, May 24, 2011 at 4:19 PM, Jerry Schwartz je...@gii.co.jp 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
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
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 diagram generating
-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 stored
@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 wires between tables and all that glory). Am
I wrong
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 the actual
: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
twice and they've not replied either.
Take a look
, Apr 7, 2011 at 2:17 PM, Daevid Vincent dae...@daevid.com
wrote:
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
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
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ão
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),
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 2010 20:25
To: 'mysql'
Subject: /etc/init.d/mysql start WITHOUT integrity check
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?
Is there a way to /etc/init.d/mysql start WITHOUT doing
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
: 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,
snip
My concern is, my gut tells me that the built in mysql
cache system is
dumb. And by that I
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
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
From: Daevid Vincent dae...@daevid.com
my point exactly
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:
: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 mailing list
-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
m...@good-stuff.co.uk wrote:
Hi,
I have a query like this:
select id,
-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 on :-)
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 don't
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
-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:
Hey
-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 that's
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
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 would
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
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
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:
, 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 fact I did, the real question is : Did you even read my
email? I said WITHOUT a restart...
The manual states that a restart of the mysqld is required
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
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
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
-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), Daevid Vincent said:
I'm doing some reading
[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
On Wed, Sep 29, 2010 at 2:38 PM, Daevid Vincent
dae
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
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 issue
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
-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
dae...@daevid.com wrote:
Get this tool: http://sqlyog.com
-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:
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`
-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
answer.
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
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:
tr class=?= ($r == !r) ? 'light' :
/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: Creating a dedicated reporting server for management?
Thanks
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:
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
-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 columns will without
doubt harm
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
temporary
tables
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at
http://bugs.mysql.com/?id=42774edit=2
Comment by: Bugs System
Reported by: Daevid Vincent
Category: Client
Severity: S4 (Feature request)
Status
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
server I think.
I don't know if anyone from mysql
-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 most
-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: 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 two
...@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 queries :-)
Either turn on the full query log
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
-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=johnpassword=wxyz;...
and the resulting query something like
select ... from table where user=john and ...
(I will first
-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
Daevid Vincent writes:
For the love of God
AFAIK, the number in parenthesis is ONLY for display purposes in formatting
the size of the column in mySQL command line output, NOT the size of the
data that can be held.
I think they use (11) because unsigned will need one extra character for
the minus sign.
INT SIGNED = -2147483648 to
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
1 - 100 of 386 matches
Mail list logo