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
Yes, normally convert from latin1 to binary, and from binary to utf8 (which
would also be the recipe to convert actual utf8 data which accidentally
ended up in latin1 columns to the proper definition without changing the
content). I would not know why that would take overly long for you.
An altern
Dammit, that should've come from the other account with that
work-signature...
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
Not a unicode one that I know of, converting it to latin1 for the grouping
works for that particular use case, but I can't make any promises how it'd
work on your entire set which may hold any unicode character, a lot of
which cannot be converted to latin1:
mysql> SET NAMES utf8;
Query OK, 0 rows
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
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
> 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
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
> (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
. 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
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
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
> 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
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
> 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
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
> Hi Rik,
>
> > Have you tried the _full_ user-identification (which is with host)?
> >
> > GRANT ALL ON somedb.* TO 'someone'@'%';
>
> Yes I had (and just tried to verify) but it didn't help.
Oops, didn't use reply-to-list instead
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
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 ;
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
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
> > 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
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
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
--
,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'
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
--
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
'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
/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
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
+--+---+
| 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
> >-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
And 'lockinfo' is most certainly in your index, a primary key is a special
kind of UNIQUE, but still unique. The INSERT cannot complete as the
(lockid,lockinfo) location (foo,bar) is locked, until commit or rollback. See
the index as a seperate storage from your normale table-rows which
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
hare.net/billkarwin/models-for-hierarchical-data (nice
concise comparison of 4 alternatives)
- http://www.amazon.com/Hierarchies-Smarties-Kaufmann-Management-
Systems/dp/1558609202/ref=ntt_at_ep_dpt_2
--
Regards,
Rik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
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
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
> 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
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 surrounde
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
s can be done in the server configuration, so no client/lasso
alterations are necessary.
--
Rik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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
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
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
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
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
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
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
%;;
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;
t's needed).
Thanks,
--
Rik Wasmus
Some more InnoDB Monitor Output:
=
110523 19:19:05 INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 45 seconds
-
BACKGROUND THREAD
-
srv_mast
I hope you went at least to www.mysql.com ;)
-> Second tab "Developer Zone".
-> First tab "Downloads" from the second menubar.
-> Select version of your database
-> Select your OS
-> Pick a mirror
-> Have fun
Rik
Op donderdag 16 december 2004 14:28, schre
admin runs without problems
Notes:
- this was on my development machine
- I'm not pushing mysql to the end when I use it (in a basic way)
- maybe not the nicest solution, but digging 2 days through documentation
isn't nice either.
- I got my lamp working in less then 2 hours.
Rik
&g
the reserved words area on the
mysql website Brian mentioned.
Anyway; it works
rik
Op vrijdag 15 oktober 2004 04:35, schreef Brian Reichert:
> On Thu, Oct 14, 2004 at 10:33:45PM -0400, Brian Reichert wrote:
> > I tried to create a table with a column named 'start'.
> >
admin and create new db/users/tables with it.
3/ I hope that installing php from source would be a solution.
Best regs and thx,
Rik
Op maandag 11 oktober 2004 00:44, schreef Michael Stassen:
> rik wrote:
> > Hello all
> >
> > Sitting stuck in an upgrade to mysql 4.1, I thought
t on what I do wrong, how I can run it smoothly?). Would really
appreciate help (and I believe with me many others with the same problem,
since googling many hours did'nt give me the right answer).
Thanks,
Rik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
56 matches
Mail list logo
