Three solutions, the first one is not recommended I just showed it for
fun -- I think the last one is the most efficient:
mysql> show create table job \G
*** 1. row ***
Table: job
Create Table: CREATE TABLE `job` (
`job_id` int(10) unsigned
;ll be
able to reduce space effectively by dropping tables.
Regards,
Gavin Towey
Message-ID: <69069d7d0905140247w29e73f81pb394981fd9193...@mail.gmail.com>
--0016e6476110ee6f5e0469dc372e
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Hi.
I want
gards,
Gavin Towey
I have a bit of perl code that ends with an error:
$sql="SELECT convert_tz( a.stamp,'GMT','$tz' ) as ts, a.status,
a.reason, a.tl
INTO OUTFILE '/application/result.csv'
FIELDS TERMINATED BY ','
A MAC address is just a number, it doesn't contain letters unless you're doing
something silly like storing the HEX representation of it. Do not use CHAR!
This does DOUBLE for all of you storing IP addresses!
Since a MAC address is going to be between 48 and 64 bits, then BIGINT is
appropria
"I've run up on the rock of a binary (meaning: indecipherable) field."
SELECT hex(some_binary_field) FROM table;
Solved.
The information contained in this transmission may contain privileged and
confidential information. It is intended only for the use of
Hi Niel,
What version is the mysql dump from? Are you importing to a different version?
Could you show the line from the file that is generating the error?
Regards,
Gavin Towey
-Original Message-
From: Neil Aggarwal [mailto:n...@jammconsulting.com]
Sent: Tuesday, May 19, 2009 6:56 AM
m your app, does
not mean you must use LOAD DATA INFILE to get the data into MySQL.
Regards,
Gavin Towey
-Original Message-
From: alex.ksi...@gmail.com [mailto:alex.ksi...@gmail.com] On Behalf Of Alex K
Sent: Tuesday, May 19, 2009 5:43 AM
To: MySQL General List
Subject: Re: load data into
Interesting. This syntax is only supposed to be available as of 5.4, but it
doesn't even work there. The reference I found was at :
http://dev.mysql.com/tech-resources/articles/mysql-54.html
But I couldn't find other references to the new signal support.
This is listed as the example on that p
Please note that this is *NOT* a way to "get them synched again"
In fact if you have to skip a replication statement on the slave then it is
usually a sign your slave has different data than you master already. Skipping
statements/errors may keep replication running, but you're just masking
pr
A LEFT OUTER JOIN in that query in not necessary. An inner join should be used.
-Original Message-
From: Shiv [mailto:shiv...@gmail.com]
Sent: Saturday, May 30, 2009 10:18 PM
To: bharani kumar
Cc: mysql
Subject: Re: Left join query
Hi,
Along with tables, you should also provide detail
he Code snippet from your script.
Regards,
Gavin Towey
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, June 03, 2009 7:26 AM
To: [MySQL]
Subject: mysql 5.0.67
Hi
I'm using version 5.0.67 and have a strange problem. I have a text field
an
That's impossible to say with the limited information you've provided; however,
try this script for some basic tuning suggestions. It should make sure you're
not doing anything crazy:
https://launchpad.net/mysql-tuning-primer
Regards,
Gavin Towey
-Original Message--
Something like:
SET @version = "6.0";
SELECT CASE direction WHEN '>' THEN IF( @version > version, 'Y', 'N') WHEN '<'
THEN IF (@version < version, 'Y','N) ... END AS operation FROM test;
-Original Message-
From: Matt Neimeyer [mailto:m...@neimeyer.org]
Sent: Wednesday, July 08, 2009 2:45
from mysql again. You can test it though -- write a
script, time a bunch of iterations and prove to yourself if it's a good idea or
not.
Generally the way to optimize reading xml faster is to not do it.
IMO if you want caching then use something that was meant for it like memcached.
Rega
Or you could just do an export with
mysqldump --single-transaction > backup.sql
Then replace all the ENGINE=InnoDB with ENGINE=MyIsam in the .sql file.
-Original Message-
From: mos [mailto:mo...@fastmail.fm]
Sent: Wednesday, July 15, 2009 11:58 AM
To: mysql@lists.mysql.com
Subject: Re: An
/projects/mysql/groupwise-max
Otherwise, for better help:
1) Show us the exact query you are doing, and the structure of the tables.
2) Show a small sample data set if possible
3) Show what the result set you want would look like.
Regards,
Gavin Towey
-Original Message-
From: PJ [mailto:af.gour.
The binlogs are closed and reopened every time you do a FLUSH LOGS; command, or
when the server restarts. Is your server crashing continuously? Take a look
at your error log as well.
Regards,
Gavin Towey
-Original Message-
From: Gary Smith [mailto:g...@primeexalia.com]
Sent: Thursday
Please echo the query and show the actual result. We have no way to know what
your program puts in your variables. The problem is often a that a programming
error causes the code to construct a query that's different from what you
assume.
Regards,
Gavin Towey
-Original Message-
I think I see it anyway:
ORDER BY tile DESC, sub_title ASC
Each item in the list fields takes ASC/DESC individually. Your statement would
only change the sort order on the second column, not both.
-Original Message-
From: PJ [mailto:af.gour...@videotron.ca]
Sent: Friday, July 17, 200
You might have better luck on the mysql-internals list
-Original Message-
From: Rajarshi Chowdhury [mailto:mailtorajar...@gmail.com]
Sent: Tuesday, July 21, 2009 4:58 AM
To: mysql@lists.mysql.com
Subject: Query_cache instance creation
Hi,
MySQL query cache implementation is based on the
your stock table.
Regards,
Gavin Towey
-Original Message-
From: hezjing [mailto:hezj...@gmail.com]
Sent: Friday, July 24, 2009 10:27 AM
To: mysql@lists.mysql.com
Subject: Selecting from the range of serial numbers
Hi
My stock serial number format is 1A - 9A, 1B - 9B
Should be more efficient to do something like:
SELECT Main_ID FROM Table1 WHERE Source1_Name = 'name'
UNION
SELECT Main_ID FROM Table2 WHERE Source2_Name = 'name'
UNION
SELECT Main_ID FROM Table3 WHERE Source3_Name = 'name'
-Original Message-
From: João Cândido de Souza Neto [mailto:j.
Nope
-Original Message-
From: Jeff Lanzarotta [mailto:delux256-my...@yahoo.com]
Sent: Tuesday, July 28, 2009 11:37 AM
To: mysql@lists.mysql.com
Subject: User Defined Types
Hello,
I am evaluating MySQL. I am coming from Microsoft SQL Server 2005.
This may have been discussed before but I
Hi Bryan,
Please define "out of whack." Tell us exactly what you're doing when you
restart, and what the replication state is before and after, and where the
updates are coming from.
Regards,
Gavin Towey
-Original Message-
From: Cantwell, Bryan [mailto:bcantw...@fire
impossible position." In this
case you do have to intervene, but that's an easy enough case to write a script
to handle.
When restarting mysql normally, you shouldn't have this problem: i.e. service
mysql restart / /etc/ini.d/mysql restart
Regards,
Gavin Towey
-Original Me
Entries in the slow log have a timestamp. You can read the file directly, but
it's much easier to use a tool like maatkit for parsing the results of the log.
Try this:
http://www.maatkit.org/doc/mk-query-digest.html
Regards,
Gavin Towey
-Original Message-
From: Milan A
Bryan,
When the slave encounters that error, you can simply set it to replicate from
the next binlog file in the sequence starting at position 98. It should be
easy to have a script automate this process.
Regards,
Gavin Towey
-Original Message-
From: Cantwell, Bryan [mailto:bcantw
ginning of
the string, and the results will include all subdomains for the given domain
you're looking for.
Regards,
Gavin Towey
-Original Message-
From: Alexander Kolesen [mailto:kolese...@mail.by]
Sent: Saturday, August 01, 2009 11:10 AM
To: mysql@lists.mysql.com
Subject: Re: Table
not_Connect
If you continue to have problems, give us the exact steps you have tried and
the exact error message you are receiving. Please try to connect using the
mysql command line.
Regards,
Gavin Towey
-Original Message-
From: Hugo Leonardo Ferrer Rebello [mailto:hugo.rebe...@t-
using GigE over few hops, then
it's really not slower than local disks.
Remember: benchmark and test your assumptions!
Regards,
Gavin Towey
-Original Message-
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: Friday, August 07, 2009 1:19 AM
To: Peter Chacko
Cc: mysql
Subjec
ing-primer
Regards,
Gavin Towey
-Original Message-
From: Banyan He [mailto:ban...@rootong.com]
Sent: Friday, August 07, 2009 11:12 AM
To: Gavin Towey; joerg.bru...@sun.com; Peter Chacko
Cc: mysql
Subject: Re: Question about MySQL
Hi Gavin,
I am interested in the things you made for the optimiz
Andrew,
Yes it's true, because when you specify localhost, you're using the local
socket file. The port only has meaning for TCP connections.
Regards,
Gavin Towey
-Original Message-
From: Andrew Braithwaite [mailto:andrew.braithwa...@lovefilm.com]
Sent: Tuesday, August 11,
Have you tried removing the quotes from around the value in:
user_id='1421767810'
The column is defined as bigint. You're comparing it to a string. I just saw
a case where comparing a float value to a string column in a query caused it to
take a long time.
-Original Message-
From: Da
f you get consistent times? What about running this directly through
the mysql cli?
Regards,
Gavin Towey
-Original Message-
From: Leo Siefert [mailto:lsief...@sbcglobal.net]
Sent: Thursday, August 13, 2009 1:10 PM
To: mysql@lists.mysql.com
Subject: Erratic query performance
I have a mod
Run:
SHOW ENGINE INNODB STATUS \G
And look for the "LATEST FOREIGN KEY ERROR" section. It'll explain the reason
for the (errno: 150) message.
Regards,
Gavin Towey
-Original Message-
From: wabiko.takuma [mailto:wab...@sysrdc.ns-sol.co.jp]
Sent: Friday, August 14, 2009 3:
Hi Matt,
You need to worry about consistent collations if you want consistent behavior
for sorting and comparing fields. That sounds pretty important to me.
Note that latin1 can hold accented characters as well.
Regards,
Gavin Towey
-Original Message-
From: Matt Neimeyer [mailto:m
To further emphasize this point: A table has no order by itself, and you
should make no assumptions about the order of rows you will get back in a
select statement, unless you use an ORDER BY clause.
Regards,
Gavin Towey
-Original Message-
From: walterh...@gmail.com [mailto:walterh
grams that manipulate it.
In all honesty, if this really is a "personal" application, you may be better
off using another, simpler method.
Regards,
Gavin Towey
-Original Message-
From: news [mailto:n...@ger.gmane.org] On Behalf Of Pol
Sent: Wednesday, August 19, 2009 2:38 AM
To: m
RENAME statement is atomic, and you can specify multiple tables to rename at
once.
Instead of two statements, do this:
rename table send_sms to send_sms_full, send_sms_empty to
send_sms;
There will be no "gap" in-between.
-Original Message-
From: Jerry Schwartz [mailto:jschwa...@the-inf
Have you looked at MySQL cluster? It was created specifically for telco needs.
-Original Message-
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: Friday, August 21, 2009 9:23 PM
To: wha...@bfs.de
Cc: MySQL
Subject: Re: Scaling Mysql
Hi wharms,
Yor are right. It's s
AND r.prov=c.prov AND
r.cap=c.cap AND r.CodRappr=c.CodRappr;
Regards,
Gavin Towey
-Original Message-
From: Deviad [mailto:dev...@msn.com]
Sent: Monday, August 24, 2009 6:27 PM
To: mysql@lists.mysql.com
Subject: Re: Natural Join Issue: column names are equal but doesn't work anyway
Which version of mysql are you using? In mysql 4, you could get away with some
differences between the definition of the merge table and the underlying tables.
As you've discovered, the structure and index definitions must now be exactly
the same, otherwise you will get errors.
Regards,
Isn't that basically the same as pointing phpmyadmin at a read-only copy of the
data?
There's a reason most searches are limited; when you most people too many
options, it's confusing. Good interfaces hide complexity from the end user.
-Original Message-
From: Jerry Schwartz [mailto:j
Do you know that if you create seq column on the original table as an
auto_increment primary key, it will fill in the numbers automatically? There's
no need to create the values on another table and update with a join.
Regards,
Gavin Towey
-Original Message-
From: Hank [mailt
, you should look at how much code is already hidden from you in those few
functions! =P
Regards,
Gavin Towey
-Original Message-
From: Brent Baisley [mailto:brentt...@gmail.com]
Sent: Friday, September 04, 2009 6:21 AM
To: AndrewJames
Cc: mysql@lists.mysql.com
Subject: Re: a better way, code
Mysql doesn't store sub-second values.
try
2008-03-09 02:56:34
Instead of
2008-03-09 02:56:34.737
Regards,
Gavin Towey
-Original Message-
From: Proemial [mailto:proem...@gmail.com]
Sent: Friday, September 04, 2009 8:37 AM
To: John Daisley
Cc: mysql@lists.mysql.com
Subject: Re: Fwd:
You can add a LIMIT n to your update clause.
Regards,
Gavin Towey
-Original Message-
From: Allen Fowler [mailto:allen.fow...@yahoo.com]
Sent: Monday, September 07, 2009 5:18 PM
To: mysql@lists.mysql.com
Subject: Queue / FIFO in MySQL?
Hello,
I need to create a system where records are
the data directory 3. Store a copy of your my.ini with the
backup as well. 4. Restart mysql
Regards,
Gavin Towey
-Original Message-
From: Néstor [mailto:rot...@gmail.com]
Sent: Thursday, September 10, 2009 11:28 AM
To: mysql@lists.mysql.com
Subject: DB/table problem
I am running mysql
No, the .frm files don't contain data. They are only the table structure. You
should always test your backup and restore procedure nefore you need to use it.
Regards,
Gavin Towey
From: Néstor [mailto:rot...@gmail.com]
Sent: Thursday, September 10, 2009 4:35 PM
To: Gavin Towey
Cc:
nes.
Regards,
Gavin Towey
-Original Message-
From: tly...@sitehelp.org [mailto:tly...@sitehelp.org] On Behalf Of Todd Lyons
Sent: Thursday, September 10, 2009 3:44 PM
To: Gavin Towey
Cc: mysql@lists.mysql.com
Subject: Re: DB/table problem
On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey wrote:
Hi Tim,
Try using LOAD DATA INFILE from the mysql CLI. PMA can often introduce
unexpected behavior for export/import.
Regards,
Gavin Towey
-Original Message-
From: Tim Thorburn [mailto:webmas...@athydro.com]
Sent: Wednesday, September 16, 2009 7:14 AM
To: mysql@lists.mysql.com
Subject
weet_date < NOW()-INTERVAL 7 DAY; ?
Regards,
Gavin Towey
-Original Message-
From: John Meyer [mailto:johnme...@pueblocomputing.com]
Sent: Wednesday, September 16, 2009 12:52 PM
To: mysql@lists.mysql.com
Subject: Datediff function
I'm trying to pull up a list of users who haven't tw
Hi John,
You can turn of name resolution by adding skip-name-resolve to the [mysqld]
section of your my.cnf file.
Regards,
Gavin Towey
-Original Message-
From: John Oliver [mailto:joli...@john-oliver.net]
Sent: Wednesday, September 16, 2009 4:24 PM
To: mysql@lists.mysql.com
Subject
n it's probably not worth it, though I was
making the assumption you're probably going to be using that query frequently.
Regards,
Gavin Towey
-Original Message-
From: John Meyer [mailto:johnme...@pueblocomputing.com]
Sent: Wednesday, September 16, 2009 4:51 PM
To: Gavin Towey
Edit your /etc/my.cnf file and remove the option.
Regards,
Gavin Towey
-Original Message-
From: Manoj Burande [mailto:manoj.bura...@artificialmachines.com]
Sent: Friday, September 18, 2009 7:17 AM
To: mysql@lists.mysql.com
Subject: [ERROR] /usr/sbin/mysqld: unknown option '--ndbcl
.
Regards,
Gavin Towey
-Original Message-
From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com]
Sent: Monday, September 21, 2009 2:29 PM
To: 'Mike Spreitzer'
Cc: 'Michael Dykman'; mysql@lists.mysql.com
Subject: RE: incremental name search?
Beyond being leery of
you're not looking for NULL rows or anything. In fact, it looks like
mysql is smart enough to know that you've negated the OUTER JOIN by putting
conditions on the joined tables in the WHERE clause, and convert then to INNER
JOINS. Don't rely on that! Use the correct join type
Commonly refered to as a "groupwise max"
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
http://jan.kneschke.de/projects/mysql/groupwise-max/
Regards,
Gavin Towey
-Original Message-
From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com]
Se
ey were designed to scale well.
Regards,
Gavin Towey
-Original Message-
From: Tim Gustafson [mailto:t...@soe.ucsc.edu]
Sent: Friday, September 25, 2009 2:44 PM
To: mysql@lists.mysql.com
Subject: Re: Master/Slave Replication Question
> Another thought would be at the application laye
re and techniques. They're like
building blocks, and you can put them together however you want. I find this
much more preferable to the all-in-one black-box solution.
Regards,
Gavin Towey
-Original Message-
From: Tim Gustafson [mailto:t...@soe.ucsc.edu]
Sent: Friday, September
nsert statement for each
line. It may be incorrectly handling some of that data. Using the CLI you'll
get better feedback about what, if any, the error is.
Regards,
Gavin Towey
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: Saturday, September 2
know the exact steps you need to take, and how much time it takes, then you can
plan the upgrade accordingly on your live system.
Regards,
Gavin Towey
-Original Message-
From: monem mysql [mailto:monem.my...@gmail.com]
Sent: Thursday, October 01, 2009 9:31 AM
To: mysql@lists.mysql.com
. Give the exact error message
3. If there's no error, explain what you expect and what you're getting
4. Include table schema
5. Explain what you're trying to accomplish.
Regards,
Gavin Towey
-Original Message-
From: Victor Subervi [mailto:victorsube...@gmail.com]
S
s/articles/mysql-db-design-ch5.pdf
http://dev.mysql.com/doc/refman/5.1/en/join.html
Regards,
Gavin Towey
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: Thursday, October 01, 2009 2:25 PM
To: Gavin Towey; mysql@lists.mysql.com
Subject: Re: Nested Joins
On Thu, Oct 1, 2009 at 4:03
g the query you're building to a string, then printing it out so you
know *exactly* what you're sending to mysql.
Regards,
Gavin Towey
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: Thursday, October 01, 2009 3:04 PM
To: Gavin Towey; mysql@lists.mysql.com
Subject: Re: Nested Jo
Mysql -vv
See mysql --help for more info
Regards,
Gavin Towey
-Original Message-
From: lucas.ctr.heu...@faa.gov [mailto:lucas.ctr.heu...@faa.gov]
Sent: Friday, October 02, 2009 2:20 PM
To: mysql@lists.mysql.com
Subject: The Execute from the command line
I am using
linuxmachine:/var
elf.
I see no reason why those versions should have a problem interacting; what are
you trying, and what is the error you get?
Regards
Gavin Towey
-Original Message-
From: Hagen [mailto:finha...@comcast.net]
Sent: Monday, October 05, 2009 11:58 AM
To: mysql@lists.mysql.com
Cc: finha...@comcas
See
log-queries-not-using-indexes
option in my.cnf, used with the slow log.
http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
Regards,
Gavin Towey
-Original Message-
From: Brown, Charles [mailto:cbr...@bmi.com]
Sent: Monday, October 05, 2009 12:59 PM
To: Mysql List
Cc: John
t.so
in the output. If not you may have to find it and make sure ldconfig knows
about it.
You should also be able to use ldd to check shared lib dependencies.
Regards,
Gavin Towey
-Original Message-
From: Hagen Finley [mailto:finha...@comcast.net]
Sent: Monday, October 05, 2009 1:
Hi Scott,
Change socket = in the [client] section of your my.cnf as well.
Regards
Gavin Towey
-Original Message-
From: Scott Wagner [mailto:gildedp...@comcast.net]
Sent: Monday, October 05, 2009 3:21 PM
To: mysql@lists.mysql.com
Subject: mysql.socket location problem
Hi
I just did a
In the case that one machine has a power failure, then starts a new binlog, you
just have to set the slave to start replicating from the beginning of that
binlog. That's easy to detect and repair with a daemon script. Even if both
machines die, it'll be a similar scenario.
Rega
B should be the only one with a bad replication position, since it was
replicating when A crashed. So just adjust B, and A should catch up as normal
(provided you have the last 24 hours of binlogs on B for A to read )
Regards,
Gavin Towey
-Original Message-
From: Bryan Cantwell
Try the tutorial:
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
Regards,
Gavin Towey
-Original Message-
From: John Oliver [mailto:joli...@john-oliver.net]
Sent: Thursday, October 08, 2009 2:19 PM
To: mysql@lists.mysql.com
Subject: Some MySQL questions
1) When I select * from
/en/Slow_query_log.html
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
Regards,
Gavin Towey
-Original Message-
From: jeetendra.ran...@sampatti.com [mailto:jeetendra.ran...@sampatti.com]
Sent: Wednesday, October 14, 2009 3:21 AM
To: mysql@lists.mysql.com
Subject: Req. suitable
; $(4,$&1'
Another thing to think about is storing image data directly in a database is
often not a good idea. See these links for more info:
http://mysqldump.azundris.com/archives/36-Serving-Images-From-A-Database.html
and http://hashmysql.org/index.php?title=Storing_files_in_the_d
u add more
records.
Regards,
Gavin Towey
-Original Message-
From: Ray [mailto:r...@stilltech.net]
Sent: Friday, October 16, 2009 8:43 AM
To: mysql@lists.mysql.com
Subject: insert random number into table
Hello All,
I am trying to insert a unique random number* with each row when insert
See:
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
-Original Message-
From: Tharanga Abeyseela [mailto:tharanga.abeyse...@gmail.com]
Sent: Wednesday, October 21, 2009 2:34 PM
To: mysql@lists.mysql.com
Subject: Mysql Upgrade from version 4 to 5
Hi Guys,
Iam going to upgrade mysql ve
Do you have a program called mysql_install_db? It looks like you need that to
create the initial mysql system database in your data directory.
Regards,
Gavin Towey
-Original Message-
From: Matthew Laurence [mailto:mattlaure...@gmail.com]
Sent: Thursday, October 22, 2009 10:24 AM
To
EGIN/END and DELIMITER are not needed for single statement triggers
2. However you still can't do that. You can't update the table used in the
trigger. What you really want is either a separate cron process, or a mysql
event (if using 5.1)
Regards
Gavin Towey
-Original Message
Oops, one more mistake:
NOW()-60*60*24*5 isn't the way to do date math. It should be: NOW() - INTERVAL
5 DAY
-Original Message-
From: Gavin Towey
Sent: Wednesday, November 04, 2009 2:33 PM
To: 'Phil'; Mysql; 'Stefan Onken'
Subject: RE: trigger
1. Trigge
e you a list of paths it checks in order.
Regards,
Gavin Towey
-Original Message-
From: John Daisley [mailto:john.dais...@butterflysystems.co.uk]
Sent: Thursday, November 12, 2009 10:30 AM
To: Sydney Puente
Cc: mysql@lists.mysql.com
Subject: Re: cannot find my.cnf file
should be in
/etc
27;re using to
try to log in, and the exact error message you get.
Regards
Gavin Towey
-Original Message-
From: Sydney Puente [mailto:sydneypue...@yahoo.com]
Sent: Friday, November 13, 2009 5:31 AM
To: mysql@lists.mysql.com
Subject: Re: cannot find my.cnf file
Yes I enter the password man
ame != 'dopey' where
Table_1.username != 'dopey';
Regards,
Gavin Towey
-Original Message-
From: Ashley M. Kirchner [mailto:kira...@gmail.com]
Sent: Sunday, November 15, 2009 4:38 AM
To: mysql@lists.mysql.com
Subject: Selecting data from multiple tables
Hi folks,
I'
your data, shutdown mysql, change you're my.cnf &
delete the tablespace & ib_log files, then restart and re-import all your data.
If you need to do this, you should probably seek a bit more information about
from this list or other sources.
Regards,
Gavin Towey
-Original Mes
Hi Krishna,
Drop partition should be very quick - much faster than doing a DELETE on the
same amount of data. Internally, it will be the same as doing a drop table for
that partition.
Regards,
Gavin Towey
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: Thursday, November
Have you tried dumping that table manually using mysqldump on the command line
to confirm it's not an issue with automysqlbackup?
Regards,
Gavin Towey
-Original Message-
From: René Fournier [mailto:m...@renefournier.com]
Sent: Friday, November 20, 2009 8:31 AM
To: mysql
Subject: St
,
Gavin Towey
-Original Message-
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: Sunday, November 22, 2009 10:56 AM
To: mysql@lists.mysql.com
Subject: Creating Table Through Union
Hi;
I would like to create a table out of merging the fields in other,
previously created tables. I
ween servers, and can fix them with queries.
No stopping the slave or locking the master necessary. I've used them in
production with good results.
Regards,
Gavin Towey
-Original Message-
From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
Sent: Friday, December 04, 2009
---Original Message-
From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
Sent: Friday, December 04, 2009 1:24 PM
To: Gavin Towey; Tom Worster; mysql@lists.mysql.com
Subject: RE: Here's an Idea for Re-Syncing Master and Slave During Production
Hours without Interrupting Users (Much)
> I
Access Denied means you're using an incorrect username and password
combination. Test your credentials using the mysql cli. You can log in as
root to mysql to make changes as necessary, or supply the correct user/pass
from your script.
Regards,
Gavin Towey
-Original Message-
Creating a temporary merge table works fine for me on 5.0.
Your table isn't innodb is it? That will fail with an error like you're
getting.
Regards,
Gavin Towey
-Original Message-
From: Dante Lorenso [mailto:da...@lorenso.com]
Sent: Thursday, December 10, 2009 3:20 PM
Mysql daemon runs as the 'mysql' user
Chown -r mysql:mysql /storage/mysql/data
Regards,
Gavin Towey
-Original Message-
From: Carl [mailto:c...@etrak-plus.com]
Sent: Friday, December 11, 2009 11:55 AM
To: mysql@lists.mysql.com
Subject: errno: 13
Fresh install of 5.1.41 on a
Don't forget triggers, stored routines, views, database/table specific user
permissions, and replication/binlog options!
Regards,
Gavin Towey
-Original Message-
From: Saravanan [mailto:suzuki_b...@yahoo.com]
Sent: Friday, December 11, 2009 2:02 PM
To: MySql; Michael Dykman
Subjec
om/doc/refman/5.0/en/explain.html
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
About normalization:
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
Regards,
Gavin Towey
-Original Message-
From: Sudhir N [mailto:sudhir_nima...@yahoo.com]
Sent: Monda
Hi Miguel,
You'll need to use LEFT JOIN, that will show all records that match and a row
in the second table will all values NULL where there is no match. Then you
find all those rows that have no match in your WHERE clause.
Regards,
Gavin Towey
-Original Message-
From: Migue
You need to use
DELIMITER //
Or some other symbol besides ; to change the client's end-of-statement symbol.
Otherwise it ends the statement at the first ; inside the procedure you use,
but it's not yet complete.
This is described in the manual on that same page.
Regards
G
ng
as it takes for you to scp the database from one machine to another.
Regards,
Gavin Towey
-Original Message-
From: Madison Kelly [mailto:li...@alteeve.com]
Sent: Wednesday, December 16, 2009 12:56 PM
To: mysql@lists.mysql.com
Subject: Importing large databases faster
Hi all,
I&
')
);
select id, astext(coordinates), Distance(@center,line_segment) as dist
FROM places where MBRContains(@bbox, line_segment) order by dist limit 10;
Regards,
Gavin Towey
-Original Message-
From: René Fournier [mailto:m...@renefournier.com]
Sent: Wednesday, December 16, 2009 4:32 PM
To:
I don't think so, I'm pretty sure you have to use mk-parallel-dump to get the
data in a format it wants. The docs are online though.
Regards,
Gavin Towey
-Original Message-
From: Madison Kelly [mailto:li...@alteeve.com]
Sent: Wednesday, December 16, 2009 4:35 PM
To: Gavi
couple occurances of
"line_segment" to "coordinates" line_segment was just the column name I was
using in my original query.
Regards,
Gavin Towey
-Original Message-
From: René Fournier [mailto:m...@renefournier.com]
Sent: Thursday, December 17, 2009 8:54 AM
To: Gavin Towey
C
1 - 100 of 181 matches
Mail list logo
