innodb – tokudb, rocksdb or aria engine with a large number of tables

My question is which engine should be used with a very large number of tables and many tables with a few million lines.

My table quantity is increasing and almost 100,000 tables are reached …

With innodb : I have experienced crashes of more than 10 000 crashes … and the startup time of MySQL exceeds 5 to 15 minutes.

With ARIA Engine: Much better and less memory with fast start, but when a table reaches several million lines, a repair is done by sorting a lot and corrupting CPU / memory.

With RocksDB : with more and more spreadsheet -> takes longer to start AND is memory required (eats a lot of RAM) … Example: from 5% memory to 80% memory in less than a few hours πŸ™

With TokuDB : but want more feedbacks.

Do you think that TokuDB is a good long-term candidate for this type of deployment?

The next large condominium will be launched in 2019

Some important Condo launches that are worth a look at in 2019.
If you are looking for the East, there is Treasure at Tampines along Tampines Street 11 by Sim Lian Group.
To the west there is the One Normanton Park as well as the Parc Clematis.
In District 19, a mega facility with more than 1,000 units known in the former Florence Regency as The Florence Residences. Continue reading now.
For more new events, please visit the Singapore Property
Zoom out

This post has been edited by speed147: Today, 12:50

Handling large filter options

I'm working on a gaming website project where users go through a lot of data and search results. On a search page, users can search historical platforms.
The problem is that there are over 120 platforms, and the vast majority of them are "legacy" and may be irrelevant to the majority of users.

Is hiding all options considered bad practice? And if not, what could be a good approach, maybe behind a search box?

Many Thanks!

search filters

Game platform dropdown

Mobile App Development Tool – Kony

If you want to build your mobile app from scratch, there are a number of tools available as part of advanced mobile app technologies. The tools below are ideal for developing a complete app from scratch, and provide multi-platform capabilities to reach a broad audience. Echo Innovate IT has put together a list of mobile app development tools that help you create a bug-free app from scratch.


When Kony connects to a single IDE, a developer can create JavaScript apps that run on all platforms. However, this tool is a bit of pinching the bag, especially if you want to create more than one mobile app, want more than a hundred users, etc.

The Kony mobile app development tool can support a variety of things including API management, catboats, voice, customer reporting, augmented reality, reference apps and many more. While the tool itself can be installed on both Windows and Mac computer systems, the associated mobile apps are used for previewing and testing on the device on which it is to run.


Ease of Use – Expandable Lines, Quick View, or Modal View to display a large section of details for a row in a table.

I have a spreadsheet and in the first version of the implementation I had extensible rows with info. In the new version, the client wants extensible sections in the expanded section, as there is much information.

What is the best option, in this case expandable lines (with other extensible sections / text only), quick view or modality? Which case offers a better user experience?

I'll add some photos from as details for the three cases.
Enter the image description here

Enter the image description here

Enter the image description here

google search – SEO – how to deal with a large number of URLs that are not anchored

I have a hypothetical page that contains the following pages:

I can have thousands of such pages. The page count may increase slightly from day to day, but existing pages should not change drastically too often. There will be no index of these pages (to limit the exploitation / scrapping of data on the pages). Users should be able to find the page only by searching on this website or preferably Google (or another search engine).

What is the best way to inform Google or other search engines about these pages and their content so that they can offer them in the search results?

Is the dynamic generation of sitemaps sufficient? Is there any advanced material on this topic that I should study?

[WTS] DEDICATED SERVERS – 35% off for 3 months

Are you interested in Dedicated high-end server hosting services?

Cento host was one of the leading providers of web hosting services since 2002, We use the latest Dell server technology in our own data center to ensure that our customers get the best performance from their websites. Our wide selection of web hosting services is tailored to your hosting needs, whether you are building a small, simple website or a high-performing, high-traffic website. Our main goal is to provide the best available technology with exceptional customer support. With a large customer base there are many requirements for web hosting. We have tailored our company to these needs through flexible and scalable services.

SPECIAL OFFER: The first 3 months – 35% discount

Our dedicated servers are located in own data center in Europe – Bosnia and Herzegovina, You get serial console access with performance servers. You can also install and customize applications.

Our functions:

  • Unmeasured bandwidth
  • Free DDoS protection
  • IPv6 ready
  • Free setup
  • Free hardware RAID
  • Fast setup
  • Dell PowerEdge server
  • Guaranteed resource
  • server monitoring
  • Remote reboot
  • Single and double CPUs

Take a look at Centohost Dedicated server for beginners:
Start with a dedicated server within your budget – (Unmeasured Bandwidth + Free DDoS Protection + IPv6 Capable + Free Setup)

PE R320 server package
Six Core Xeon E5-2420v2
Speed ​​- 6 cores x 1.9 GHz
Memory – 16GB DDR3
Hard disk – 2 TB (2 x 1 TB SATA3)
Bandwidth – unmeasured
PRICE – $ 129 / month – $ 83.85 / month – ORDER NOW

PE-R320 Server Package – 2
Six Core Xeon E5-2440
Speed ​​- 6 cores x 2.4 GHz
Memory – 16GB DDR3
Hard disk – 2 TB (2 x 1 TB SATA3)
Bandwidth – unmeasured
PRICE – $ 144 – $ 93.60 / month (3 months 35% off) – ORDER NOW

You can also try Centohost Performance-dedicated server:
More powerful servers for medium and large projects – (Unmeasured Bandwidth + Free DDoS Protection + IPv6 Capable + Free Setup)

PE R610 Server Package – 1
2 x 6 core Xeon X5650
Speed ​​- 12 cores x 2.7 GHz (+ HT)
Memory – 32 GB DDR3
Hard disk – 2 TB (2 x 1 TB SATA) SAS Optional
Bandwidth – unmeasured
PRICE – $ 243 – $ 157.95 / month (3 months 35% off) – ORDER NOW

PE R610 server package – 2
2 x 6 core Xeon X5670
Speed ​​- 12 cores x 2.93 GHz (+ HT)
Memory – 32 GB DDR3
Hard disk – 2 TB (2 x 1 TB SATA) SAS Optional
Bandwidth – unmeasured
PRICE – $ 259 – $ 168.35 / month (3 months 35% off) – ORDER NOW

PE-R710 server package – 3
2 x 6 core Xeon X5670
Speed ​​- 12 cores x 2.93 GHz (+ HT)
Memory – 32 GB DDR3
Hard disk – 2 TB (2 x 1 TB SATA) SAS Optional
Bandwidth – unmeasured
PRICE – $ 274 – $ 178.10 / month (3 months 35% off) – ORDER NOW

PE R620 server package
2 x 8 Core Xeon E5-2670
Speed ​​- 16 cores x 2.60 GHz (+ HT)
Memory – 64 GB DDR3
Hard disk – 2 TB (2 x 1 TB SATA) SAS Optional
Bandwidth – unmeasured
PRICE – $ 369 – $ 239.85 / month (3 months 35% off) – ORDER NOW

Included in the dedicated server:
Fast setup (In most cases, our servers will be ready for use within 4 hours of your order.)
IPv4 and IPv6 network (All dedicated servers contain both IPv4 and IPv6 network connections and addresses.)
Unfulfilled traffic (All our dedicated servers come with unlimited data transfer.)
No set-up price (All of our dedicated servers are completely FREE, even if you pay monthly.)
Free DDoS protection (All dedicated servers in our offering are protected with an advanced DDoS protection system.)
Free hardware RAID (We offer a FREE hardware RAID controller with all our performance servers.)

=== >> Write us:
Centohost LLC
7260 W. Azure Dr Ste 140-796
Las Vegas, NV 89130, United States
phone+ 1-702-323-3802
fax+ 1-702-323-3844

You are not sure which plan is best for you?
No problem. Send us a ticket with your questions and we will answer you with an offer. Free.


Numeric – Legendre polynomials that have been evaluated with large differences

I'm dealing with Legendre polynomials, including the first, the second, and the associated ones. However, I found the following:

in the[252]: = N[LegendreQ[30, 0, 3, Cosh[1]]]out[252]= -0.0681152


in the[251]: = LegendreQ[30, 0, 3, N[Cosh[1]]]out[251]= 1.18183 * 10 ^ -14 + 0

I do not know why the result is so different.

I tried to draw the graphic from $ LegendreQ[30,0,3,Cosh[x]]$ With $ x $ from $ {0,3} $The graphics showed me almost zero.

I do not know if that's a mistake or something. Need help!

User Behavior – Large Hover Menu / Navigation Menu – Categorically Bad UX?

Due to feedback from a handful of customers who did not understand what our menu icons mean, a hamburger icon has been removed from our navigation menu. This hamburger icon was used to expand the navigation menu.

Enter the image description here

Instead of the hamburger icon action, a hover event now extends the navigation menu:
Enter the image description here

Hover does not mean intention:

  • It's frustrating to hover over something and let it do something
    not intended.
  • Especially frustrating when hovering causes a full screen
    Animation that darkens the entire site with an opaque black and dark background
    extends a large menu.
  • What if the user wanted to click on a menu icon that has become

If you hover over an icon and start displaying a tooltip, this is the default solution to explain what an icon is / does, yes?

Is not it fair and reasonable not to say that subjectively?:

Unfortunately, this floating menu nav is just a bad UI / UX. Floating menus are an observable, industry-standard bad practice, especially as a solution to the problem we want to solve for our customers: Describe the importance of our menu icons.

Comparison – Better UX when comparing large copies on a mobile display

Unfortunately, you can not have and eat your cake. You have to compromise as smaller screens impose new restrictions on your previous design solution.

Something needs to be adjusted: whether it's your content layout or your user interface. Here are the pros and cons of each:

content layout

Pros: You can maintain your current content by reducing additional details until the user wants to read it.


  • Users lose the ability to compare multiple columns (although I'm not sure how they do this in your current example).
  • When you hide content, you take content that is visible and make it invisible. How will users discover this content?

UI layout

Pros: Allows you to manage a solution designed for other restrictions.

Disadvantage: Suppose this is browser based …

  • You'll most likely implement a kind of page-to-page scrolling interface that lets users move the columns. Unfortunately, this is not a natural way to scroll within a browser. This means that you must create signatures to inform the user about this new feature.
  • Considering your small screen and the fact that you want to create a simple reading environment, it also means that all the signifiers you use can create a subordinate experience.

There is no quick answer here. They need to explore different design solutions and test them with users to make sure they can access and read the information they need to make informed decisions.

Your best option most likely means redesigning the content layout by providing the user with clear and concise labels about the content available. The mobile view of Wikipedia offers an interesting use case here:

Wikipedia Mobile View