%;;
2: len 7; hex 5c1ba11c2a; asc \ *;;
3: len 4; hex 8010; asc ;;
4: len 9; hex 70697a7a6174657374; asc rtttest;;
5: len 9; hex 70697a7a6174657374; asc rtttest;;
6: len 3; hex 333638; asc 368;;
7: len 4; hex 8002; asc ;;
8: len 4; hex 8000; asc ;;
9: len 4;
put there.
Yup, right there it did, And that's the way I like it: kill the/a query, which
issues an error somewhere else we know if and how to handle in some
application, rather then letting a database server with a light load grind to
a halt.
My main problem at hand is why the server did nothing but seize up
gracelessly, rather then either dying (a last resort, but something we have
failovers for) or killing queries (which we can handle).
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
r did nothing but seize up
> > gracelessly, rather then either dying (a last resort, but something
> > we have failovers for) or killing queries (which we can handle).
>
> Uhuh. You may want to take this to the mysql-dev mailinglist, the good
> people there might have a
lly or in a session:
http://dev.mysql.com/doc/refman/5.1/en/server-
options.html#option_mysqld_default-storage-engine
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
s since it does not tell me what
> exactly happened. The server version is 5.1.45.
Can you access the error log of the server? That can probably shed more light
on the issue...
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ing MySQL plugins? Probably plenty out there
> already, too.
A plugin what for? Also time, money, effort. I didn't get hired as a MySQL-
plugin writer here, and my list of pet-projects for my personal time is rather
full at the moment :)
--
Rik Wasmus
--
MySQL General Mailing List
For
erver II - table_2a,table_2b.
>
> I want to join the table_1a with table_2b.
Options as far as I can see it:
1. Use a FEDERATED table (not advisable, excrutiatingly slow and inefficient).
2. Replicate table_2b from Server II to Server I if possible, and allow for a
small delay, and just run th
utput of
SHOW CREATE TABLE...,, but my guess is you had a UNIQUE key somewhere that got
violated when converting to NULL's to empty strings. If would require an ALTER
IGNORE TABLE... instead of a normal ALTER TABLE though.
That, or an outside source (code we cannot see querying for NOT NULL
On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote:
> (error code) 1064
> (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the right
> syntax to use near '"DMPPRuser") VALUES ('MYNAME')' at line 1
On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote:
> On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote:
> > (error code) 1064
> > (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax;
> > check the manual that corresponds to your MySQL server versi
On Wed, 2011-07-06 at 11:03 -0400, Martin Gainty wrote:
> Rik and Crew
Please keep your replies to the list only, I don't need to double on
e-mail...
> String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are
> enabled
> Column names are never surrounded by ticks or double quotes
> your number, and has
to fetch the appropriate record if it does which is costly in harddisk IO.
BTW: as this looks as a GeoIP query, based on IP, if the `start` & `end`
ranges cannot overlap, this is probably faster:
SELECT * FROM geo_query
WHERE 1988778880 > start
OR
AND writing to
both servers, look at clustering instead.
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
lename first
LEFT JOIN tablename second
ONfirst.some_id = second.some_id
AND first.id != second.id
WHERE second.id IS NULL
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
> I researched a lot on storing Hierarchical data in mysql tables.
> Below links :
>
> http://scvinodkumar.wordpress.com/2011/01/30/managing-hierarchical-data-in-
> mysql/ http://www.sitepoint.com/hierarchical-data-database-2/
>
> shows different ways to store.
>
> But is there any standard way
with a unique search condition, InnoDB locks only the index
record found, not the gap before it. For other search conditions, InnoDB locks
the index range scanned, using gap locks or next-key (gap plus index-record)
locks to block insertions by other sessions into the gaps covered b
> >-Original Message-
> >From: Peter Brawley [mailto:peter.braw...@earthlink.net]
> >Sent: Wednesday, August 31, 2011 10:40 AM
> >To: r...@grib.nl; mysql@lists.mysql.com
> >Subject: Re: locked non-existent row
> >
> >On 8/31/2011 4:50 AM, Rik Wasm
+--+---+
| Level | Code | Message |
+-----+--+---+
| Warning | 1292 | Truncated incorrect DOUBLE value: 'a' |
+-+--+---+
1 row in set (0.01 sec)
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
cent size database. We have had great experiences with Percona's
Xtrabackup (http://www.percona.com/docs/wiki/percona-xtrabackup:start) for
hotcopies, which also work with InnoDB. But on a heavily used db-server, it
DOES make sense to run the backup on a (unused) slave, there's s
/dev.mysql.com/doc/refman/5.1/en/kill.html
"If you have the PROCESS privilege, you can see all threads. If you have the
SUPER privilege, you can kill all threads and statements. Otherwise, you can
see and kill only your own threads and statements."
--
Rik Wasmus
--
MySQL Gener
't fit in memory could require another approach entirely for
query optimization.
Another good start would be to examine the output of mysqlreport, it will tel
you a lot.
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Looks very nice, Ill check it out next week. Thanks for the work!
--
Rik Wasmus
> After a very long hiatus from maintainership (several years), I have
> finally released a new version of MySQL-Diff, the CPAN module suite
> which also contains mysqldiff, a CLI-based frontend tool for
sh
>
> mysql -hlocalhost -uxxx
> ~$ mysqllocalhostxxx.sh
> Welcome to the MySQL monitor. Commands end with ; or \g.
What does 'which mysql' give you? Is it perhaps in 'alias -p'? And is there
perhaps a .my.cnf file in your users directory?
--
Rik Wasmus
--
,a) is good for searches on ONLY b or BOTH a & b, but bad for ONLY
a
- index (a) & index (b) is good for searches on ONLY b or ONLY a, and is
suboptimal for searching for BOTH a,b (although, faster then no index, but the
query optimizer has to choose which index to use, can'
ated indexes on a & b, it depends on the data, the
distribution of values, etc. No single answer here, test with your data and
you'll have the results.
If you need it often, I'd go for the combined index & let MySQL do the work,
which is probably fastest.
--
Rik Wasmus
--
d by
index(a,b), and index(b) by index(b,a), we don't need to add those, which
saves time on modifications.
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
> > DO NOT REPLY OFF-LIST
>
> Also, do not shout :-)
Ugh point taken, but why are you still replying to him off-list? Keep
inboxes clean! ;)
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
suspect that it doesnt. You cannot roll it back...
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Taking the question _very_ literal:
> A quick guess, or at least a starting point:
>
> SELECT key, data
, SUBSTRING_INDEX(GROUP_CONCAT(data ORDER BY data SEPARATOR ','),',',2)
> FROM myTable
> GROUP BY key
--
Rik Wasmus
--
MySQL General M
y on each partition, and the final result obtained merely by
> summing the results obtained for all partitions.
> - Achieving greater query throughput in virtue of spreading data seeks over
> multiple disks.
Not implemented yet... I personally have those 2 high on my wishlist ;
es of single ' and double "... And this is the line that fails, the
only occurance of ":
left join exams e on CONCAT("000",c.acc_number) = e.LastWordAccNum
Which my crystal ball tells me is probably a sign of improper escapes in shell
scripts. What happens if you r
enabled innodb.
Hm, is the mysql-client library the same as the mysql-server?
And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's actual
IP-address, forcing the TCP/IP connect instead of possible sockets) ?
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
iles for 'socket' definitions:
File Name Purpose
/etc/my.cnf Global options
/etc/mysql/my.cnf Global options (as of MySQL 5.1.15)
SYSCONFDIR/my.cnf Global options
$MYSQL_HOME/my.cnf Server-specific options
defaults-extra-file The file speci
> You keep repeating that, and I already replied to it the first time. If my
> answer isn't acceptable, spamming the question isn't going to make it
> better - or make people more inclined to help you, for that matter.
I concur
--
Rik Wasmus
--
MySQL General Mailing Lis
new projects. Use mysqli (mysql Improved) or PDO_MySQL. Also, learn to love
prepared statements.
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
> See "The unbearable slowness of IN()" at
> http://www.artfulsoftware.com/infotree/queries.php
Do you read your own links? Excerpt:
> In 5.0, EXISTS() is much faster than IN(), but slower than JOIN. In 5.5,
EXISTS() performs about as well as JOIN.
So judging by the subject line...
--
My
ht want to try:
SELECT * FROM iploc
WHERE start_ip < 1902800418
ORDER BY start_ip DESC
LIMIT 1
... at least, that is how we solved our geoip-performance problems. The NON-
overlappig part is crucial though.
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysq
xx files in the data directory. It causes mysql server
> starting failure.
Hm, what output
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
. It causes mysql server
> > starting failure.
Don't just delete the bin-files. First start with log-bin=off (or no log-bin
declaration). If that fails to start your server, show us the actual error.
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
> (1) What server fail to start, it always says that missing mysql.sock
I seem to remember some distro's switching over from mysql.sock so
mysqld.sock... is that mysqld.sock there after restart? If so, just update
your "socket" configuration accordingly / make it consiste
ient, run the UPDATE statement, en then check what the
SELECT shows? If it shows a correct result... the problem ain't in MySQL
itself.
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
> the message "ERROR 1005 (HY000): Can't create table
> '/tmp/#sql4a27_68eed1_0.frm' (errno: -1)"
Basics first:
1) Is the /tmp directory write & readable for the user mysql runs as?
2) Has the /tmp directory enough free space?
--
Rik Wasmus
--
MySQL General M
HERE `a.login` NOT_REGEXP
> '^anonymous[[:digit:]]{3,}$';
> Error:
>
> MySQL said
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'NOT_REGEXP '
It's
NOT
set password link
Johan mentions, and retire the old hash method.
(Do keep in mind password resets etc. also need to know about the multiple
hashing methods in use.)
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
0 (running in VirtualBox 4.3.20) it will fail to
> > start with the following error:
> >
>
>
>
>
> Have you found any resolution for this as I'm having the exact same
> issue?
>
> Thanks
>
>
>
>
> --
> MySQL General Mailing List
> For li
Dammit, that should've come from the other account with that
work-signature...
LENGTH() measures bytes, CHAR_LENGTH() measures characters. There's
little use for LENGTH() for anything else then raw bytes.
On Wed, Jun 3, 2015 at 10:29 PM, Robert Voliva wrote:
> information_schema.columns reports a character_set_name of 'utf8' and a
> collation_name of 'utf8_general_ci'
>
> O
On Wednesday 31 August 2011 16:39:52 Peter Brawley wrote:
> >> While a transaction in one thread tries to update a non-existent InnoDB
> >> row with a given key value, an attempt to insert that value in another
> >> thread is locked out. Does anyone know where this behaviour is
> >> documented?
> >
48 matches
Mail list logo
