On 01/28/2014 01:38 PM, Jan Lindström wrote:
> I would like to know the most affecting InnoDB pain points the
> customers/potential customers first refer.
some random first thoughts:
* main table space defrag / shrink was mentioned already, even with
file-per-table this can still be an issue
nice, now one question...
what about views? how many columns?
what about spider engine with vertical partition? how many columns?
2014-01-30 Reindl Harald :
> http://dev.mysql.com/doc/refman/5.5/en/column-count-limit.html
>
> normally you have a serious problem if you reach that limits
> because i
http://dev.mysql.com/doc/refman/5.5/en/column-count-limit.html
normally you have a serious problem if you reach that limits
because it won't scale well and the scheme is at least
questionable
select(*) even with most empty will create large results
inserts/updates are much slower
Am 30.01.2014 1
hum, unireg is the "global" limit, there's some ideas to change the .frm
file and create a better one with less limits (drizzle database have it
done), but you have limits in each engine too, index size have limits, many
limits per engine exists, i think a max columns is just more one
how many col
I believe it's the same as in MySQL. It does depend on the engine your
table is using. By default it is probably InnoDB.
For the full details about the limits:
http://www.mysqlperformanceblog.com/2013/04/08/understanding-the-maximum-number-of-columns-in-a-mysql-table/
On Thu, Jan 30, 2014 at
it's a per engine (myisam,innodb,toku,aria,others) limit (maybe a global
limit too, but i don't know)
2014-01-30 AskMonty KB :
> Hello,
>
> A new question has been asked in "MariaDB FAQ" by robpaton:
>
> Hi there,
>
> What is the maximum number of columns a row c
Hello,
A new question has been asked in "MariaDB FAQ" by robpaton:
Hi there,
What is the maximum number of columns a row can have in MariaDB? I can't find
this info anywhere on the web.
Best regards,
Rob
To view or answer this q
sorry :) thanks sergei
2014-01-30 Sergei Petrunia :
> On Thu, Jan 30, 2014 at 05:00:36AM -0200, Roberto Spadim wrote:
>> hum... an idiot question, i didn't think it about before asking...
>>
>> why not allow one server running two tcp ports, or unix socket or
>> pipes or any other listening method
Hi!
On 27 Jan 2014, at 02:50, Rushi Shukla wrote:
> Hello
>
>
> I am a student of Dhirubhai Ambani Institute of Information and Communication
> Technology (DAIICT), Gandhinagar, India. I am really interested in going for
> GSoC 2014. I would like to contribute to MariaDB community and for it
On Thu, Jan 30, 2014 at 05:00:36AM -0200, Roberto Spadim wrote:
> hum... an idiot question, i didn't think it about before asking...
>
> why not allow one server running two tcp ports, or unix socket or
> pipes or any other listening method? each one using a scheduler style,
> TP (thread pool) or
Hi Jan,
(nice name btw... ;-) )
I'd add the following feature requests to the list:
- Being able to have different partitions of a table on different disks:
We have tables that have 4 partitions for each day (partitioned by time)
and hold 10 days of data. We have a (almost) constantly increasi
11 matches
Mail list logo
